Excel 101: Mastering the Fundamentals
Learn to navigate Excel, enter and format data, use shortcuts, build basic formulas and functions, and organize and filter data for faster analysis.
Speaker
Mr.Derek Henry
CPA and Excel trainer · CPA
Overview
If spreadsheets feel overwhelming, this beginner Excel training is a good place to start. In 90 minutes you'll build the core Excel skills you need to organize information, run calculations and analyze data with confidence.
The session starts with the interface and how a workbook is structured, from cells to rows and columns. You'll practice entering and editing data quickly, use shortcuts, and apply basic formatting so your sheets look clean and professional. Next come the fundamental formulas and functions that take over routine calculations, with no math anxiety required.
You'll also see helpful tools for organizing and filtering data and for spotting exceptions and errors. It suits anyone new to Excel or wanting a refresher, from students to business professionals.
Why attend: Excel is used for all kinds of data analysis, yet most people rely on only a few of its features. A solid grasp of the important ones helps you save time, reduce risk and build better files that support key decisions. These skills transfer across roles, levels and industries. Accountants, analysts, executive assistants, managers and directors will learn modern approaches that can save dozens of hours a year and make them a more valuable resource to their team.
What’s covered
- Structure: the Excel interface, cells, rows and columns
- Entering and editing data efficiently
- Shortcuts
- Formatting for clean, professional spreadsheets
- Formulas and functions to automate calculations
- Organizing and filtering data for analysis
- Other helpful features for finding exceptions and errors
Who should attend
What you get
About the speaker
Derek has an extensive 20+ year background in Accounting and IT, having held roles in public/corporate accounting and technical sales. He helps accounting and finance teams optimize their processes in Excel and beyond with training, tools, consulting projects, and productivity coaching. He is passionate about efficiency and accountability.
Derek is a Certified Public Accountant and a Certified Fraud Examiner. He lives with his family in Arlington, TX. He is actively involved at church, and enjoys disc golf, softball, and having fun with his family.

