Excel - Level 1 Course



Course Details:

Length: 1 day

Price: $295/person (USD)

Bundle & Save: View Bundle

Group Price: Request Quote

Training Reviews

Course Features:

Live Instructor Teaching

Certificate of Completion

Digital Badge

Courseware: Print

Free 6 Month Online Retake

Hands-On Learning?: Yes

Software Lab Included?: Yes

Delivery Methods:

Live Online

Individuals and Groups
@ Your Location

Onsite for Teams

Group Teams
@ Your Organization

This is an instructor-led course. It is taught by an instructor live online or at organizations for groups.
For team training, we can teach onsite at your office or private live online.

 

Course Overview

This course will introduce students to spreadsheets and the fundamental concepts of Microsoft Excel. Learn these features of Microsoft Excel and get more done quickly. Learn how to: Quickly set up workbooks, enter data, and format it for easier viewing, Perform calculations and find and correct errors, Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps, and Print worksheets and charts.


Register Early: Registration Deadline is 2 Weeks Prior to Class Start.

Course Notes

Versions That Can Attend: Desktop Version of Office 2021, 365, 2019, 2016 (Microsoft Windows PC or Macintosh)
Course Taught With: Desktop Version of Office version 365/2019 (Microsoft Windows PC) Software and Courseware


Knowledge Prerequisites

• To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. You can obtain this level of skills and knowledge by taking the Windows for End Users Course.

Suggested Follow-Ons

Excel - Level 2
Excel - Level 3
Microsoft Office 365 Online (with Teams for the Desktop)

Related Certifications

MOS: Microsoft Excel Expert Certification
MOS: Microsoft Excel Associate Certification

Certification Notes: Certification exams are administered by third party testing companies. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact the corresponding testing provider to take a certification exam.

Course Topics

Chapter 1: Set up a workbook - 3
Create workbooks
Modify workbooks
Modify worksheets
Merge and unmerge cells
Customize the Excel app window
• Manage the ribbon
• Manage the Quick Access Toolbar
• Customize the status bar
• Change the magnification level of a worksheet
• Arrange multiple workbook windows
Skills review
Practice tasks

Chapter 2: Work with data and Excel tables - 41
Enter and revise data
Manage data by using Flash Fill
Move data within a workbook
• Sidebar: Quickly access data-formatting commands
Find and replace data
Correct and fine-tune data
Define Excel tables
Skills review
Practice tasks

Chapter 3: Perform calculations on data - 71
Name data ranges
• Sidebar: Operators and Precedence
Create formulas to calculate values

Chapter 4: Change workbook appearance - 103
Format cells
Define and merge cell styles
Apply and modify workbook themes
Apply and modify table styles
Make numbers easier to read
Change the appearance of data based on its value
Add images to worksheets
Skills review
Practice tasks

Chapter 9: Create charts and graphics - 207
Create standard charts
Create combo charts
Create specialized charts
• Hierarchy charts
• Statistic charts
• Scatter charts
• Stock charts
• Map charts
Customize chart appearance
Identify data trends
Summarize data by using sparklines
Illustrate processes and relationships
Insert and manage shapes
Sidebar: Insert mathematical equations
Skills review
Practice tasks

Chapter 11: Print worksheets and charts - 285
Add headers and footers to printed pages
Prepare worksheets for printing
• Fit your worksheet contents to the printed page
• Change page breaks in a worksheet
• Change the page printing order for worksheets
Print worksheets
Print parts of worksheets
Print charts
Skills review
Practice tasks

Course FAQs

This course is taught by a live instructor and is available in two class formats:

  1. Live Online for Individuals
  2. Onsite/Online for Private Groups

Embark on a journey to conquer spreadsheets and master the fundamental concepts of Microsoft Excel with our course. This is not just another excel proficiency course, but a platform where you can access online Excel certification and excel certification classes.

Learn how to quickly set up workbooks, enter data, and format it for easier viewing, perform calculations, find and correct errors, and more. Our excel certification training has been designed to help you get more done quickly, and with greater efficiency.

Visualize your data like never before with charts and graphs, while learning advanced techniques like creating sunbursts, waterfalls, and treemaps. By the end of this course, you'll be ready to print worksheets and charts like a pro.

At the end of our online excel certification classes, you will receive an excel training certificate, a testament to your new found expertise. Don't miss out on this chance to up your game, enroll in our excel certification training today!







Related Microsoft Excel Information:

Individual live Certstaffix Excel training prices start at $295 per student. Group Excel training cost discounts are available.

Excel eLearning courses cost $150 at the starting point per student. Group purchase discounts are available.

 







Registration:

Have a Group?
Request Private Training

4/7/2025 10:00:00 AM
Online Class

Registration Deadline - 03/23/2025

 

4/22/2025 10:00:00 AM
Online Class

Registration Deadline - 04/07/2025

 

5/1/2025 10:00:00 AM
Online Class

Registration Deadline - 04/15/2025

 

5/7/2025 10:00:00 AM
Online Class

Registration Deadline - 04/22/2025

 

5/13/2025 10:00:00 AM
Online Class

Registration Deadline - 04/28/2025

 

5/19/2025 10:00:00 AM
Online Class

Registration Deadline - 05/04/2025

 

6/2/2025 10:00:00 AM
Online Class

Registration Deadline - 05/18/2025

 

6/10/2025 10:00:00 AM
Online Class

Registration Deadline - 05/26/2025

 

6/16/2025 10:00:00 AM
Online Class

Registration Deadline - 06/01/2025

 

6/25/2025 10:00:00 AM
Online Class

Registration Deadline - 06/10/2025

 

7/10/2025 10:00:00 AM
Online Class

Registration Deadline - 06/24/2025

 

7/16/2025 10:00:00 AM
Online Class

Registration Deadline - 07/01/2025

 

7/22/2025 10:00:00 AM
Online Class

Registration Deadline - 07/07/2025

 

7/30/2025 10:00:00 AM
Online Class

Registration Deadline - 07/15/2025

 

8/7/2025 10:00:00 AM
Online Class

Registration Deadline - 07/22/2025

 

8/21/2025 10:00:00 AM
Online Class

Registration Deadline - 08/05/2025

 

8/26/2025 10:00:00 AM
Online Class

Registration Deadline - 08/11/2025

 

9/3/2025 10:00:00 AM
Online Class

Registration Deadline - 08/19/2025

 

9/9/2025 10:00:00 AM
Online Class

Registration Deadline - 08/25/2025

 

9/16/2025 10:00:00 AM
Online Class

Registration Deadline - 09/01/2025

 

9/22/2025 10:00:00 AM
Online Class

Registration Deadline - 09/07/2025

 

10/6/2025 10:00:00 AM
Online Class

Registration Deadline - 09/21/2025

 

10/15/2025 10:00:00 AM
Online Class

Registration Deadline - 09/30/2025

 

10/21/2025 10:00:00 AM
Online Class

Registration Deadline - 10/06/2025

 

10/29/2025 10:00:00 AM
Online Class

Registration Deadline - 10/14/2025

 

11/3/2025 10:00:00 AM
Online Class

Registration Deadline - 10/19/2025

 

11/17/2025 10:00:00 AM
Online Class

Registration Deadline - 11/02/2025

 

11/25/2025 10:00:00 AM
Online Class

Registration Deadline - 11/10/2025

 

12/3/2025 10:00:00 AM
Online Class

Registration Deadline - 11/18/2025

 

12/9/2025 10:00:00 AM
Online Class

Registration Deadline - 11/24/2025

 

12/15/2025 10:00:00 AM
Online Class

Registration Deadline - 11/30/2025

 

12/29/2025 10:00:00 AM
Online Class

Registration Deadline - 12/14/2025

Start your training today!