Advanced Excel Course
Learn Advanced Excel Skills for Business. Master Excel to add a highly valuable asset to your employability portfolio.
About The Course
Microsoft Excel has proven to be one of the most important applications for businesses around the world. Yet most of its powerful features are underutilized. Boost your productivity with an Excel training course and learn to utilize them to the full.
How Participant will be Benefited
Microsoft Excel allows you to manipulate, manage, and analyze data, which aids in decision making and creates efficiencies that have a direct impact on your bottom line. Whether you’re using it for business or to help manage your personal database and expenses, Microsoft Excel provides you with the tools you need to get the job done.
If you already have some experience with Excel and want to further boost your skills, this course will quickly amplify your knowledge of intermediate and advanced Excel functions.
Methodology
- Face to face interactive class
- Practical Case Studies
Contact Us
Who Can Attend?
This course is very useful for anyone who works in Excel. The target audiences are the Managers, Executives, Teachers, Developers, Students, and Researchers.
Certification & Duration
- Certificate: Yes
- Course Duration: 18 Hours
CONTENT OF PURE ADVANCED COURSE ON MICROSOFT EXCEL
Microsoft Excel has proven to be one of the most important applications for businesses around the world. Yet most of its powerful features are underutilized. Boost your productivity with an Excel training course and learn to utilize them to the full.
Cell References
Relative Reference
Absolute Reference
Mixed Reference
Fundamental Functions
- Sum | Sumif | Sumif with Numeric Criteria | Sumif with Text Criteria | Sumif with Date Criteria | Sumifs
- Average | Averageif | Averageifs
- Min | Minifs
- Max | Maxifs
- Count | Counta | Countblank | Countif | Countifs
Logical Functions
- Understanding Logical Functions
- Using IF With Text
- Using IF With Numbers
- Nesting IF Functions
- Using IFERROR
- Using TRUE and FALSE
- Using AND
- Using OR
- Using NOT
Validating Data
- Validating Data
Understanding - Data Validation
- Creating a Number
- Range Validation
- Testing a Validation
- Creating an Input Message
- Creating an Error Message
- Creating a Drop Down List
- Using Formulas as Validation Criteria
- Circling Invalid Data
- Removing Invalid Circles
Look-up Functions
- Understanding Data Lookup Functions
- Using CHOOSE
- Using VLOOKUP
- Using VLOOKUP for Exact Matches
- Using HLOOKUP
- Using INDEX
- Using Match
- Understanding Reference Functions
- Using ROW and ROWS
- Using COLUMN and COLUMNS
- Using ADDRESS
- Using INDIRECT
- Using OFFSET
Data Consolidation
- Understanding Data Consolidation
- Consolidating Data with Identical Layouts
- Creating a Linked Consolidation
- Consolidating Data with Different Layouts
- Consolidating Data Using the SUM Function
Scenarios
- Understanding Scenarios
- Creating a Default Scenario
- Creating Scenarios
- Using Names in Scenarios
- Displaying Scenarios
- Creating a Scenario Summary Report
- Merging Scenarios
Excel Date Functions
- DATE function
- TODAY
- NOW
- DATEVALUE
- TEXT
- DAY
- MONTH
- YEAR
- EOMONTH
- WEEKDAY
- WEEKNUM
- DATEDIF
- EDATE
- YEARFRAC
- WORKDAY
- WORKDAY.INTL
- NETWORKDAYS
- NETWORKDAYS.INTL
Chart
- Pie
- Bar
- Column
- Line Chart
- Map
- XY Scatter Chart
- Spark Line Chart
- Combo
Pivot Tables
- Understanding Pivot Tables
- Recommended Pivot Tables
- Creating Your Own PivotTable
- Defining the PivotTable Structure
- Filtering a PivotTable
- Clearing a Report Filter
- Switching PivotTable Fields
- Formatting a PivotTable
- Understanding Slicers
- Creating Slicers
- Inserting a Timeline Filter
Pivot Table Features
- Using Compound Fields
- Counting in a PivotTable
- Formatting PivotTable Values
- Working With PivotTable Grand Totals
- Working With PivotTable Subtotals
- Finding the Percentage of Total
- Finding the Difference From
- Grouping in PivotTable Reports
- Creating Running Totals
- Creating Calculated Fields
- Providing Custom Names
- Creating Calculated Items
- PivotTable Options
- Sorting in a PivotTable
Power Pivot
- What is Power Pivot
- Getting data from Power Pivot
- Data Modeling Techniques
- Building Measures with DAX
Power Query
- What is Power Query?
- Importing Data
- Appending Tables
- Merging Tables
- Data Transformation
Record Macros
- Understanding Excel Macros
- Setting Macro Security
- Saving a Document as Macro Enabled
- Recording a Simple Macro
- Running a Recorded Macro
- Relative Cell References
- Running a Macro With Relative References
- Viewing a Macro
- Editing a Macro
- Assigning a Macro to the Toolbar
- Running a Macro From the Toolbar
- Assigning a Macro to the Ribbon
- Assigning a Keyboard Shortcut to a Macro