Attend upcoming webinar and earn continuing education credits. Beginner's Guide to Microsoft Excel | | | | | | | July | | 12 | 1 pm - 2:40 pm ET | | Presenter: David Ringstrom, CPA, author and nationally recognized Excel 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 | | | | | | | | | | 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
| | | | | | | 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,000 on-demand courses | | | | | |
No comments:
Post a Comment