Course Curriculum
Day 1:
Excel Basics and Introduction to Data Entry Morning Session (4 hours)
Introduction to Excel: Interface, ribbon, and basic navigation
Creating and saving workbooks Basic data entry and understanding data types (text, numbers, dates) Afternoon Session (3 hours)
Cell formatting options: fonts, colors, borders Introduction to basic formulas (SUM, AVERAGE) Simple functions (MIN, MAX, COUNT, COUNTA)
Day 2:
Formulae, Functions, and Data Management Morning Session (4 hours)
More complex formulas and cell references (absolute vs. relative)
Logical functions: IF, AND, OR Lookup functions: VLOOKUP, HLOOKUP
Afternoon Session (3 hours): Data validation techniques
Introduction to Tables: Creating, formatting, and using table-specific features Basic data sorting and filtering
Day 3:
Data Visualization and Intro to Data Analysis Morning Session (4 hours)
Creating charts and graphs Formatting charts and understanding different types of visualizations
Conditional formatting to enhance data presentation
Afternoon Session (3 hours)
Introduction to PivotTables: Creating and customizing PivotTables
Using PivotCharts Basic data analysis techniques
Day 4:
Advanced Excel Features Morning Session (4 hours)
More advanced functions: INDEX, MATCH, INDIRECT T
ext functions: CONCATENATE, LEFT, RIGHT, MID, TRIM
Date and time functions: TODAY, NOW, DATE, YEAR, MONTH, DAY
Afternoon Session (3 hours)
Introduction to Macros: Recording and using simple macros
Advanced data management: Removing duplicates, advanced filtering Linking data across sheets and files
Day 5: Integrative Use and Advanced Data Analysis Morning Session (4 hours) Advanced charting techniques and customizations Advanced PivotTable techniques, including slicers and timeline filters Integrating Excel with other applications (e.g., Word, PowerPoint) Afternoon Session (3 hours) Scenario analysis: Using what-if analysis tools, Goal Seek, and Solver Data consolidation across multiple sheets Course review and real-world project practice Q&A and final assessments
Course Curriculum
Course Highlights
This 5-day, 35-hour Excel course offers a comprehensive journey from basic navigation and data entry to mastering advanced functionalities like data analysis tools, PivotTables, and macros. Participants will gain hands-on experience through practical exercises, enabling them to apply Excel skills effectively in professional and academic settings.
Comprehensive Curriculum: Covers everything from Excel basics, like navigation and data entry, to advanced functionalities including complex formulas, PivotTables, data visualisation, and macros.
Hands-On Learning: Each session includes practical exercises and real-world case studies, ensuring participants can apply Excel skills effectively in their professional or academic environments.
Professional Skill Development: Equips participants with essential skills required in various fields such as business, finance, research, and administration, enhancing job performance and career prospects.
Expert Instruction: Taught by experienced instructors who specialize in Excel and are adept at guiding both novice and intermediate users through gradually advancing course material.
Interactive and Engaging Format: Engages students through interactive sessions that include live demonstrations, Q&A segments, and group discussions, fostering a dynamic learning environment.
Certification of Completion: Participants will receive a certificate upon completion of the course, validating their expertise in Microsoft Excel to employers and professional networks.
Who should do this course?
Business Professionals: Individuals in roles like business analysis, finance, accounting, marketing, and operations who use Excel for data analysis, budgeting, financial modeling, and reporting.
Project Managers and Engineers: Professionals who manage projects and use Excel for project tracking, timeline management, and resource allocation.
Sales Professionals: Sales managers and representatives who track sales data, performance metrics, and client information in Excel.
Human Resources Professionals: HR personnel who manage employee data, including payroll, performance metrics, and other key HR data.