#Basic Digital Skills MICROSOFT EXCEL FOR BEGINNERS
Course Duration: 6 weeks
Created By: CYRIL FELIX
Last Updated: Monday, January 20th 2025
₦ 0
5 Stars Rating (1000 ratings)
Enroll Now
866 already enrolled
Scholarship Opportunity

About this course

Microsoft Excel is a powerful spreadsheet application developed by Microsoft, widely used for organizing, analyzing, and visualizing data. A spreadsheet is like a large grid where you can input data into individual cells (boxes). Excel helps you work with this data in a highly structured and flexible way, offering numerous tools for calculations, data analysis, and presentation. Excel is a part of the Microsoft Office suite, and it is used by individuals and businesses worldwide for tasks ranging from simple calculations and lists to complex financial analysis and reporting.

What you will learn

Module 1

Data Organization and Management

Data Analysis and Visualization Financial Modeling and Budgeting Automating Repetitive Tasks

Summary of What Microsoft Excel is

Excel Layout: Understanding the Interface

How to Create, Open, Save, and Close Excel Workbooks

Selecting Non-Adjacent Cells

Data Entry and Basic Formatting

Copying Data

Basic Formatting: Font Style, Size, Alignment, Text Wrapping, Borders, and Background Color

Module 2

Data Entry and Basic Formatting

Copying Data

Basic Formulas and Functions

Module 3

Sorting and Filtering Data

Module 4

Charts and Data Visualization

Creating Simple Charts to Represent Data Visually.

Formatting and Customizing Charts: Titles, Labels, Colors, and Legends

Introduction to Conditional Formatting

How to Apply Data Bars

Using Formulas

Module 5

Introduction to PivotTables

Module 6

Summarizing Data Using PivotTables: Sums, Counts, Averages

Tool

Personal computer

3
4