Content
Let’s have a look at what skills you will learn in this excel data analysis course. Learners will come across various excel functionalities that are useful for a data analyst. They will learn about advanced data sorting, conditional formatting and cell referencing, v-lookup, h-lookup, cell referencing and so on. A beginners’ session will be conducted to cover the basic concepts of MS Excel 2010. Concepts such as data entry, calculations, formulas, formatting, updating calculations, conditional formatting, graphs, charts, sorting, and filter, etc. will be explained.
Learners will gain an understanding of Gantt charts and data series in those graphs. This Excel Data Analysis Course includes 24 Excel courses with 128+ hours of video tutorials and Lifetime access. • Fill the weight percentage value of homework assignment and exam in the respective cells as shown below. Each homework assignments worth is 25 points and exam worth is 100 points. Transform your team through best-in-class, vendor-certified IT and process training, delivered in classroom and online by our award-winning trainers. Expert instructors with real world experience and the latest vendor-approved in-depth course content.
Certificate of Completion
The course will conclude with a discussion on the presentation of pivot tables. In this part, we will discuss stock analysis, project dashboard, company dashboard and a case study on sales analysis. An introductory lecture will be delivered on pivot tables to explain its features and formatting. This particular training is formulated from the perspective of data analysts. Data analysts will be able to solve real-life business problems by making use of data analysis features in Excel, after undergoing this course.
How do I start learning data analysis in Excel?
- Step 1 – DATA CLEANING USING TEXT TO COLUMN. SELECT FIRST COLUMN AND THEN GO TO THE DATA AND SELECT “TEXT TO COLUMN”.
- STEP 2- CONDITIONAL FORMATING. By using Rules, you can specify any number of formatting conditions.
- Step 3 – SORTING AND FILTERING.
- STEP 4 – PIVOT TABLES.
In this lesson, you will learn how to use Excel’s consolidation function to efficiently summarize data from multiple sources. Many Excel users do this the hard way, but with Excel’s automatic consolidation feature, you will no longer need to develop a web of formula links to multiple sources. Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables. Microsoft Excel 2019. Data Analysis Lessons This course is designed in such a way that going through this excel data analysis course will make you realize how masterful you can become on MS Excel. The sales productivity dashboard will be discussed with the help of a project. In this project, concepts such as database creation, formatting, index, business analysis, zone state, consolidation, tenure and age group, moving average, etc. shall be covered.
Career Benefits
Another excellent technique to present a narrative with graphics is charts. They summarise data so that data sets are easier to grasp and analyze. Excel is well-known for its ability to organize and compute numbers. A chart is a visual depiction of data that uses symbols such as bars in a Bar Chart or lines in a Line Chart to represent the data. Excel offers a variety of chart kinds from which to pick, or you may utilize the Excel Recommended Charts option to examine charts tailored to your data and select one of those.
You can, for example, rank personnel first by department and then by the last name. To highlight a cell range containing three to five sets of values, each with its own threshold, point to Icon Sets and then click a set. For example, you might use a set of three icons to emphasize cells with sales of less than $80,000, $60,000, https://remotemode.net/ and $40,000. Alternatively, you may assign a 5-point rating system to autos and use a set of five icons. It was a joyful experience learning with you the core techniques of the excel so I must say you did a wonderful job on the relevant details. The stimulation works fine when all other things are working very well.
Microsoft Excel – Data Analysis with PivotTables (EXLPT) – 3 hours
Extend your professional development and meet your students where they are with free weekly Digital Learning NOW webinars. Attend live, watch on-demand, or listen at your leisure to expand your teaching strategies. Earn digital professional development badges for attending a live session.
- Join Excel MVP Oz du Soleil as he shares how to clean, organize, and analyze large amounts of data with ease using commands, features, and functions within Microsoft Excel.
- I have a Bachelors degree in Business and Accounting from Concordia College in Moorhead, I was a CPA and went on to get my Masters in Education Technology from Pepperdine in Malibu, California.
- Most organizations rely heavily on Microsoft Excel to consolidate, analyze, and report financial information and other important data.
- Statistical tools will be explained in the next session and topics such as central tendency, dispersion, correlation and regression, histogram, etc. will be covered.