If you’ve never worked with Excel spreadsheets or haven’t for several years, Part 1 of this practical webinar is just what you need. Excel expert, David Ringstrom, CPA, takes you through the basics of Excel spreadsheets so you’ll be equipped to create functional spreadsheets and manipulate large lists of data. You will learn about the different types of files you can create, Excel’s rows and columns grid, keyboard shortcuts that will help you simplify repetitive tasks, and more.
You will see each technique demonstrated at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 365 version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the presentation, as well as in his detailed handouts. You will also receive an Excel workbook that includes most of the examples used during the webcast.
Office 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.
You will learn how to:
- Use Excel’s Freeze Panes feature.
- Handle situations where numbers are presented as # signs on-screen and in Print Preview.
- Use a custom number format to hide zero amounts within a specific area of a spreadsheet.
- Discern the nuance of entering text into worksheet cells.
- Utilize the PMT worksheet function to calculate loan payment amounts.
- Copy formulas efficiently down one or more columns at the same time.
- Prevent errors from the start by choosing from thousands of free Excel spreadsheet templates.
- Differentiate between working within a cell versus working on a worksheet.
- Jump-start spreadsheet projects using free, prebuilt templates in Excel.
- Get oriented with Excel’s grid of rows and columns.
- Save time by using the AutoSum formula to sum multiple columns at once with a mouse click or a keyboard shortcut.
Upon course completion, you will be able to:
- Recall how to skip confusing menus by way of time-saving mouse tricks and keyboard shortcuts.
- Apply the structural basics of Excel worksheets and workbooks.
- Identify Excel’s order of operations for mathematical formulas.
To register for both parts of this webinar series together, please click here.
Format: Live webcast
Instructional Method: Group: Internet-based
NASBA Field of Study: Computer Software & Applications (2 hours)
Program Prerequisites: None
Advance Preparation: None