Presenter: David H. Ringstrom, CPA
This course introduces essential skills for new Excel users. You’ll become familiar with the Excel interface, learn best practices for saving workbooks, and build confidence entering and formatting data. The course also covers key productivity tools such as the Fill Handle, AutoFill, and Insert Function.
You will create basic formulas, apply relative and mixed references, use AutoSum, and understand Excel’s order of operations. Additional topics include locating data with the Find feature, using Replace, inserting and deleting rows and columns, and converting formulas to values. You’ll also explore chart creation, advanced paste options, and techniques for separating data into columns.
By the end of the course, you’ll be able to navigate Excel more efficiently and create accurate, well-structured worksheets.
Learning objectives:
State the direction the cursor moves when pressing Enter within a worksheet cell
Identify formatting options for displaying numbers as percentages in Excel
Identify the three inputs required by Excel’s PMT worksheet function
Speaker bio
David H. Ringstrom, CPA, has more than 30 years of experience as a spreadsheet and accounting software consultant and speaker. He has presented over 2,500 live webinars and is the author or co-author of ten books, including Microsoft 365 Excel All-in-One for Dummies, Microsoft 365 Excel for Dummies, Exploring Microsoft Excel’s Hidden Treasures, and QuickBooks Online for Dummies.