By the end of this course, you will be able to
Understand the basics of Excel and how to use it to manage and analyze data. Learn about advanced Excel functions such as INDIRECT, SUBSTITUTE, IF, AND, OR, COUNTIF, SUMIF, VLOOKUP, INDEX, and MATCH.
Understand the principles of conditional formatting and shading in Excel, as well as the use of pivot tables and pivot charts. • Analyze data, use techniques to find patterns and trends in data, and design executive reports based on specific criteria.
Use advanced functions and skills learned in Excel to solve data analysis problems and tasks in a real-world business setting. Designs effective reports and graphs that contribute to decision-making.
Recognize everything related to macros, and you can build your own analysis system using Excel.
Course details
- 3 h 21 m/49 lessons
- Last updated: 4/3/2019
- 4 Quiz
- 1 learning resources
- Course completion certificate
Course Content
Understanding How IF Function Works And Nested IF
Using OR, AND Functions With IF Function.
Introduction To VLOOKUP Function.
Text To Columns
Defined Names
Name Manager - Create from Selection.
Using INDIRECT Function to Extract Items from two-way lookup Tables
Using SUBSTITUTE Function To Handle The Name Errors With INDIRECT Function.
Relative, Absolute And Mixed Cell Reference.
Example: Mixed Cell Reference
Basic Function
How The Excel Understand The Logical Test
Understanding How IF Function Works And Nested IF
Example: Nested IF Function
Using OR, AND Functions With IF Function.
Example: AND,OR Together.
Build The First Report With COUNTIF Function With Chart.
Build The Second Report With SUMIF Function With Chart
Using SUMIFS Function To Build A Report Depend On Two Criteria.
Enhancement The Chart To Read It Effectively
Example: Extract The Report In New Sheet Using SUMIFS Function.
Introduction To VLOOKUP Function.
Problem Solving For VLOOKUP Using COUNTA Function.
Problem Solving For VLOOKUP Using COLUMNS Function.
Problem Solving for VLOOKUP using IF Error Function to Select from 2 Tables
Problem Solving For VLOOKUP Without Zero.
Using INDEX & MATCH Functions To Extract Items From Two-Way Lookup Tables.
Use Multiple Functions To Compare Two Lists Part #1
Use Multiple Functions To Compare Two Lists Part #2
Using the Search Function With the IF Function to Find Any Data
Problem Solving For Left Function Using Search Function.
Text To COLUMN And CONCATENATE Function
Text To Columns
Flash Fill
Conditional Formatting Techniques
Highlight All Rows Based On One Criteria.
Highlight All Rows Based On Two Criteria
Pivot Tables And Pivot Chart In Depth
Changing The Method Of Aggregation In A Pivot Table
Top 10 Analysis With Excel Pivot Tables
Show Value as Percentages in Excel Pivot Tables
PivotTable For Yearly Percentage Change Calculations.
How Is The Advanced Filter Works?
Using Logical Test To Extract Advanced Report From Advanced Filter.
Using ISNUMBER & SEARCH Function in Advanced Filter.
Find Top Five Total Number
Find Less Five Total Number
Using Wildcards In Advanced Filter
All About The Macros
How To Run The Macros
Record Macro For Advanced Filter
Step By Step To Build Your System Analysis Part#1
Step By Step To Build Your System Analysis Part#2.
About this course
Microsoft Excel is one of the most popular spreadsheet programs of all time. This course will allow you to master Excel and gain data analysis and management skills. We will start by teaching you the basics of Excel and help you develop skills in managing names and creating complex formulas using functions such as INDIRECT and SUBSTITUTE. We will also delve into how to use IF functions AND and OR to make informed decisions based on data. In addition, you will learn how to design complex reports using Excel arithmetic functions such as COUNTIF and SUMIF, and you will understand how to analyze data using VLOOKUP, INDEX, and MATCH. Additionally, we'll demonstrate conditional formatting techniques and how to shade data effectively. By the end of this course, you will gain the skills to build your own analysis system and this will allow you to make the most of data and make accurate business decisions. Join us and prepare for a unique journey into the world of data analysis using Excel!
Course requirements and prerequisites
This course requires the installation of Microsoft Excel on your device.
Some knowledge of the English language will also be of great help to you since the mentor uses the English copy of Excel.
Prior knowledge of data analysis is preferable.
Mentor
Ashraf Elsheikh
Founder & CEO Of Elite for Training and Web Designs
22,675 Learners
4 Courses