Course Name: Excel: Taming Large Spreadsheets
CPD hours: 2
Type: Online/Video
Price: €40
Description:
This comprehensive course will alleviate your frustration when trying to manage unwieldy Excel spreadsheets. We demonstrates a number of ways you can successfully tame cumbersome spreadsheets. His helpful tips enable you to save time, improve the integrity of large workbooks, avoid repetitive tasks, and much more.
We demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He draws your attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. We also provides an Excel workbook that includes most of the examples he uses during the webcast.
Upon completion of this course, the learner will be able to:
- Define how to use the Watch Window feature to monitor and navigate to key worksheet cells.
- State how to hide multiple worksheets within a workbook simultaneously.
- Identify how to apply the Custom Views feature to manage the hidden/visible status of columns, rows, worksheets, print settings, and more.