By the end of this course, you will be able to
How to combine Excel functions and formulas to make your analysis and models more dynamic, and to explore the dynamic charts (Single and Multi-Array Charts).
Creating a professional cover page with CELL, RIGHT, LEN, and FIND functions, and then differentiating between COUNT, COUNTA, and combining IF with AND, and OR formulas.
Setting up data tables and pivot tables, combining 2 chart types (Column and line charts), and using advanced analysis techniques (Scenario, XLOOKUP, and CHOOSE).
Course details
- 1 h 49 m/32 lessons
- Last updated: 8/11/2022
- 1 learning resources
- Course completion certificate
Course Content
Section Objectives
Dynamic Time Period with IF Statement
Dynamic Totals with OFFSET Function
Scenario Analysis with x-lookup and Choose functions
Section Objectives
Dynamic Time Period with IF Statement
Dynamic Totals with OFFSET Function
Scenario Analysis with x-lookup and Choose functions
Statement Combining x-lookup and Choose functions
Hiding Rows and Testing Scenario Analysis
Conditional Formatting
Section Introduction
VLOOKUP Function
INDEX Function
INDEX_MATCH_MATCH Formula
GOAL SEEK
INDIRECT Function
CELL Function
COUNT and COUNTA Functions
Create LINKS
CoverPage with CELL Function
RIGHT, LEN and FIND Functions
Combining IF with AND, OR Functions
Section Introduction
Data Table
Pivot Table
Pivot Table_Timeline
Calculated Field
Section Introduction
Column and Line charts
Stacked Column chart
Dynamic Chart
Dynamic Chart Part 2
Section Introduction
Form Control
Form Control Part 2
About this course
Data analytics is the science of analyzing raw data to make conclusions about that information. It helps businesses in mastering performance optimization, performing well, gaining profit, and making strategically-guided decisions. It also depends on software tools which are spreadsheets, data visualization, reporting tools, and more. Therefore, this course will help you to transform your data analysis into insightful charts and combine excel functions and formulas to make your analysis and models more dynamic.
Course requirements and prerequisites
There are no requirements for this course. Your interest in the topic and your commitment to learning are all you need to achieve the utmost benefit from this course.
Mentor
Mohamed AbdelMegeed
Business Intelligence Consultant
6,729 Learners
3 Courses