Beginner's Guide to Microsoft Excel | | | | | | | September | | 15 | 1 pm - 2:40 pm ET | | Presenter: David Ringstrom, Owner and Founder of Accounting Advisors, Inc. | | 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 for 6 months, or both. | | Viewing Options: View on your computer, tablet, or smartphone | | | | | | | | | | If you've never worked with Excel spreadsheets, or if you haven't used them for several years, this webinar is designed for you. In this webinar, you'll learn how to create and use Excel spreadsheets. You'll also learn about the different types of files you can create, Excel's rows and columns grid, keyboard shortcuts to help you simplify repetitive tasks, and much 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 for spreadsheets 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
- Utilize Excel's order of operations for mathematical formulas
- Navigate large workbooks with ease by way of a hidden menu and keyboard shortcuts
- Use a keyboard shortcut rather than typing $ signs manually in a formula
- Create your own keyboard shortcuts to simplify repetitive tasks
- Enter dates in an Excel 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 750 on-demand courses | | | | | | |
|
|
No comments:
Post a Comment