Microsoft Office Excel Basic: Unlock Spreadsheet Essentials
Intended Organizations
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Intended Organizations
Organizational type shows which workplace or sector each group training program best aligns with. Most courses adapt across settings to support unique goals and outcomes.
State & Local GovernmentTraining for state, county, municipal, and other public-sector teams, focused on building skills that support government and public service work.
Federal GovernmentCreated for federal agencies and employees, with practical training that helps build job-relevant skills for the federal workplace.Course pricing is available for federal agencies through the GSA Schedule.
Corporate & Business GroupsProfessional development for small groups, large business teams, and enterprises across industries focused on building valuable skills.
Skill LevelFundamentals
Virtual | Live Trainer4 hours/day, 1 Day
In-Person | Onsite6 hours/day, 1 Day
Skill Level & Progression
Skill level reflects the recommended course experience and helps match training to your team's needs. Most training courses support all learning levels.
General WorkforceDevelops team-ready capabilities across business roles and experience levels while strengthening skills and organizational results.
Fundamentals(this course)Builds introductory proficiency in essential terminology, core concepts, and workplace best practices for real-world application.
IntermediateStrengthens existing knowledge through advanced functions, skill strategies, and deeper exploration of core concepts.
AdvancedDeepens expertise through complex subject matter, specialized skills, advanced analysis, and higher-level instruction.
Course Formats
Train on your terms. Choose virtual or onsite delivery, schedule sessions around your team’s availability, and align course content with your objectives and real-world challenges.
Virtual Training4 hours/day, 1 DayLive, interactive, instructor-led training delivered through a secure videoconferencing platform.
Onsite Training6 hours/day, 1 DayEngaging, instructor-led training delivered in person at the location of your choice.
Course Duration
Course duration varies by training format and time needed to effectively cover the material, with hours per day and total days listed.
Generates a branded PDF — downloads directly to your device
Course Overview
The course covers the latest version of Microsoft Excel (2021–2024); earlier versions are available upon request.
This course aims to provide you with a foundation for Excel knowledge and skills. You’ll learn to organize, calculate, analyze, revise, update, and present your data. It will also make these tasks much easier for you to accomplish in less time than if you used traditional pen-and-paper methods or non-specialized software.
Beginners who want to learn Microsoft Excel from the basics.
Professionals who need to organize and manage spreadsheet data.
Employees who want to perform calculations using formulas and functions.
Office staff who need to format, print, and present worksheet data.
Anyone looking to improve productivity with Microsoft Excel.
Course Agenda
Six modules · 24 topics
1Getting Started with Microsoft ExcelTopics 1–5
Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter Cell Data
Use Excel Help
2Performing CalculationsTopics 6–8
Create Worksheet Formulas
Insert Functions
Reuse Formulas and Functions
3Modifying an Excel WorksheetTopics 9–11
Learn to insert, delete, and adjust cells, columns, and rows.
Searching for and Replacing Data
Use Proofing and Research Tools
4Formatting an Excel WorksheetTopics 12–17
Apply Text Formats
Apply Number Formats
Align Cell Contents
Apply Styles and Themes
Apply Basic Conditional Formatting
Create and Use Templates
5Printing WorkbooksTopics 18–20
Preview and Print a Workbook
Set Up the Page Layout
Configure Headers and Footers
6Managing WorkbooksTopics 21–24
Managing Worksheets
Manage Workbooks
Managing Worksheet Views
Managing Workbook Properties
About our Trainers
Our Mission
Our facilitators are committed to delivering the latest industry trends, job-specific best practices, and the essential soft and hard skills needed in today’s workforce. PTR offers small and large organizations the choice between onsite and virtual training. Collaborate with our specialists to address challenges, bridge skill gaps, and tailor the learning experience to meet your company’s goals.
This course introduces the essential features of Microsoft Excel, helping participants create spreadsheets, perform calculations, format data, and manage workbooks efficiently.
Who should attend Microsoft Excel Basic training?
The course is ideal for beginners, students, administrative staff, and professionals who want to develop practical spreadsheet skills for work or everyday tasks.
Which versions of Microsoft Excel does this course cover?
The course covers Microsoft Excel versions 2021–2024. Training for earlier versions is available upon request.
Will I learn how to use Excel formulas and functions?
Yes. You will learn to create worksheet formulas, insert functions, and reuse formulas and functions to perform calculations more efficiently.
Will this course teach me how to edit worksheet data?
Yes. You will learn to insert, delete, and adjust cells, rows, and columns, as well as search for and replace data using Excel tools.
Does the course cover printing Excel workbooks?
Yes. You will learn to preview and print workbooks, configure page layouts, and set up headers and footers for well-organized printouts.
Will I learn how to manage Excel workbooks and worksheets?
Yes. The course covers managing worksheets and workbooks, adjusting worksheet views, and working with workbook properties to keep spreadsheet files organized.
Microsoft Office Excel Basic: Unlock Spreadsheet Essentials
Request a Training Quote
Share your team’s goals, and we’ll recommend the right skills training.
PTR Training uses 'cookies' to improve your website experience. View our Privacy Policy for details. By continuing, you agree to accept and adhere to our Terms of Use.