Have a question?
Send enquiry
Message sent Close
0
0 reviews

Excel 2024

The Microsoft Excel 2024 course will provide participants with the knowledge to confidently navigate the program, learning how to organize and analyze ... Show more
Instructor
Admin
Category
IT and Software
  • Description
  • FAQ
  • Notice
  • Reviews

Microsoft Excel 2024

Microsoft Excel 2024 is the latest evolution of Microsoft’s spreadsheet software, which has been a cornerstone of data management and analysis since its initial release in 1985. Over nearly four decades, Excel has grown from a simple spreadsheet tool into a powerful platform used across industries for organizing, analyzing, and visualizing data. Known for its versatility, Excel helps users perform complex calculations, create dynamic charts, and manage large datasets with ease. Excel 2024 builds on this foundation with new features like dynamic arrays, and the IMAGE function, enabling more advanced data analysis and enhanced visual presentations.

The Microsoft Excel 2024 course will provide participants with the knowledge to confidently navigate the program, learning how to organize and analyze data effectively, create visually engaging charts and reports, and streamline workflows with time-saving tools. Additionally, participants will use Excel’s features to manage, present, and share data with clarity and precision

 

Who should attend?

This course is for everyone

 

Introduction

  1. Course Objectives

Module one

  1. Introduction to Excel 2024

  2. Understanding Excel’s Interface and Navigation

  3. Creating, Saving, and Managing Workbooks

  4. Working with Worksheets: Adding, Renaming, and Deleting

  5. Using the Ribbon, Quick Access Toolbar, and Context Menus

  6. Exploring New Features in Excel 2024

  7. Knowledge Check

Module two

  1. Working With Data

  2. Entering and Editing Data Efficiently

  3. Transforming Data With Power Query

  4. Applying Data Validation and Drop-Down Lists

  5. Sorting and Filtering Data (Dynamic Arrays)

  6. Using the New IMAGE Function to Insert Images in Cells

  7. Knowledge Check

Module three

  1. Formulas and Functions

  2. Understanding Cell References (Relative, Absolute, Mixed)

  3. Working With Basic Formulas (SUM, AVERAGE, COUNT)

  4. Using Logical Functions (IF, AND, OR, IFERROR)

  5. Exploring Text and Date Functions (TEXT, CONCAT, TODAY)

  6. Leveraging New Functions (FILTER, SORT, UNIQUE, SEQUENCE)

  7. Knowledge Check

module four

  1. Practical Problem-Solving With Excel

  2. Creating Budgets and Expense Trackers

  3. Building Basic Schedules and Calendars

  4. Using Excel for Simple Project Management (Gantt Charts)

  5. Tracking Inventory and Sales Data

  6. Analyzing Data with Built-in Templates

  7. Knowledge Check

Module five

  1. Data Visualization and Charting

  2. Creating Basic Charts (Column, Line, Pie)

  3. Customizing Charts: Titles, Legends, and Data Labels

  4. Using Dynamic Charts With Dynamic Arrays

  5. Building Pivot Charts for Advanced Reporting

  6. Enhancing Visuals with Sparklines and Maps

  7. Knowledge Check

Module six

  1. Managing and Analyzing Large Data Sets

  2. Working With Tables: Creating, Formatting, and Summarizing

  3. Using PivotTables for Data Analysis

  4. Applying Slicers and Timelines for Interactive Reports

  5. Leveraging Conditional Formatting for Data Insights

  6. Exploring Data Tools: Remove Duplicates, Text to Columns, and Flash Fill

  7. Knowledge Check

Module seven

  1. Collaboration and Sharing

  2. Sharing Workbooks and Managing Permissions

  3. Real-Time Collaboration and Co-Authoring

  4. Tracking Changes and Using Comments/Notes

  5. Exploring Excel Online Integration

  6. Managing Versions and Using Revision History

  7. Knowledge Check

Module eight

  1. Time-Saving Tips and Tricks

  2. Using Keyboard Shortcuts to Speed Up Workflows

  3. Navigating Large Workbooks With Freeze Panes and Split Windows

  4. Using Find & Replace and Go To Special for Quick Edits

  5. Customizing Excel Settings for Personal Efficiency

  6. Working With Templates for Faster Document Creation

  7. Knowledge Check

Module Nine

  1. Data Security and Protection

  2. Protecting Worksheets and Workbooks With Passwords

  3. Managing Permissions for Sensitive Data

  4. Using Data Masking and Cell Locking Techniques

  5. Implementing Workbook-Level Security (Encryption)

  6. Auditing and Error Checking (Trace Dependents/Precedents, Evaluate Formulas)

  7. Knowledge Check

Module ten

  1. Personalizing Excel for Everyday Use

  2. Customizing the Ribbon

  3. Creating and Managing Named Ranges

  4. Adjusting Themes, Styles, and Formatting Options

  5. Setting Up Print Options and Page Layouts

  6. Saving and Exporting Workbooks in Different Formats

  7. Knowledge Check

Question 1
Answer to question 1
Question 2
Answer to question 2

This a special notice to all students that this is a test course. Thank you.

Related courses
default-course
Get course ₦40,000
Excel 2024
Category:
IT and Software
Get this Course
Add to wishlist
Share
Course details
Duration 6 Months
Level Beginner
Popular courses

Working hours

Monday 9:30 am - 6.00 pm
Tuesday 9:30 am - 6.00 pm
Wednesday 9:30 am - 6.00 pm
Thursday 9:30 am - 6.00 pm
Friday 9:30 am - 5.00 pm
Saturday Closed
Sunday Closed