Excel Explained: Introduction to Spreadsheets
The first half of this session will help Microsoft Excel beginners get up to speed by learning how to assemble an amortization table from scratch.
Experienced Excel users will learn new tricks, particularly during the second half.
We’ll discuss under-utilized aspects of Excel such as managing error prompts, filtering data (instead of sorting), as well as provide an overview of new data analysis features in Excel 2013.
We’ll teach primarily Excel 2010, while noting significant differences in Excel 2007 and 2013 where applicable. Coverage of Excel 2003 will be limited to alternate instructions in the handout.
- Gain understanding of Microsoft Excel and how to build a spreadsheet
- Learn keyboard shortcuts and techniques that simplify repetitive tasks in Excel
- Get an overview of using charts and pivot tables in your workbooks
- Get an overview of the different types of files you can create in Excel
- Simplify repetitive tasks by creating your own keyboard shortcuts
- Navigate large workbooks with ease using a hidden menu, as well as keyboard shortcuts
- Discover how to quickly access folders and workbooks, either on your computer or a network
- Streamline Filtering tasks down to one click, instead of 7 or more
- Capitalize on new features in Excel 2013 that empower anyone to quickly analyze data
- Discover the new Recommended Pivot Tables feature in Excel 2013
Who Should Attend?
Anyone wishing to use Microsoft Excel more effectively.
“Well worth the money we paid! The presenter switched flawlessly between his presentation slides and live Excel in a way that was clear and interesting.” – Paula D., Collegiate Peaks Bank
“I was very impressed with the training. The onscreen activities and captions were easy to follow.” – Danielle L., South Central Bank
David Ringstrom, CPA, owns Accounting Advisors, Inc., an Atlanta-based spreadsheet and database consulting firm that he started in 1991. David has written articles about spreadsheets since 1996, some of which have been published internationally. He teaches scores of webinars each year on a variety of topics, including Excel, Word, Outlook, QuickBooks, and Bitcoin, along with speaking at conferences. David coined the phrase “Either you work Excel, or it works you!” Accordingly, his sessions are designed to help you turn the tide and become a much more effective spreadsheet user.
Institute of Certified Bankers: Visit http://www.icbmembers.org/login.aspx for instructions regarding self-reporting. Estimated credits: 2.5 CE Credits
- Live Webinar which includes 7 Day On-Demand - $265
- Six Month On-Demand – $295
- CD-ROM (Includes Six Month On-Demand) – $325
- Live plus Six Month On-Demand – $365
- Premier (Includes all options) – $395
- Additional Locations – $75
Online: Click here.
Phone: Call Total Training Solutions at (800) 831-0678
Register online up to day of event. Earlier registration allows time to check your computer for an optimal experience.