Advanced-Microsoft-Excel Course
Microsoft Excel is a leading and very high-demand office automation tool used all across industries, for example, Banks, Insurance, Telecom, Public Sector and many Small and Medium-size Organization to perform Complex calculations, Data Analysis, Reporting and Dashboards creation, understanding financial modeling, learning Advanced Excel is a highly valuable career Asset, a must-have criteria to qualify for many jobs!
Course participants will learn all the key Excel functions and features using Advanced Excel tools from basic to the mastery level of excel expertise, after completing the course participants would be able to perform their day-to-day job in more productive and professional way to improve organizational performance.
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
Related Courses
Computerized Accounting Course
Microsoft Certified Solutions Associate (MCSA) Office 365
[/vc_column_text]
