Excel 2019, Level 2 - Intermediate
Versions 2013, 2016, 2019, Office 365, & Online are also available.
Course Outline
Lesson 1 – Working with Tables
- Creating a Table
- Enter Data into a Table
- Deleting Rows and Columns
- Formatting a Table
- Totaling Data in a Table
- Sorting Data in a Table
- Sorting Multiple Columns
- Filtering Data Using AutoFilter
- Creating Custom Filters
- Converting a Table to a Range
Lesson 2 – Working with Charts
- Creating a Chart
- Moving a Chart
- Resizing a Chart
- Changing the Layout and Style
- Labeling Chart Elements
- Formatting Chart Text
- Formatting Chart Elements
- Changing the Chart Type
- Showing or Hiding Gridlines
- Customizing Axes
- Creating a Pie Chart
- Creating a Map Chart
- Creating a Funnel Chart
- Changing a Chart’s Source Data
- Moving a Chart to a Different Worksheet
- Saving a Chart Template
- Filtering Chart Data
- Using Sparklines
- Customizing Sparklines
Lesson 3 – Working with Graphics
- Adding Pictures
- Inserting Online Images
- Adding Shapes
- Adding Icons
- Adding D Models
- Formatting Drawing Objects
- Inserting WordArt
- Inserting SmartArt
- Inserting an Organization Chart
- Modifying an Organizational Chart
- Taking a Screenshot
- Using Drawing Tools
- Drawing Simple Math Equations
- Generating Complex Equations
Lesson 4 – Workgroup Collaboration
- E-Mailing a Workbook
- Web Page Preview
- Converting Worksheets into Web Pages
- Inserting Hyperlinks
- Viewing and Editing Comments
Lesson 5 – Financial & Logical Functions
- Using the If Function
- Using Nested Functions
- Using the Ifs Function
- Using the PMT Function
- Using the FV Function
- Using AutoCalculate
Lesson 6 – Date and Time Functions
- Understanding Date/Time Functions
- Adding a Date and a Date Interval
- Subtracting Dates
- Calculating Time Intervals
Lesson 7 – Managing Workbooks
- Creating a Workbook Using a Template
- Creating a New Template
- Editing a Template
- Showing or Hiding Workbook Elements
- Creating a Workspace
- Comparing Two Workbooks Side by Side
- Saving a Workbook in a Different File Format
- Using Data Consolidation