Description
In this course Excel expert David Ringstrom, CPA shares many Excel tips and tricks that he uses to fly through Excel every day. He’s fond of stating “Either you work Excel, or it works you!” This course is designed to help you use Excel more effectively. In this course David teaches primarily from Excel 2010, but covers differences in Excel 2003, 2007, and 2013 where applicable.
Topics Covered:
- Discover how to quickly access folders and workbooks, whether on your computer or a network
- Convert Excel 97-2003 files to modern workbook formats with ease.
- Quickly clean-up accounting data by way of Excel’s Text to Columns feature.
- When Text to Columns won’t do, use the LEFT, MID, and RIGHT functions to extract text from a cell.
- Transform text by way of Excel’s UPPER, LOWER, PROPER, and TRIM functions.
- Learn the most efficient way to link Word documents and Excel spreadsheets
- Edit PDF documents in Word 2013–useful for unlocking data you wish to edit in Excel.
- Learn the right and wrong ways to make Excel appear on two or more monitors.
- Avoid starting spreadsheets from scratch: use prebuilt templates, or create your own!
