Excel in an Hour

The Excel in an Hour course is a free Excel tutorial for beginners, designed to help complete newbies be able to crush everyday Excel tasks with ease. In this Excel crash course, quickly learn the most common formulas, functions, and tools needed to increase your overall knowledge and proficiency with Excel. The downloadable practice worksheets make it easy to learn Excel fast and apply new knowledge to real-world scenarios. Each step comes with a short quiz, so you can be confident you’ve mastered the skills you’ve learned.

What’s included:

16 easy-to-digest Excel tutorial videos
Downloadable exercise files and reference guides
Unlimited quiz and test attempts
Certificate of completion
Free access to the GoSkills Excel Office app

Learn how to:

Understand the difference between formulas and functions.
Calculate and simplify data with functions like AVERAGE, SUM, COUNTIF and TODAY.
Apply cell formatting that makes data visually appealing.
Use dynamic conditional formatting to make critical information stand out.
Manage workbooks, including how to rename, add, delete, move, and copy sheets.
Group, sort, and filter to quickly organize your data.
Easily transform numerical data into visual charts and graphs.

Every concept in this course can be used in all versions of Microsoft Excel, and was recorded using Excel 2019/365.

Once enrolled, our friendly support team is here to help with any course-related inquiries.

Summary

Skill level: Beginner
Lessons: 49
Versions supported: 2016, 2019, 2021, 365
Estimated study time: 1h 15m for all materials

Certificate: Yes
Pre-requisites: None
Video duration: 1h 15m

Features

Premium video tutorials

Personalized Learning

Learn at your own pace

Tests and Quizzes

Award winning instructors

Get Certified

Mobile - Learn on the go

Regularly updated content

Accreditations & Approvals

All courses under each learning path are accredited and approved by one or more of the following bodies as is applicable.

Instructors

All courses are taught by reputed trainers with relevant accreditations and industry experience.

Modules

Getting Started

Get Ready to Excel

Understand why you need to know how to use Excel.

The Basics

Introduction to the Ribbon, worksheets, and understanding cell contents and cell referencing.

Formulas and Functions

Formulas vs Functions

What is the difference between a formula and a function? What’s the structure of each?

Formulas & Functions in Action

Determining when it’s best to use formulas vs. functions. Learn how to copy and paste formulas and functions.

Using Functions to Simplify Data

Solve common problems using essential functions.

Data Appearance & Formatting

Cell Formatting

Resize rows/columns, adjusting fonts, colors & alignment.

Number Formats

Change number formats to/from: date, currency/general.

Conditional Formatting

Format cells dynamically based on criteria which you define.

Organizing Data

Worksheet Management

Edit worksheet by adding and removing rows and columns.

Workbook Management

Renaming, adding, deleting, moving and copying sheets.

Sorting & Filtering

Organize your data using sorts and filters.

Presenting Data

Creating Charts

Make data more visually appealing by choosing from a variety of chart types.

2

Formatting Charts

Learn how to create title and various options for your chart, adjust data source and change chart type.

The Wrap Up

Putting it all Together

Change the way your worksheet appears onscreen. Customize the way data appears when printed.

Excel Hacks & Tricks

Useful shortcuts and tips for working with Excel sheets

Excel Hacks & Tricks Part 2