Wednesday, December 28, 2016

Beginner’s Guide to Microsoft Excel

Attend upcoming webinar and earn continuing education credits.
Live Webinars   |   On-Demand   |   All-Access Plan
Manage Preferences    |    View in Browser
Visit Clear Law Institute
Beginner's Guide to Microsoft Excel
January
 
20
1 pm - 2:40 pm ET
Presenter: David Ringstrom, CPA, 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 after the live presentation, or both.
Viewing Options: View on your computer, tablet, or smartphone
Course Reviews: View Testimonials
Can't wait? View previously recorded version now
Learn More
Register Today
Course Description
 
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

Course Reviews from Past Attendees

92% of attendees said they would recommend this course to others.
"Clear explanations on all subjects."
"It was a great refresher for me."
"I learned things that I did not know."
"It had a ton of info & was easy to follow."
Learn More
Register Today
The Presenter
About The Presenter
 
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.
Learn More
Register Today
All-Access Membership
 
● 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 850 on-demand courses
Learn More
Upcoming Webinars
The 1099 & W-9 Annual Update Course
January 3 at 3 pm ET
Learn More
Nexus and Drop Shipments and Sales and Use Tax
January 4 at 3 pm ET
Learn More
Detecting & Preventing Payroll Fraud
January 5 at 1 pm ET
Learn More
Questions?
Please call us at 703-372-0550

Our Mailing Address:
Clear Law Institute | 933 N. Kenmore St, Ste 320 | Arlington | VA | 22201
Remove me from future emails.

Manage email preferences.

This email was sent to virginia.duffy.planetduffy@blogger.com. If you are receiving it in error, please reply to this email.
 

No comments:

Post a Comment