Course Title: Excel Fundamentals
Duration: 6 hours
Cost: R500
All learners get a certificate of attendance after the course.
Prerequisites:
- A computer with Microsoft Excel and Microsoft Teams installed.
- Basic computer skills, such as using a mouse and keyboard, managing files and folders, and navigating within the Windows environment.
Who Should Attend:
- Individuals new to Microsoft Excel or those needing a refresher on the basics.
- Roles in administrative, data entry, and support functions in organizations where data organization and analysis are required.
Why Microsoft Excel is Important in the Corporate World:
- Data Management: Excel provides powerful tools for organizing, formatting, and calculating data across diverse business contexts.
- Decision Support: Excel’s capabilities in data analysis and visualization support critical decision-making processes.
- Productivity and Efficiency: Automating tasks in Excel reduces time spent on data management, increasing overall productivity.
- Integration: Excel’s integration with other Microsoft Office applications like Word and PowerPoint streamlines workflow and data presentation.
Course Content:
Module 1: Getting Started with Excel (1 hour)
- Launching Excel and exploring the interface
- Understanding workbooks and worksheets
- Basic navigation: entering, editing, and managing data
Module 2: Data Entry and Manipulation (2 hour)
- Efficient techniques for entering data
- Using basic formulas for arithmetic calculations
- Managing data: inserting, deleting, and formatting cells, columns, and rows
Module 3: Formatting Data (1 hour)
Applying text formats: font types, sizes, and colors
Adjusting cell borders and background colors
Setting up data for presentation: alignment, text control, and number formatting
Module 4: Basic Calculations and Functions (1 hour)
- Understanding and using functions like SUM, AVERAGE, and COUNT
- Introduction to logical operators
- Absolute and relative cell referencing
Module 5: Organizing Worksheet Data (1 hour)
- Sorting and filtering techniques to manage data
Module 6: Creating Charts and Basic Data Visualization (1 hour)
Introduction to creating and formatting charts
Customizing chart elements for clearer data presentation
Practical tips for effective data visualization within Excel