By the end of this course, you will be able to
How to run Excel, and you will be introduced to the Excel interface. Also, you will learn how to format columns and rows to demonstrate your data simply.
How to add and remove columns and rows, add and remove sheets, save a file, open a new file, use the autofill tools, and how to cut and copy information.
How to use auto sum, understand the sumif(s) and averageif(s) functions. Also, you will learn how to use the logical function (IF), and the IFERROR function.
Course details
- 4 h 23 m/57 lessons
- Last updated: 3/6/2021
- 1 Quizzes
- 47 learning resources
- Course completion certificate
Course Content
Introduction
Operating Microsoft Excel
Microsoft Excel Interface
Formatting Columns and Rows 1
Formatting Columns and Rows 2
Adding/ Removing Columns and Rows
Adding/ Removing Sheet, Save Workbook
New, Open File on Excel
The Autofill Tool
Cut/ Copy Information
Quiz
Introduction
Operating Microsoft Excel
Microsoft Excel Interface
Formatting Columns and Rows 1
Formatting Columns and Rows 2
Adding/ Removing Columns and Rows
Adding/ Removing Sheet, Save Workbook
New, Open File on Excel
The Autofill Tool
Cut/ Copy Information
Fonts Formatting
Cells Alignment
Numbers Formatting 1
Date, Time and Percentage Formatting
Numbers Formatting 2
Numbers Formatting 3
Sum and Auto Sum
Operations, Average, Max and Min
Absolute Reference
The Count Functions
The Sumif(s) and Averageif(s) Functions
The Logical Functions (IF)
Nested IF 1
Exercise on Functions 2
The If Error Function
The VLookup Function 1
The VLookup Function 2
The HLookup Function
The Round, Large, Small Functions
The Aggregate Function
Different Types of Text Functions
The Date Function
Formula Auditing
The Define Name Tool
The Find and Replace Tool
The Conditional Formatting 1
The Conditional Formatting 2
The Conditional Formatting 3
Sort
Filter
The Advanced Filter
The Subtotal Tool
Flash Fill, Text to Column
Charts 1
Charts 2
Pivot Tables
Editing Reports
Formula Editing and Using Slicer
Pivot Chart
Reports
Printing Sheets 1
Printing sheets 2
Header and Footer
Protecting Files
Protecting Sheets and Workbooks
Course Summary
About this course
Microsoft Excel is considered one of the most powerful tools for managing and presenting data in the workplace today, and it is 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 plan 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
For this course, you must have basic computer literacy.
You must have Microsoft Excel installed.
Mentor
Raguia Aglan
Certified Microsoft Office Specialist Expert
11,302 Learners
3 Courses
