skills logo

Explore

  1. Courses
  2. Microsoft Excel Crash Course

Microsoft Excel Crash Course

skills

BEGINNER

No Project

Updated 1 year ago

About

Modules

M:1

Introduction

9 Lessons

|

1 Hr, 7 Min

This module introduces the worksheet mechanism, freeze and unfreeze, and shortcuts in Microsoft Excel is an essential part of learning to use the program. In this module, you will learn how to work with multiple worksheets within a single workbook, allowing you to organize and analyze data in different ways.

  • What does the course cover?

    1:31

  • Getting Started with Excel

    4:46

  • Introduction to Excel Functions and Formulas

    13:24

  • Introduction to Excel Quiz 1

    -

  • Worksheet Mechanics

    16:19

  • Introduction to Excel Quiz 2

    -

  • Shortcuts

    15:46

  • Working with Freeze and Unfreeze and Comments

    14:56

  • Introduction to Excel Quiz 3

    -

M:2

Working with Functions

9 Lessons

|

1 Hr, 11 Min

This module introduces the ribbon and functions in Microsoft Excel is a crucial first step for anyone learning to use the program. The ribbon is the main toolbar in Excel, which contains all the commands and tools you need to create and edit spreadsheets. In this module, you will learn how to navigate the ribbon, customize it to suit your needs, and access its many functions and features.

  • Text Functions - Concatenate & Ampersand

    11:45

  • Text Functions - Text Case

    11:03

  • Introduction to Excel Quiz 4

    -

  • Text Functions - More text functions

    8:08

  • Logical Functions

    15:17

  • Introduction to Excel Quiz 5

    -

  • Logical Functions - If statement

    11:50

  • Logical Functions - nested If

    12:41

  • Introduction to Excel Quiz 6

    -

M:3

Pivot Tables

6 Lessons

|

43 Min

This module introduces pivot tables in Microsoft Excel is a crucial next step for anyone looking to enhance their data analysis skills. Pivot tables are powerful tools that allow you to summarize, analyze, and present large sets of data in a compact and meaningful way.

  • Introduction to Pivot Tables

    9:55

  • Custom Reports

    10:48

  • Introduction to Excel Quiz 7

    -

  • Conditional Formatting

    6:10

  • More Formatting

    16:20

  • Introduction to Excel Quiz 8

    -

M:4

Date Functions

6 Lessons

|

40 Min

This module introduces date functions in Microsoft Excel is a critical component for anyone who needs to work with dates and times in their spreadsheets. Excel provides a wide range of date and time functions that allow you to manipulate, format, and analyze dates and times in various ways.

  • Introduction to Date Function

    11:15

  • Date Comments

    10:42

  • Introduction to Excel Quiz 9

    -

  • EOMONTH & EDATE

    7:58

  • Conditional Formatting

    10:06

  • Introduction to Excel Quiz 10

    -

M:5

Charts

6 Lessons

|

37 Min

Excel provides a wide variety of chart types, such as bar charts, line charts, and pie charts, that allow you to communicate your data effectively. In this module, you will learn how to create, format, and customize charts, using features such as chart titles, axes labels, and data labels to make your charts more informative and engaging.

  • Create Professional Charts

    16:19

  • Introduction to Excel Quiz 11

    -

  • Format and Edit Charts

    14:30

  • Create Custom Chart Templates

    5:25

  • Wrapping Up

    0:45

  • Introduction to Excel Quiz 12

    -

Project:

Details not provided...

Instructors:

Details not provided...

Preview this course

This course includes:

  • 4 Hr, 19 Min on-demand video
  • 12 assignments
  • Lifetime access
  • Milestone budges
5 star
4 star
3 star
2 star
1 star
★★★★★

instinctHublogo

Powered by instinctHub

© 2025 All right reserved

  • Privacy Policy
  • Terms & Condition