Duration
2 days
Course Outline
Topic 1: Illustrate Information in Graphic
Lesson 1: Working with Charts, Part 1
- Creating Charts
- Formatting a Chart
- Modifying Chart with the Layout Tab
- Manipulating a Chart
- Enhancing a Chart with Shapes and Graphics
Lesson 2: Working with Charts, Part 2
- Changing the Type of Chart
- Changing the data sources
- Working with the Chart Axis and Data Series
- Saving a Chart as a Template
Topic 2: Printing
Lesson 1: Printing your workbook
- Open Print Preview
- Using the Print Preview Tab
- Quick Printing
- The Print Dialog
- Using Page Setup
Topic 3: Formula & Function
Lesson 1: Using Formulas in Excel
- Understanding Relative and Absolute Cell References
- Basic Mathematical Operators
- Using Formulas with Multiple Cell References
- The Formula Auditing Buttons
- Fixing Formula Errors
- Displaying and Printing Formulas
Lesson 2: Exploring Excel Functions
- What are Functions?
- Finding the Right Function
- Some Useful and Simple Functions
Lesson 3: Using Function in Excel
- Inserting Functions
- Using Functions and AutoFill to Perform Difficult Calculations
- Using the IF Function
- Working with Nested Functions
Lesson 4: Working with Names and Ranges
- What Are Range Names?
- Defining and Using Range Names
- Selecting Nonadjacent Ranges
- Using Auto Calculate
Lesson 5: Using Advanced Functions
- Using the PMT Function
- Using the FV Function
- Understanding Logical Functions
- Using Logical Functions
- Using IFERROR with Array Formulas
Lesson 6: Using the VLOOKUP Function
- Understanding VLOOKUP and HLOOKUP
- Using VLOOKUP to Find Data
- How to Find an Exact Match with VLOOKUP
- Finding an Approximate Match with VLOOKUP
- Using VLOOKUP as an Array Formula
Topic 4: Managing Tables
Lesson 1: Working with Tables
- What is a Table?
- Creating Tables
- Modifying Tables
- What is the Total Row?
Lesson 2: Working with Records and Fields
- What are Records and Fields?
- Adding Fields by Inserting Columns
- Adding Records by Inserting Rows
- Quickly Adding Records to a Data table
- Deleting Records or Fields
Lesson 3: Working with Tables and Filters
- Sorting Data in a Table
- What is an AutoFilter?
- Custom AutoFilters
- Using an Advanced Filter
- Copying Filtered Records
Lesson 4: Using Excel as a Database
- Filtering with Wildcard Characters
- Validating Your Data
- What are Database Functions?
Topic 5: Using Objects
- Creating New Embedded Objects
- Embedding Existing Files
- Editing Embedded Objects
- Embedding Parts of Files
Topic 6: PivotTables and Pivot Charts
Lesson 1: PivotTables
- What is a PivotTable?
- Creating a PivotTable
- Creating a PivotTable Frame
- Specifying PivotTable Data
- Rearranging PivotTable Data
Lesson 2: More about PivotTables
- Modifying PivotTable Calculations
- Formatting a PivotTable
- Refreshing a PivotTable
- Charting a PivotTable
- Creating a PivotTable Based on External Data
Programme scope, delivery arrangements and suitability are confirmed during enquiry.