Excel - Level 1 Course



Course Details:

Length: 1 day

Price: $275/person (USD)

Group Price: Request Quote

Training Reviews

Course Features:

Live Instructor Teaching

Certificate of Completion

Courseware: Print

Hands-On Learning?: Yes

Software Lab Included?: Yes

Delivery Methods:

Live Online

Individuals and Groups
@ Your Location or Our Labs

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.

How Online Classes Work? - Learn How Our Live Online Classes Work

 

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: Office 2021, 365, 2019, 2016, & 2013 (Microsoft Windows PC)
Course Taught With: Office version 2019/365 (Microsoft Windows PC) Software and Excel 2021/365 Courseware
Not Appropriate For: Macintosh versions of Office

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

Start your training today!