Excel: Level 1
Gain a foundational understanding of Microsoft Office Excel 2019.
Excel: Level 1
Gain a foundational understanding of Microsoft Office Excel 2019.
What you’ll be able to do — competencies
- Explore the Microsoft Office Excel 2019 environment and create a basic worksheet
- Perform calculations
- Modify a worksheet
- Format a worksheet
- Print workbook
- Manage workbooks
Course description
Organize, calculate, analyze, revise, update and present your data in ways that will help the decisionmakers in your organization lead in the right direction. This course will provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data analysis.
This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2019 that is necessary to create and work with electronic spreadsheets.
Prerequisites
- Windows Introduction or equivalent knowledge
Syllabus
Lesson 1: Getting started with Microsoft Office Excel 2019
- Navigate the Excel User Interface
- Use Excel commands
- Create and save a basic workbook
- Enter cell data
- Use Excel help
Lesson 2: Performing calculations
- Create worksheet formulas
- Insert functions
- Reuse formulas and functions
Lesson 3: Modifying a worksheet
- Insert, delete and adjust cells, columns and rows
- Search for and replace data
- Use proofing and research tools
Lesson 4: Formatting a worksheet
- Apply text formats
- Apply number formats
- Align cell contents
- Apply styles and themes
- Apply basic conditional formatting
- Create and use templates
Lesson 5: Printing workbooks
- Preview and print a workbook
- Set up the page layout
- Configure headers and footers
Lesson 6: Managing workbooks
- Manage worksheets
- Manage workbook and worksheet views
- Manage workbook properties
Next available start dates
Online — Days
Excel: Level 1
Total classroom hours
8 hours
Schedule
Online
Days, 1:00 PM - 5:00 PM, 2 T - 4/11/2023 - 4/18/2023
Quarter: Spring
Total cost
$299
Instructor: Cliff Hanks
Cliff is an experienced Microsoft Office instructor and developer. He has been training professionals on how to use software to perform their jobs more effectively for over 25 years.
Notes
Online courses require an internet connection and the ability to interact both through audio and video using either a web cam/microphone, speakers/headset using a computer or via a mobile phone connection. Any costs associated with connectivity or equipment are the responsibility of the student.
Interested in custom learning solutions for your team?
Tombolo Institute Corporate Solutions offers tailor-made professional development programs to meet your organization’s goals.
Get started