Course Details:
Length: 1 day
Price: $295/person (USD)
Bundle & Save: View Bundle
Group Price: Request Quote
Course Features:
Live Instructor Teaching
Certificate of Completion
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
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.
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
Course Topics
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
