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
Job Interview Preparation (Soft Skills Questions & Answers)
- Tough Open-Ended Job Interview Questions
- What to Wear for Best Job Interview Attire
- Job Interview Question- What are You Passionate About?
- How to Prepare for a Job Promotion Interview
🎥 Your FREE eLEARNING Courses (Click Here)
Internships, Freelance and Full-Time Work opportunities
Flexible Class Options
- Week End Classes For Professionals SAT | SUN
- Corporate Group Trainings Available
- Online Classes – Live Virtual Class (L.V.C), Online Training
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
Microsoft Certified Solutions Associate (MCSA) Office 365