0

Introduction to Microsoft Excel

Course Details
Content Provider

Microsoft

Trainer Name

Microsoft

Skill Area

Education, Skills Development or Languages

Reviews

4.7 (186 Rating)

Course Requirements

There are no specific requirements. Everyone is eligible to enrol in this course.

Course Description

This module introduces the basics of Excel. It will provide you with a better understanding of operating Excel by guiding you through key Excel formulas and different functionalities. 

Course Outcomes

Understanding the different basic functions of Microsoft Excel as below:

  • Rows & Cells
  • Formatting
  • Formulas
  • Tables
  • Charts
  • Pivot Tables
  • Share

Course Curriculum

1 What is Excel?
1 Min

2 Create a Workbook

3 Insert or Delete Worksheet

4 Move or Copy Worksheets

5 Fill data automatically

1 Insert or Delete Rows or Columns

2 Select cell contents

3 Freeze columns or rows

4 Split data into different columns

5 Autofill dates

6 Combine data

1 Move Cells

2 Copy cells

3 Change the column width and row height

4 Merge unmerge cells

5 Validate cell data

6 Create custom number

1 Format numbers in cell

2 Conditional formatting

3 Align text in a cell

4 Copy cell formatting

5 Create a watermark

6 Apply styles

1 Create formulas

2 Division

3 Multiplication

4 Subtraction

5 VLOOKUP

6 SUM

7 IF

8 IFS

9 SUMIF

10 SUMIFS

11 Define and use names in formulas

1 Create a table in Excel

2 Sort data in table

3 Filter data in a range or table

4 Add Total row to a table

5 Use slicers to filter data

1 Create Charts

2 Add a chart title

3 Show or hide a chart legend

4 Add a secondary axis

5 Use Sparklines to show datatrends

6 Analyze your data quickly

7 Change the source for a chart

1 Create a Pivot Table

2 Work with Pivot Tables

3 Group data in Pivot Tables

4 Filter data in a Pivot Table

5 Create a Pivot Chart

6 Introduction to Microsoft Excel [Quiz]
Start 25 Min

1 Share a workbook

2 Add and review comments

3 Password protect workbooks

Trainer

Trainer Name

Microsoft

4.7 Rating
186 Reviews

More Courses by Author

Free

Understanding Microsoft Word
5/5
27 Lessons 3041 Enrolment
Free

Connect your team with Microsoft Teams
5/5
39 Lessons 321 Enrolment

Learner Feedback

Introduction to Microsoft Excel

4

Course Rating
61.54%
15.38%
23.08%
0.00%
0.00%

Log In or Sign Up as learner to post a review

Course you might like

Free

Testing new course
0/5
1 Lessons 1 Enrolment
Free

Distinguishing The Types Of Intelligence
4/5
61 Lessons 233 Enrolment

Free

Enrol Now

This course includes:

  • Duration: 1 Hour

  • Skill Level: Beginner

  • Lectures: 55 lessons

  • Enrolled: 1727 learners

  • Certificate of Completion

  • Lifetime access

Shopping Cart

Loading...
View cart Checkout