What You'll Learn
- Working with Date and Time Functions
- Lookup Functions (VLOOKUP, HLOOKUP, XLOOKUP)
- Introduction to Pivot Tables and Pivot Charts
- Using Excel for Basic Data Analysis
- Advanced Lookup and Reference Functions (INDEX, MATCH)
- Array Formulas and Dynamic Arrays
- Advanced Conditional Formatting and Data Highlighting
- Working with Complex Text Functions
- Creating and Customizing Charts and Graphs
- Building Interactive Dashboards
- Advanced Data Visualization Techniques
- Recording and Running Basic Macros
- Using Solver for Optimization Problems
Requirements
- No prior Excel experience needed
- A computer with Microsoft Excel installed (preferably Excel 2016 or later)
Who This Course is For
- Beginners with no prior Excel knowledge
- Intermediate users who want to expand their skill set
- Students, professionals, accountants, data analysts, or business managers
- Anyone preparing for jobs that require Excel proficiency or certification
Your Instructor
Bright Path
Instructor at Udemy
4.2 Instructor Rating
508 Reviews
23,852 Students
12 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Yesterday
Expires in 3 days
Office Productivity
English
Essential Microsoft PowerPoint Course for Everyone
Master the Art of Presentations: Power up Your PowerPoint Skills
Free 100% Off
21 August 2025
Expires in 1 day
Office Productivity
English
Excel for Everyone: Essential Skills for Work and Life
Analyze Data, Create Charts and Automate Tasks with Confidence
Free 100% Off
21 August 2025
Expires in 1 day
Office Productivity
English
Microsoft Excel Comprehensive Guide
How to use Excel in your career—a guide on simple functions, Excel tools, and chart creation
Free 100% Off
21 August 2025
Expires in 1 day
Office Productivity
English
Advanced Excel Course With Shortcuts Tips and Tricks for JOB
Master Advanced Excel Formulas. Solve Complex Problems. Learn Advanced Excel Skills to Save Time & …
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.