Description
Advanced Excel Training Learn how to use Microsoft Excel from beginner to advanced level in a simple and practical way. This training is designed for students, workers, business owners, and anyone who wants to improve their Excel skills for work, business, or personal use. In this training, you will learn Excel fundamentals and basic navigation, basic formulas and important Excel functions, data management and conditional formatting, as well as advanced formulas and lookup functions. The classes are practical, easy to understand, and focused on helping you work faster and smarter with Excel.
Course Curriculum
Module 1: EXCEL FUNDAMENTALS (BEGINNER LEVEL)
- Opening and creating workbooks , Understanding rows, columns, and cells , Saving files , Entering and editing data, Formatting cells (font, color, borders)
- AutoFill and Flash Fill , Page layout and printing , Freeze panes , Basic shortcuts
- Practice: Create a student score sheet and Create a simple household budget
Module 2: BASIC FORMULAS AND FUNCTIONS
- Arithmetic Formulas • Addition • Subtraction • Multiplication • Division • Percentage calculations
- Important Functions • SUM • AVERAGE • MIN • MAX • COUNT • COUNTA
- Practice:Employee salary sheet and Sales calculation sheet
Module 3: INTERMEDIATE EXCEL SKILLS
- Data Management • Sorting data • Filtering data • Remove duplicates • Data validation (drop-down lists) Conditional Formatting • Highlight duplicates •Color high/low values • Traffic light indicators
- Useful Functions • IF • AND • OR •IF ERROR Charts • Bar charts • Pie charts • Line charts
- Practice:Monthly sales dashboard and Attendance tracker
Module 4: ADVANCED FORMULAS AND FUNCTIONS
- Lookup Functions • V LOOKUP •H LOOKUP • X LOOKUP INDEX •MATCH
- Text Functions • LEFT • RIGHT • MID • CONCAT • TRIM Date & Time Functions • TODAY • NOW • DATEDIF • NETWORKDAYS
- Logical & Dynamic Functions • Nested IFs • IFS • FILTER • SORT • UNIQUE
- Practice • Employee database
- Practice :Inventory management system
Module 5: PIVOT TABLES AND PIVOT CHARTS
- Creating Pivot Tables • Grouping data • Summarizing reports • Slicers and timelines • Pivot Charts
- Practice :Sales performance analysis
- Practice:Business expense report