Core Excel Skills

Become an Expert of Advance Excel 2019 Financial Modeling & Valuation Analyst

About Advanced Excel

Advanced Microsoft Excel 2019 is designed for persons who already possess basic to intermediate knowledge of Microsoft Excel 2019.  Participants are introduced to the advanced features in Microsoft Excel 2019 where they will learn to calculate data using advanced formulas and functions, analyze data and use other advanced tools.

After successful completion, the students will be able to find patterns in data and classify them into useful groups, making it easier to interpret and view the data. Excel aids everything from classrooms to big corporations. Additionally, it handles human resources tasks that assist firms in understanding the composition and activities of their staff, such as categorising hours worked and arranging employee profiles and expenses. And that’s not all! Excel is used for making analysis reports, bookkeeping, attendance reports, and much more.

This course is divided into two levels to effectively cater to people’s requirements:

Interested? Let us contact you

Learning Outcomes

Primary Introduction of MS Excel 2019
Excel Tools with 14 Tabs + Bonus (Kutools Tab)
Pivot Table Techniques
250 Useful Formulas
Condition Formatting with 40 Rules
Filter & Advance filter Techniques
30 Practical Sheets Plus Excel Securities
Data Validation & Consolidation

25 Classical Excel Graphs
Excel 2019 Data Forecasting
Excel Printing Techniques
Flash Fill with What-if Analysis
Text BoxShortcut Techniques & 45 Shortcut Keys
Error Handling with Special Formulas with Paste Special
Invoice Handling & Power - Bi-Modeling
VLOOKUP & HLOOKUP from multiple Data Range.

5 Reasons Why You Should Do Advanced Excel

Course Plan

Week 1

Introduction of Microsoft Excel 2019
Excel Spreadsheet Structure introduction
Introduction of Excel Formulas
Sum, subtract, Divide, multiple, IF, Nested-if, count, Count if, CountA, Countifs
Differentiate b/w Average & Percentage
File Tab, Home Tab Tools
Table Designing & Shorting
Marksheet, Salary Sheet, Retirement Sheet
Excel securities & Shortcut Keys
Expenditure Sheet, Attendance Sheet
Dialogue Box and Task Panes
Tasks & Test Project

Week 2

Insert Tab Tools
Conditional Formatting (Data High-lighter) with 40 Rules
Excel Sheet (Budget Sheet, Library Sheet, Profit/Loss Sheet)
Column / Bar Chart, Line Chart, Pie Chart, Tree map, Histography)
Forecasting Analyzing
Navigating in Excel
Constituents of Excel Formula
Operators in Formula
Absolute cell Reference
Tasks & Test Project

Week 3

Insert Tab Tools
Pivot Tables Techniques
Hyperlinks the Data
Balance Sheet
Formulas (Sum, Sumif, Sumifs, Average, Average if, Averageifs, Subtotal)
Invoice Handling
Header / Footer Setting
Task & Test

Week 4

Creating Multi-Category Charts
Creating a Gauge Chart
Creating a Thermometer Chart
Creating a Milestone Chart
Creating a Water Fall Chart
Creating Gantt Chart
Creating Chart with Trend Arrows in Data Labels
Creating a Chart with Actual and Target Values
Spotting Data in a Scatter Chart in Excel
Creating Dynamic Target Line in Excel Bar Charts Course Falling / Running Plan

Week 5

Excel Hidden Tricks
Inventory with Stock Making Report
Data Validation Rules
VLOOKUP, HLOOKUP, Concatenate, Datedif, Networkdays, PMT
How to Adjust Long Sheet in One Page with 5 Techniques
Excel Shorting & Freezing Headings
Insert Water Mark
Day Book Report
Task & Test

Week 6

Function of Absolute Cell Reference with multiple examples.
Formulas (Round, Roundup, Rounddown, Product, SUMPRODUCT, Days360 )
Functions of New Microsoft” Kutools Tabs”
Kutools Tabs Tools & Groups (Ranges, Cells Group, Editing Group, Formulas, Mailing Group, Protect Group)
Data Tab Tools (Remove Duplicate, Flash fill, Transformation of Data)
What-if analysis
Group or Ungroup
Review & view Tab tools
Macros Function

First Name *

Last Name *

Email *

Phone No (with country code)

Nationality *

Date of birth *

City

I have read the privacy policy.