What You'll Learn
- Navigating Worksheets and Workbooks
- Cell Referencing: Relative, Absolute, and Mixed References
- Basic Operators: +, -, *, /, ^
- Common functions: SUM, AVERAGE, COUNT, MAX, MIN
- Text Formatting and Data Cleaning
- Conditional Formatting
- Calculating Durations and Deadlines
- VLOOKUP, HLOOKUP, INDEX, MATCH
- Data Analysis and Interpretation
- Formatting and Customizing Charts
- Filtering and Grouping Data
- Adding Data Labels and Legends
- Creating and Using Array Formulas
- Advanced Data Analysis Techniques
- Creating Drop-Down Lists
- Restricting Data Entry with Data Validation
Requirements
- No prior knowledge required
- A computer with internet access
- Eagerness to learn
Who This Course is For
- Anyone who works with Excel on a regular basis
- Professionals using Excel everyday at work
- Anyone curious to master excel from beginner to Advanced
- Anyone hoping to maximize productivity, work more efficiently
Your Instructor
Experienced Instructor
Professional Educator
An experienced instructor with expertise in this field and a passion for teaching.
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Limited Time
Microsoft Excel Data Analysis: Become a Data Analysis Expert
Unlock Excel’s full power to clean, analyze, and visualize data—no experience needed to become a da…
17.99$ None% Off
Today
Limited Time
Excel for Everyone: Essential Skills for Work and Life
Analyze Data, Create Charts and Automate Tasks with Confidence
Free 100% Off
Today
Limited Time
Pivot Tables in Microsoft Excel: Pivot Table & Data Analysis
Learn Pivot Tables in Microsoft Excel to Boost Your Pivot Table & Data Analysis Skills.Total:
Free 100% Off
Today
Limited Time
Advanced Microsoft Word With Job Success
Beginner to Expert Level - Fundamentals, Copy Cut, Paste, Font Design, Typography, Cases, Indent, A…
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.