Duration: One Month
Format: Hands-on Practice Sessions + Assignments + Capstone Project
Master the fundamentals of Microsoft Excel with our comprehensive Basic Excel course. This course covers essential spreadsheet skills including data entry, formatting, basic formulas and functions, basic data analysis, and data management. You’ll learn to navigate Excel’s interface confidently, create professional-looking spreadsheets, and perform common business calculations. Perfect for beginners or professionals looking to solidify their Excel foundation.
Course Curriculum:
- Getting Started with Excel
- Navigating the Excel Environment: Understanding menus, ribbons, and workbooks.
- Formatting Excel Data: Applying font styles, alignment, and number formats.
- Preparing Data for Print: Setting up print areas and adjusting page layouts.
- Managing Data in Excel
- Cell Referencing Basics: Absolute, relative, and mixed references.
- Name Manager: Creating and managing named ranges for easy navigation.
- Tools for Data Cleaning: Removing duplicates, trimming spaces, and text-to-columns.
- Analysing and Working with Data
- Sorting and Filtering Data: Organizing data for better analysis.
- Simple Functions: SUM, AVERAGE, COUNT, DATE, TODAY, CONCATENATE, etc.
- Building Basic Formulas: Combining operators for calculations and logical functions.
Ideal For: Beginners, working professionals, or anyone new to spreadsheet software
