This program will teach students much more details of complicated calculation task such as the use of financial functions, statistic functions, data mining, advanced filter, pivot table etc.
Key contents include:
Unit 1: Using Logical Functions
- Working with Names and Ranges
- What Are Range Names?
- Defining and Using Range Names
- Using Logical Functions
- Using the Function Library
- Manually entering a function
- The IF function
- The AND Function
- The OR Function
- Working with Nested Functions
- Nested IF functions
- Using VLOOKUP to Find Data
- How to Find an Exact Match with VLOOKUP
- Finding the Closest Match with VLOOKUP
- Validating Your Data
- Creating Data Validation Settings
- Using Database Functions
- Creating a Criteria Range
- Entering the Database Function
- What is a PivotTable?
- Preparing Data to Create a PivotTable
- Creating a PivotTable
- Adding Fields to the PivotTable
- Creating a PivotTable Frame (Classic PivotTable Layout)
- PivotTable areas
- Rearranging PivotTable Data
- Hiding and Showing Field Data
- The PivotTable Tools Ribbon
- Modifying Calculations and Data Area Display
- Formatting a PivotTable
- Refreshing a PivotTable
- Using Slicers to Manipulate PivotTables
- Slicers
- Insert the Slicer
- Creating a PivotChart
- Using Scenarios in Excel
- Creating a Scenario
- Using Goal Seek
- Using Solver
- Checking Solver Installation
- Setting Solver Parameters
Back to Computer Program page
Mekong Training Center (MTC) is one of the centers of Cambodian Mekong University providing professional training programs, computer skills, and foreign languages - English, Japanese, and Korean.