Introduction
Course setup
Chapter 1: Tables
Module A: Sorting
Module B: Filtering tables
Module C: Structured references
Module D: Validation
Module E: Transposing data
Chapter 2: Summarizing data
Module A: Consolidation
Module B: Subtotals
Chapter 3: PivotTables
Module A: Creating and formatting PivotTables
Module B: Manipulating PivotTables
Module C: PivotCharts
Chapter 4: Advanced charts
Module A: Special chart types
Module B: Sparklines
Module C: Quick Analysis
Welcome to Microsoft Excel 2021/365 Charts and Pivots. This course provides advanced tools for analysis and presentation of complex, realistic data in Microsoft Excel: how to build more complex functions, use data analysis tools, make an impact with powerful chart features, and collaborate with other users.
The course assumes you know how to use a computer, that you're familiar with Microsoft Windows, and that you have introductory experience with Excel.
For more information and access to the PowerPoint files, please e-mail sales@30bird.com.
To request the PowerPoints for this course, please e-mail sales@30bird.com.
Excel 2021/365 Charts and Pivots
Excel 2021/365 Level 1 R1.1
Our Microsoft Excel 2021/365 Level 1 courseware provides the basic concepts and skills students need to start being productive with Microsoft Excel: how to create, save, share, and print worksheets that contain various kinds of calculations and formatting. Students will benefit most from this course if they want to accomplish basic workplace tasks in Excel, or if they want to have a solid foundation for continuing on to become an Excel expert.The courseware assumes students know how to use a computer, and that they're familiar with Microsoft Windows. It does not assume that they've used a different version of Excel or another spreadsheet program before.For more information and access to the PowerPoint files, please e-mail sales@30bird.com. ..
$21.70
Excel 2021/365 Level 2 R1.1
Microsoft Excel 2021/365 Level 2 builds on the basic concepts and skills of our Level 1 course to provide more advanced tools for analysis and presentation of complex, realistic data in Excel: how to manage complex workbooks, build more complex functions, use data analysis tools, make an impact with powerful chart and presentation features, and collaborate with other users.Students will benefit most from this course if they want to use Excel to perform real-world tasks such as rearranging and presenting complex data.The course assumes students know how to use a computer, that they're familiar with Microsoft Windows, and that they've taken the Level 1 course or have equivalent introductory experience with Excel.For more information and access to the PowerPoint files, please e-mail sales@30bird.com...
$21.70
Excel 2021/365 Level 3 R1.1
Microsoft Excel 2021/365 Level 3 builds on the concepts and skills of our Level 1 and Level 2 courses to provide advanced tools for solving real-world problems in Microsoft Excel: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, what-if-analysis, and macros.Students will benefit most from this course if they want to use Excel to perform real-world tasks such as handling and getting information from large amounts of data from sources inside out and outside of Excel, creating output that varies according to conditions, manipulating dates and text, and automating repetitive tasks.The course assumes students know how to use a computer, that they're familiar with Microsoft Windows, and that they've taken the Level 1 and Level 2 courses or have equivalent introductory experience with Excel. The exercises are more detailed and complex than those in the previous levels.For more information and access to the PowerPoint files, please e-mail sales@30bird.com...
$21.70
Excel 2021/365 Complete R1.1
Welcome to Microsoft Excel 2021/365 Complete. This course starts with the basic concepts and skills in Microsoft Excel, then builds on these to provide more advanced tools to solve real-world problems and analyze and present complex, realistic data.You will benefit most from this course if you want to use Excel to perform real-world tasks, such as rearranging and presenting complex data, getting information from large amounts of data from sources inside and outside of Excel, creating output that varies according to conditions, manipulating dates and text, and automating repetitive tasks. If you intend to take a Microsoft Office Core or Expert exam for Excel, this course will prepare you for both, covering all the objectives for both exams.The course assumes you know how to use a computer, and that you're familiar with Microsoft Windows. It does not assume that you've used a different version of Excel or another spreadsheet program before.For more information and access to the PowerPoint files, please e-mail sales@30bird.com...
$58.20