Description
In this course, you will learn:
- This tips-based course will show Excel users productivity-boosting tricks, cool hidden features, need-to-know functions, and advanced content on subjects such as using PivotTables for data analysis.
Syllabus:
- Excel Tips - New This Week
- Contrasting uses of clustered column and stacked column charts
- Previous Episodes
- Hide and unhide worksheets securely
- Resizing, moving, copying, and manipulating charts and other objects
- Using list boxes and combo boxes to facilitate forms creation
- Using the FORMULATEXT and N functions for worksheet and formula documentation
- Using the ISBLANK and COUNTBLANK functions to check for and tabulate blank cells
- Using check boxes and conditional formatting together for dynamic displays
- Becoming more productive with these 10 tiny tips you'll use often
- Transposing data and charts for a different perspective on your data
- Applying conditional formatting across rows of data
- Exploring various layouts for your PivotTable
- Splitting and consolidating workbooks
- Using date and time as metrics in a PivotTable
- Adding illustrations to your workbook
- Using a pick list, VLOOKUP, table, and chart together
- Using formulas to calculate values across worksheets and workbooks
- Dynamically presenting data via chart slicers
- Parsing your data to create unique lists
- Using the REPT function to represent data visually
- Using source data from a table to make your PivotTable more dynamic
- Accelerating Cut, Copy, Paste, and Insert tasks
- Highlighting PivotTable results with conditional formatting
- Customizing templates to fit your unique needs
- Creating dynamic charts with in-cell conditional formatting
- Enhancing table filtering with slicers
- Converting charts into pictures
- Quick formatting tips
- The top five unknown but useful keyboard shortcuts
- Using the TREND and GROWTH functions for projecting future results
- Using scroll bars and spin buttons to facilitate forms creation
- Creating colorful 3D buttons for worksheet annotation and macro buttons
- Calculating with hours, minutes, and times of day