Course Content

Module 1: Course Introduction

Module 10: Conclusion

Course Description

Prerequisites

For this course, you require no previous knowledge of Excel. Basic knowledge of what Excel is and about it’s usage is preferred, but not necessary. In addition, some familiarity with other Microsoft Office programs is welcomed (Microsoft Word to start with), but also not a prerequisite. You just need to be comfortable with using a PC or MAC computer and have a basic knowledge on how files are organized, what are folders and directories. You will need MS Excel 2019 in order to perform the exercises in this course.

Study Resources

For modules 4 to 8, students can exercise their learning in Labs. Each Lab consists of:

  • .xlsx file which represents data on which student is supposed to do the labs
  • PDF file with task of the labs explained and step-by-step instructions, and video in which the labs are explained and performed in full.
  • .xlsx files used as example in every module in videos and a PDF file of PowerPoint presentation used for this course.

Course Goals

By the end of this course, students should be able to:

  • Enter data in Excel sheet
  • Manipulate data using formulas, functions and logical operations
  • Save files in different formats and create templates
  • Use different data types and create custom data types
  • Use names in Excel
  • Hide cells and sheets and protect them
  • Sort, filter, group data and do various data manipulation and consolidation
  • Format cells and use styles
  • Insert different objects in Excel sheet
  • Use pivot tables and charts
  • Print their worksheets in desired format

Understanding how to use Microsoft Excel and complete basic functions such as entering formulas and creating pivot tables is essential to many job functions. Taking an online course for beginners helps students learn the program by doing.

Understanding how to use Microsoft Excel effectively can be a valuable resource in many different industries and job roles. Everyone from accountants, auditors, and financial analysts to sales managers and administrative assistants use Excel to record and analyze data.

Truly understanding how to use formulas in Excel and sort data can save professionals an infinite amount of time while executing their job duties.

Managers may want their entire team to understand how to better use Excel in their job duties or perhaps the student is heading to college and wants a stronger grasp on how to execute functions within the program. Taking an online introductory course in Excel can accelerate your career and help you feel comfortable using the program.

How do you learn Excel basics fast?

Taking an online basic Excel course, such as Cybrary’s, can quickly give students the basic knowledge needed to use the software and compute elementary calculations, create charts, and manipulate data and files.

Cybrary’s basic Excel training is a free online video course that students can take at their own leisure, or if you’re in a rush, you can complete the course in about six hours. Motivated students can complete the course in a day.

What’s the best way to learn Excel for beginners?

As with many things, the best way to master Excel is to learn by doing. You’ll need the Microsoft Excel program and then can start clicking around within the program.

The best way to understand how to fully utilize Excel is by taking an online video course that can help guide you through the program and help you see where to enter data, create tables, and sort sheets yourself.

What is covered in basic Excel training?

Cybrary’s basic Excel training course is composed of 10 sections that cover everything a student will need to have a basic understanding of Excel and how to properly use it.

First, students learn what Excel is used for, who needs it, and the limitations of the program. Students will also learn proofing and translation.

Then, the course moves on to the highly coveted formulas section. The course will teach students how formulas are entered, how to create basic math and text calculations, and how to look for errors in those formulas.

Next, students will gain an understanding of the types of files in Excel. This module will teach students how to create custom data types, create templates, and protect or hide sheets.

In the data tabs module, students will learn how to sort data using filters, how to group cells, create subtotals, consolidate data, and data validation.

After the data tabs section, the course moves on to formmatting cells and sheets, which teaches cell properties, conditional formatting, and creating tables. Next, students will learn how to insert objects into Excel using the insert tab and how to format shapes and pictures. This section also covers creating charts.

Then, students will receive instruction on pivot tables and pivot charts. In this module, students will learn to make their own pivot table. Finally, students learn how to format the page to print the sheet.

What are the basics of using Excel?

By the end of taking the Cybrary intro to Excel course, students will be able to complete the basic functions of Excel, such as:

  • Enter data in an Excel sheet
  • Manipulate data using formulas, functions and logical operations
  • Save files in different formats and create templates
  • Use different data types and create custom data types
  • Use names in Excel
  • Hide cells and sheets and protect them
  • Sort, filter, group data and do various data manipulation and consolidation
  • Format cells and use styles
  • Insert different objects in an Excel sheet
  • Use pivot tables and charts
  • Print their worksheets in the desired format

What do students need to learn Excel?

To take Cybrary’s basic Excel training, students do not need any previous knowledge of the program. If a student has familiarity with Microsoft Word, it’s helpful but not necessary. Students can take the course on a PC or MAC computer that they’re comfortable with. Then, students will need to download or purchase Microsoft Excel 2019 and they can start taking the course and learn the basics of Excel.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor

Provided By

Cybrary

Certificate of Completion

Certificate Of Completion

Complete this entire course to earn a Intro to Excel Certificate of Completion