This podcast is an audio version of the video courses that I created for Microsoft Word, Excel, PowerPoint and Access. They aim to get you from beginner level to that needed for a certified Microsoft Master. Learn the skills that you need to get you to the Expert level and beyond.
Episode 046: Microsoft Excel, Level 7 Session 3
Topics in this episode: Create dual-axis charts, Add trendlines to charts, Save a chart as a template and create custom chart templates, and View chart animations.
Episode 045: Microsoft Excel, Level 7 Session 2
Topics in this episode: Create and manage custom conditional formatting rules, Create conditional formatting rules that use formulas, Create PivotCharts, and Manipulate options in and apply styles to existing PivotCharts.
Episode 044: Microsoft Excel, Level 7 Session 2
Topics in this episode: Custom Formatting - dates and text, and Custom Formatting - sections and colors
Episode 043: Microsoft Excel, Level 7 Session 2
Topics in this episode: Formatting number values, and Custom Formatting - number formatting.
Episode 042: Microsoft Excel, Level 7 Session 1
Topics in this episode: Filtering Data, including using Slicers, Group PivotTable data, and Reference data by using GETPIVOTDATA, and add and utilise calculated fields.
Episode 041: Microsoft Excel, Level 6 Session 3
Topics in this episode: Using FREQUENCY, Trapping errors with IFERROR and ISERROR, Creating our first PivotTable, and PivotTable Options