46 episodes

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.

The Excel In Office podcast Phillip Burton

    • Technology
    • 5.0 • 1 Rating

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

    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.

    • 23 min
    Episode 045: Microsoft Excel, Level 7 Session 2

    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.

    • 26 min
    Episode 044: Microsoft Excel, Level 7 Session 2

    Episode 044: Microsoft Excel, Level 7 Session 2

    Topics in this episode: Custom Formatting - dates and text, and Custom Formatting - sections and colors

    • 21 min
    Episode 043: Microsoft Excel, Level 7 Session 2

    Episode 043: Microsoft Excel, Level 7 Session 2

    Topics in this episode: Formatting number values, and Custom Formatting - number formatting.

    • 19 min
    Episode 042: Microsoft Excel, Level 7 Session 1

    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.

    • 19 min
    Episode 041: Microsoft Excel, Level 6 Session 3

    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

    • 22 min

Customer Reviews

5.0 out of 5
1 Rating

1 Rating

Top Podcasts In Technology

Listeners Also Subscribed To