Read more
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
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
Stay connected even when you’re apart
Join our WhatsApp Channel – Get discount offers
500+ Free Certification Exam Practice Question and Answers
Your FREE eLEARNING Courses (Click Here)
Internships, Freelance and Full-Time Work opportunities
Join Internships and Referral Program (click for details)
Work as Freelancer or Full-Time Employee (click for details)
Hire an Intern
Flexible Class Option
Week End Classes For Professionals SAT | SUN
Corporate Group Training Availables Options
Online Classes – Live Virtual Class (L.V.C), Online Training
Related Courses
Computerized Accounting Course
0 Reviews