| Attend upcoming webinar and earn continuing education credits. | Beginner's Guide to Microsoft Excel (2-part series) | | | | | | | | May | | | | 3-4 | | 3 pm - 4:40 pm ET each day | | | Presenter: David Ringstrom, is an author and nationally recognized instructor | | | Credits: CPE (Credit Details) | | | Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. | | | Viewing Options: View on your computer, tablet, or smartphone | | | | | | | | | | | | Beginner's Guide to Microsoft Excel: Part 1
May 3rd, 2018, 3:00 PM to 4:40 PM, ET
If you've never worked with Excel spreadsheets or haven't for several years, this webinar is for you. 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'll learn about the different types of files you can create, Excel's rows and columns grid, and keyboard shortcuts that will help you simplify repetitive tasks. You'll also learn how to eliminate duplicates in a list, implement the Quick Analysis feature, manage column widths in spreadsheets, filter long lists of data, and more. Upon completion of this course, you'll be able to: - Identify time-saving mouse tricks and keyboard shortcuts to skip confusing menus
- Apply the structural basics of Excel worksheets and workbooks
- List basic data-analysis techniques
- Control Excel's green error-checking prompts by managing the underlying rules
- Eliminate duplicates from a list with just a few mouse clicks
- Utilize free, prebuilt templates in Excel
- Identify the different types of files you can create in Excel
- Explain Excel's grid of rows and columns
- Describe how the Quick Analysis feature can Jump-start data visualization
- Recognize the nuances of copying formulas within Excel spreadsheets
- Manage column widths within your spreadsheets
- Master Excel's order of operations for mathematical formulas
- Navigate large workbooks with ease by way of a hidden menu as well as keyboard shortcuts
- Never type $ signs manually in a formula again; use a keyboard shortcut instead
- Create your own keyboard shortcuts to simplify repetitive tasks
- Enter dates in an Excel spreadsheet
- Use a custom number format to hide zero amounts within a specific area of a spreadsheet
- Wrangle long lists of data by filtering instead of sorting
Beginner's Guide to Microsoft Excel: Part 2
May 4th, 2018, 3:00 PM to 4:40 PM, ET
In this comprehensive presentation, Excel expert, David Ringstrom, CPA, expands on the information he covered in part 1 of this series. You'll see even more ways you can save time working in Excel with techniques such as with pivot tables, charts, and the Table feature. David will also bring you up to speed on ways to minimize data entry, identify duplicate entries, and much more. Upon course completion, you'll be able to: - Swap out data within worksheet cells by way of the Replace feature
- Add fields to a blank pivot table to create instant reports
- Recover unsaved workbooks in Excel 2010 and later
- Create a pivot table to transform lists of data into on-screen reports
- Spell-check spreadsheets using a keyboard shortcut or menu command
- Use Text to Columns in any version of Excel to quickly separate city, state, and ZIP code into separate columns
- Build a basic chart within an Excel worksheet
- Determine the pros and cons of merging cells in spreadsheets
- Identify whether it's safe to edit or delete a cell by way of the Trace Dependents feature
- Describe two different ways to insert or delete rows and columns within a worksheet
- Contrast Paste as Values with normal pasting in Excel
- Identify the location of the Remove Duplicates command within Excel's ribbon menu interface
- Identify the location of the PivotTable command within Excel's ribbon menu interface
- Recognize uses for pivot tables in Excel
| | | | | | | | | | David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. David's mantra is "Either you work Excel, or it works you," so he focuses on what he sees users don't, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. | | | | | | | | | | | ● Earn continuing education credit for no additional fee
● Access courses on your computer, tablet, or smartphone
● More than 75 live webinars each month
● More than 1,500 on-demand courses | | | | | | |
