BONUS! Cyber Phoenix Subscription Included: All Phoenix TS students receive complimentary ninety (90) day access to the Cyber Phoenix learning platform, which hosts hundreds of expert asynchronous training courses in Cybersecurity, IT, Soft Skills, and Management and more!
Course Overview
Our Microsoft Excel 2021/365 Level 1 courseware provides the basic concepts and skills students need to start being productive with Microsoft Excel: how to create, save, share, and print worksheets that contain various kinds of calculations and formatting. Students will benefit most from this course if they want to accomplish basic workplace tasks in Excel, or if they want to have a solid foundation for continuing on to become an Excel expert.
At the completion of this course, participants will be able to:
- Open and interact with Excel, and save and close workbooks
- Enter various kinds of data, enter formulas and functions, move and copy data, and identify reference types and how to use them
- Format text and numbers, align text, and apply borders and styles to cells and ranges
- Implement various data-entry shortcuts; use paste options; insert, delete, and hide data in their worksheets
- Create charts, change their type, and insert and control the elements they contain
- Split and manage worksheet windows, set print options, print and preview workbooks, create headers and footers, and share workbooks with other users
- Understand workbook properties and how to use templates
Schedule
Currently, there are no public classes scheduled. Please contact a Phoenix TS Training Consultant to discuss hosting a private class at 301-258-8200.
Program Level
Beginner
Duration
1 day/8 hours
Prerequisites
- The course assumes students know how to use a computer, and that they’re familiar with Microsoft Windows.
Course Outline
Introduction
- Chapter 1: Fundamentals
- Module A: Getting around
- Module B: Workbook basics
Chapter 2: Creating worksheets
- Module A: Entering data
- Module B: Formulas
- Module C: Functions
- Module D: Moving and copying data
- Module E: Reference types
Chapter 3: Formatting
- Module A: Text formatting
- Module B: Number formatting
- Module C: Alignment
- Module D: Borders and highlighting
- Module E: Styles and themes
Chapter 4: Manipulating data
- Module A: Data entry shortcuts
- Module B: Paste options
- Module C: Inserting, deleting, and hiding
Chapter 5: Charts
- Module A: Creating charts
- Module B: Chart types and elements
Chapter 6: Output
- Module A: Managing worksheet windows
- Module B: Printing worksheets
- Module C: Sharing workbooks
Chapter 7:Settings and templates
- Module A: Workbook options and properties
- Module B: Templates
BONUS! Cyber Phoenix Subscription Included: All Phoenix TS students receive complimentary ninety (90) day access to the Cyber Phoenix learning platform, which hosts hundreds of expert asynchronous training courses in Cybersecurity, IT, Soft Skills, and Management and more!
Phoenix TS is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints re-garding registered sponsors may be submitted to the National Registry of CPE Sponsors through its web site: www.nasbaregistry.org
![[GSA LOGO]](https://phoenixts.com/wp-content/themes/phoenixts-com/assets/images/gsa-logo-black.png){kind=logo}
