Microsoft Excel Intermediate

Dilihat 345

OVERVIEW

In this course, participants will work with Microsoft Office Excel to create spreadsheets and workbooks that can be used to store, manipulate, and share data. In the higher levels, the participants will work with charts and tables along with other useful formatting tools. They will also learn to create formulas that use built-in functions to perform advanced analysis. The class also covers the creation of shared workbooks and the tracking of changes within them.

OUTLINE COURSE

1. Intermediate Level

Create and Customise Charts
Create and Manage Tables
Present, Sort Data in a table
Automatic Calculations in a Table, Filtering
Blank cells and duplicates
Advanced filtering and statistics with a Criteria Range
Copy Rows Filtered Using a Criteria Range
Display Several Lines of data in One Cell
Absolute Reference in a Formula
Copy Values, Copy With a Link, Transposing
Move, Copy, Hide Sheets
Select, Delete, Copy and Move Objects
Format Chart Items; Modify Chart’s Text Items; Legend and Plot Area; Data Series and Chart Axes; Manage Series, Chart Templates
Create and Manage Sparklines
Modify a Text Box, Drawing
Rotate, Align, Stack and Group Objects
Apply, Manage Conditional, Custom Formats
Validation Criteria
Convert Data; Create a Data Series
Use Cell Ranges in Functions
Summarize Data with an Outline
Attach a Comment to a Cell
Calculate with Copied Values

2. Advance Level

Pivots Tables and Charts
Advanced Formulas (Lookup, Date Functions)
IF statements, AND and OR
Nested, Arrays and Conditions Formulas
Scenarios, Goal Seek and other advanced functions
Auditing and Error Checking
Templates and themes
Protecting workbooks
Sharing workbooks

TRAINING METHOD Offline Training: Presentation Discussion Case Study Evaluation FACILITY Training Kit Handout Certificate Lunch + 2x Coffee Break Souvenir