What You'll Learn
- Overview of Microsoft Excel Interface
- Workbook and Worksheet Management
- Basic Formatting Techniques
- Saving and Printing Workbooks
- Basic Formulas (SUM, AVERAGE, MIN, MAX)
- Relative, Absolute, and Mixed References
- Logical Functions (IF, AND, OR, NOT)
- Text Functions (LEFT, RIGHT, MID, CONCATENATE, TEXTJOIN)
- Date and Time Functions (TODAY, NOW, DATEDIF, EOMONTH)
- Sorting and Filtering Data
- Data Validation and Drop-Down Lists
- Conditional Formatting
- Using Slicers and Timelines
- Subtotals and Grouping Data
- Descriptive Statistics with Data Analysis Toolpak
- Scenario Manager, Goal Seek, and Data Tables
- Creating and Formatting Charts (Column, Line, Pie, Bar, Area)
- Advanced Charts (Combo Charts, Sparklines, Waterfall)
- Lookup Functions (VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP)
- Array Formulas and Dynamic Arrays (SEQUENCE, FILTER, SORT)
Requirements
- No prior knowledge required
- A computer with internet access
- Eagerness to learn
Who This Course is For
- Anyone who wants to save time and get the most out of Microsoft Excel.
- Anyone who wants learn Microsoft Excel.
- Students and professionals who want to improve their excel skills.
- Entrepreneurs and office workers who prepare financial report regularly.
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
The Complete Microsoft Excel Course: Master All Levels
Learn Excel the smart way — automate tasks, analyze data, and make informed business decisions.
Free 100% Off
Today
Limited Time
Microsoft Excel: Master Formulas, Functions, and Data Tools
Learn Excel from the ground up — master formulas, functions, charts, and data analysis tools for re…
Free 100% Off
20 July 2026
Limited Time
Microsoft Office: Word, Excel, PowerPoint من الصفر للاحتراف
تعلم برامج الاوفيس ; الوورد , البوربوينت و الاكسل من المستوى المبتدئ للمستوى المتقدم - 3 كورسات في 1
None$ None% Off
20 July 2026
Limited Time
www.udemy.com
تعلم برامج الاوفيس ; الوورد , البوربوينت و الاكسل من المستوى المبتدئ للمستوى المتقدم - 3 كورسات في 1
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.