Curriculum
- 1 Section
- 7 Lessons
- 1 Day
Expand all sectionsCollapse all sections
- Topics7
- 1.1Creating Advanced Formulas In this lesson, students will learn how to use range names in formulas and functions, as well as how to use specialized functions.
- 1.2Analyzing Data with Logical and Lookup functions Next, students will learn how to analyze data by using text, logical, lookup, date and financial functions.
- 1.3Organizing Worksheet Data with Tables This lesson covers how to create, format, and modify tables. We also cover using structured references, as well as the subtotal and database functions.
- 1.4Visualizing Data with Charts Students will learn how to create charts, as well as how to modify and format existing charts. They will also learn how to create a trendline and advanced charts.
- 1.5Analyzing Data with PivotTables, Slicers, and PivotCharts Creating a PivotTable, filtering data using slicers and, analyzing data using PivotCharts will be covered in this lesson.
- 1.6Working with Graphical Objects Next, students will learn how to insert, modify, layer, and group graphical objects. We will also take a look at how to incorporate SmartArt into workbooks.
- 1.7Enhancing Workbooks In this final lesson, students will learn how to customize workbooks, manage themes, protect files and, prepare a workbook for multiple audiences.
Analyzing Data with Logical and Lookup functions Next, students will learn how to analyze data by using text, logical, lookup, date and financial functions.
Next