What You'll Learn
- Introduction to Excel Functions and Their Syntax
- Understanding the Basics of Formulas
- Working with Cell References: Relative, Absolute, and Mixed
- Basic Arithmetic Operations in Excel
- Text Functions: CONCATENATE, LEFT, RIGHT, MID
- Logical Functions: IF, AND, OR, NOT
- Date and Time Functions: TODAY, NOW, DATEDIF
- Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP
- Combining Functions in a Single Formula
- Working with Array Formulas
- Advanced Text Manipulation Functions: TRIM, LEN, SUBSTITUTE
- Using Conditional Functions: SUMIF, COUNTIF, AVERAGEIF
- Statistical Functions: AVERAGE, MEDIAN, MODE, STDEV
- Error Handling Functions: IFERROR, ISERROR
- Creating Basic Charts: Column, Line, Pie
- Customizing Chart Elements: Titles, Labels, and Legends
- Introduction to Sparklines for Data Trends
- Creating Combo Charts for Comparative Analysis
- Advanced Graphical Elements: Data Bars, Color Scales, Icon Sets
- Using Macros to Automate Chart Creation
- Introduction to VBA for Custom Chart Functions
Requirements
- No prior Excel expertise is required, though a basic familiarity with the interface is helpful.
- Microsoft Excel installed on your computer (Excel 2013, 2016, 2019, 2021, or Office 365 recommended).
Who This Course is For
- Anyone looking to transform raw data into actionable insights and compelling visuals.
- Individuals preparing for roles that require strong Excel proficiency in data analysis and reporting.
- Students, professionals, and anyone who needs to analyze data and present findings clearly.
- Who want to learn Excel from the ground up, focusing on practical data skills.
Your Instructor
Bright Path
Instructor at Udemy
4.1 Instructor Rating
802 Reviews
32,209 Students
12 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Expires in 20 hours
Microsoft Excel Formulas and Functions For Basic to Expert
Master Every Essential and Advanced Excel Formula & Function to Boost Productivity, Analyze Data & …
Free 100% Off
Today
Expires in 20 hours
Microsoft Excel for Beginners: Excel for Everyday Use
Learn Essential Excel Skills to Organize Data, Create Reports, and Simplify Everyday Tasks with Con…
Free 100% Off
Today
Expires in 17 hours
Microsoft Excel - Excel Course For Beginners
Learn The Excel Essentials - Drop Down Lists, Charts & Graphs, Pivot Tables, Sorting, Filtering, LO…
Free 100% Off
Today
Expires in 17 hours
Microsoft Office Training : Master Excel, PowerPoint & Word
The All-in-One Microsoft Office Course for All Users: Excel, PowerPoint and Word
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.