Advanced Excel Guru

Welcome to Become an Excel Guru, step-by-step learning course where you are going to learn everything you need to know to become an Excel expert. For the last ten years we’ve been using Excel to build advanced tools and applications in the investment banking and financial services industries.

So, you probably already know the basics of Excel and you use it in your job on a daily basis, and you’re looking to learn more about Excel.

Course Content:

Module-I – Excel Foundation 

• Getting Started with Excel
• Data Entry, Data Editing, and Number Formatting
• Data Formatting
• Working with Cells and Ranges in Excel
• Managing Worksheets
• Save Your Worksheets

Module-II – Formula | Data | Charts Concepts

• Formula Basics & Cell References
• Auto Fills & Custom Lists
• Working with Basic Excel Functions
• Using Smart Tables
• Sorting & Filtering Data
• Working with Conditional Formats
• Working with Charts

Module-III –  Using Advanced Functions

• Working with Named Ranges
• Using Complex Excel Functions
• Using Multi-sheet Formulas
• Using Advanced Filters
• Data Validation & Protection
• Consolidation & List Management
• Automating with Macros

Module-III – Reporting & Dashboards 

• Business Reporting with Excel Dashboards
• Advanced Charting & Visualizations
• Using Sparkline Charts
• Creating Interactive Dashboard Reports

Module-IV – Working with Macros & Custom Functions 

• Writing Customized Macros
• Using What-If-Analysis
• Working with Financial Functions
• Creating Custom Excel Functions

International Student Fee : 150 USD

Trainer profile:

Trainer: Mr. Kashif uddin

Sir Kashif is Microsoft Certified Trainer, Industry Experience Trainer, Delivered 100+ sessions.
Professional Background: IT trainer at IBA, Sr. learning technology facilitator at Agha Khan education service.

Related Courses

Computerized Accounting Course 

Advanced Excel Guru 

MS Office Complete Course 

Financial Modeling Course

Microsoft Certified Solutions Associate (MCSA) Office 365

[/vc_column_text]