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 Excel Experience needed
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
Bright Path
Instructor at Udemy
4.1 Instructor Rating
786 Reviews
31,756 Students
12 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Expires in 3 days
Learn Advanced Excel: Formulas, Functions, VBA Macros
VBA Automation in Excel Unleash its True Power - Excel Macros and Dashboards: Automate and Analyze …
Free 100% Off
Today
Expires in 3 days
The Ultimate Microsoft Excel: Essential Comprehensive Guide
From Novice to Expert: Conquer Your Data Workflows with Confidence to Increase your Productivity an…
Free 100% Off
Today
Expires in 3 days
Excel Data Analysis Visualization with Management Technique
Learn to Create Powerful Excel Data Visualizations and Apply Proven Management Techniques for Smart…
Free 100% Off
Today
Expires in 3 days
The Complete Microsoft Excel Course: Beginner to Expert
Master Microsoft Excel from the Ground Up – Learn Formulas, Functions, Pivot Tables, Data Analysis,…
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.