Microsoft Excel Tips, Tricks & Time Savers Complete

In this Excel Tips, Tricks and Time Savers Complete training class you will become comfortable with the interface, navigate and modify your spreadsheets with simple clicks on the keyboard or handy mouse techniques, and learn loads of useful timesaving tricks. Make full use of Excel's powerful Fill Handle, insert multiple rows at once and insert rows and columns with a simple click of the keyboard. Set your list back to its original sort order, duplicate your worksheet with a simple drag-and-drop, and update values on the spot with Paste Special. This class also covers some useful Pivot Table tricks and how to make your conditional formatting more flexible with checkboxes and drop-down lists. Learn some useful charting tricks, including how to create charts with a keystroke and how to add creativity and readability by including pictures and smoothing out lines. You will even learn how to put together a Gantt chart in Excel! You will:

• Update values on the spot using Paste Special
• Become more efficient by making full use of Excel's Fill Handle
• Insert multiple rows at once
• Organize your workbook by colour-coding your sheet tabs
• Set your list back to its original sort order
• Input values with leading zeros
• Quickly transpose blocks of data
• Capture and insert screenshots in Excel
• Duplicate your worksheets with a simple drag-and-drop
• Create multi-tiered data validation lists
• Make your IF statements more flexible and powerful with wildcards
• Create Gantt charts in Excel
• Learn 10 useful Pivot Table tricks
• Generate a unique list with Advanced Filters
• Use checkboxes and drop-down lists to make your conditional formatting more flexible
• Insert and work with an Excel spreadsheet inside a Word document
• Create custom date formats
• Copy only the visible cells from subtotaled data