Open
+971 4 354 7997
Info@chicagomti.com
Chicago Institute for Management Training
Toggle menu
Home
Our Purpose
Training Programs
Course List
Corporate Training
Career Counseling
Training Schedule
Easy Pass Programs
Diploma Certification
Diploma in Quantity Surveying
Contact Us
Enrollment Form
MS® Excel Training Program
Home
All Courses
Software Training
MS® Excel Training Program
Curriculum
5 Sections
20 Lessons
40 Hours
Expand all sections
Collapse all sections
Excel Basics
4
1.1
Introduction to Excel Interface
1.2
Formatting Cells and Worksheets
1.3
Basic Formulas and Functions
1.4
Data Entry and Validation
Data Management and Analysis
4
2.1
Sorting and Filtering Data
2.2
Conditional Formatting
2.3
Working with Tables and Ranges
2.4
Data Cleaning and Transformation
Advanced Formulas and Functions
4
3.1
Logical and Lookup Functions (IF, VLOOKUP, HLOOKUP, INDEX-MATCH)
3.2
Statistical and Financial Functions
3.3
Date and Time Functions
3.4
Error Handling in Formulas
Data Visualization and Reporting
4
4.1
Creating and Formatting Charts
4.2
PivotTables and Pivot Charts
4.3
Dashboard Creation
4.4
Automating Reports with Macros
Automation and Productivity Tools
4
5.1
Introduction to Macros and VBA Basics
5.2
Using Power Query for Data Automation
5.3
Excel Shortcuts and Productivity Tips
5.4
Real-World Case Studies and Applications
This content is protected, please
login
and
enroll
in the course to view this content!
Modal title
Main Content
