247Compliance appLinks, recordings and certificates
Open
Questions? Call +1-661-336-9555 Group training quotes Get the app
ON-DEMAND Software

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.

FormatRecorded sessionWatch any time
Length90 minutes
Mr.Derek Henry Speaker Mr.Derek Henry CPA and Excel trainer · CPA
Talk to an expertAsk an expertQuestions about this topic

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

AccountantsAnalystsExecutive assistantsManagersDirectors

What you get

CertificateEmailed to each attendee after the session.
HandoutsSlides and checklists to reuse with your team.

About the speaker

Mr.Derek Henry
Mr.Derek Henry
CPA and Excel trainer

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.

All webinars by Mr.Derek Henry →
From$219On-demand · watch any time Enroll now