MICROSOFT EXCEL-INTERMEDIATE LEVEL

Linking Workbooks and Worksheets

1.1  Linking Workbooks and Worksheets

1.2  Linking Worksheets with 3D References

1.3  Understanding the Consolidate Feature

Working with Range Names

2.1  Using the Name Box and Define Name

2.2  Using Create from Selection

Sorting and Filtering Range Data

3.1  Differences Between Sorting and Filtering

3.2  Sorting Lists

3.3  Filtering Lists

3.4  Creating Subtotals

Analyzing and Organizing with Tables

4.1  Creating Tables and Understand the Benefits

4.2  Understanding the Elements of a Table

4.3  Formatting a Table

4.4  Sorting and Filtering Tables

4.5  Filtering with Slicers

4.6  Calculating with Tables

Using Conditional Formatting

5.1  Highlight Cells and Top Bottom Rules

5.2  Data Bars, Icon Sets, and Color Scales

5.3  Using Custom Fonts and Colors

5.4  Using Custom Conditional Formatting

5.5  Modifying or Removing Conditional Formatting

Displaying Data Graphically

6.1  Creating Charts

6.2  Understanding Chart Elements

6.3  Formatting Charts

6.4  Creating Dual Axis Charts

6.5  Creating a Chart Template

6.6  Displaying Trends with Slicers

Understanding PivotTables, PivotCharts and Slicers

7.1  Creating a PivotTable

7.2  Working with PivotTable Fields Pane

7.3  Formatting PivotTable

7.4  Creating a PivotChart

7.5  Formatting PivotChart

7.6  Using Slicers and Timeline Slicers