By the end of this course, you will be able to
Identify the Excel interface and navigation to work efficiently within the application and to master fundamental concepts such as data entry, formatting, and cell referencing.
Explore essential formulas and functions for data manipulation and analysis and to create dynamic charts and graphs to represent your data visually.
Recognize advanced techniques, including conditional formatting, data validation, and pivot tables. Moreover, you will discover tips and tricks to optimize your workflow and become a proficient Excel user.
Course details
- 7 h 39 m/60 lessons
- Last updated: 21/9/2023
- 15 learning resources
- Course completion certificate
Course Content
Excel Interface
Enter Data
Save Excel File
Copy & Paste Options
AutoFill & FlashFill
Excel Shortcut
Excel Interface
Enter Data
Save Excel File
Copy & Paste Options
AutoFill & FlashFill
Excel Shortcut
Data Format
Insert & Delete & Hide Column and Row
Worksheet Management
Assignment 1
Build Formula
Order of Operations
Insert Functions
Relative & Absolute References
Name Ranges
Format Cell
Manage Views
Error Codes
Assignment 2
Printing
Header & Footer
Assignment 3
Sort
Filter
Tables
Text To Column
Data Validation
Link Cells
Data Protection
Macro
Assignment 4
IF Function
SUMIF-AVERAGEIF-COUNTIF
VLOOKUP-HLOOKUP
3D Formula
Date & Time Functions
Text Function
Database Function
Assignment 5
Outline
Subtotal
Conditional Formatting
Chart
Pie Chart
Advanced Chart
Trendline
Pivot Table
Pivot Chart
Slicer
Timeline
Sparklines
Map Data
Assignment 6
PMT
Goal Seek
Data Table
Scenario
Forecasting
Assignment 7
Course Project
About this course
Microsoft Excel is considered one of the most powerful tools for managing and presenting data in the workplace today, used by millions around the world to accomplish their tasks. Therefore, this course has been designed to help you start learning Excel from scratch. You will learn how to process, analyze, and visualize data. Additionally, you can sort, filter, format, and chart your data, all within one program and in simple steps. Whether you want to organize your grade book and calculate averages automatically, or if you need to calculate the annual profit and compare it with previous years, all this and more can be achieved in one step using Excel.
Course requirements and prerequisites
Basic computer skills in addition to your interest in the topic and your commitment to learning are all you need to achieve the utmost benefit from this course.
Mentor
Mubarak Abdul Fattah
IT Instructor
3,397 Learners
2 Course