Definition & Purpose
In our Excel Intermediate class you'll create and filter lists, use graphing features to create bar, line and pie charts from spreadsheets, enhance your charts, and link formulas across sheets. You'll also learn Excel's database features, create your own template, and learn how to use pivot tables. Using advanced functions in formulas will also be practiced.
Course OutlineChapter One: Creating and Working with Charts
- Creating a Chart
- Moving and Resizing a Chart
- Formatting and Editing Objects in a Chart
- Changing a Chart's Source Data
- Changing a Chart Type and Working with Pie Charts
- Adding Titles, Gridlines, and a Data Table
- Formatting a Data Series and Chart Axis
- Annotating a Chart
- Working with 3-D Charts
- Selecting and Saving a Custom Chart
- Using Fill Effects
Chapter Two: More Functions and Formulas
- Formulas with Several Operators and Cell Ranges
- Using the Insert Function Feature
- Creating and Using Range Names
- Selecting Nonadjacent Ranges and Using AutoCalculate
- Using the IF Function to Create Conditional Formulas
- Using the PMT Function
- Displaying and Printing Formulas
- Fixing Formula Errors
Chapter Three: Working with Lists
- Creating a List
- Working with Lists and Using the Total Row
- Adding Records Using the Data Form Dialog Box and Insert Row
- Finding Records
- Deleting Records
- Sorting a List
- Filtering a List with the AutoFilter
- Creating a Custom AutoFilter
- Filtering a List with an Advanced Filter
- Copying Filtered Records
- Using Data Validation
Chapter Four: Working with Other Programs
- Inserting an Excel Worksheet into a Word Document
- Modifying an Inserted Excel Worksheet
- Inserting a Linked Excel Chart in a Word Document
- Inserting a Graphic into a Worksheet
- Opening and Saving Files in Different Formats
Chicago: (312) 920-8822
Oak Brook: (630) 705-9999
Hours: 8