Home » Microsoft Excel Intermediate – Advance
Microsoft Excel Intermediate – Advance
June 27, 2023
Jadwal Pelatihan Microsoft Excel Intermediate – Advance
| Tanggal | Tempat | Kota | | Belum ada jadwal terbaru |
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
Presentation
Discussion
Case Study
Evaluation
FACILITY
Training Kit
Handout
Certificate
Lunch + 2x Coffee Break
Souvenir
