Home » Online Training – Perform Advanced Spreadsheet Functions (Microsoft Excel 2016)
Online Training – Perform Advanced Spreadsheet Functions (Microsoft Excel 2016)
February 22, 2023
Jadwal Pelatihan Online Training – Perform Advanced Spreadsheet Functions (Microsoft Excel 2016)
| Tanggal | Tempat | Kota | | Belum ada jadwal terbaru |
OVERVIEW
Advanced Spreadsheets module is designed to further your spreadsheet application skills to an expert level, allowing you to master the advanced functions of spreadsheet applications, enabling them to produce more sophisticated reports, and to perform complex mathematical and statistical calculations. This will help you save time and improve productivity when working with spreadsheets.
COURSE OUTLINE
- Lesson 1: Using Conditional and Custom Formats
- Lesson 2: Using Templates
- Lesson 3: Sorting and Validating Data
- Lesson 4: Working with Advanced Filters
- Lesson 5: Charting Features
- Lesson 6: Creating/Revising PivotTables
- Lesson 7: Using Auditing Tools and Range Names
- Lesson 8: Importing and Linking Data
- Lesson 9: Using Advanced Functions
- Lesson 10: Using Scenarios
- Lesson 11: Using Worksheet Protection
- Lesson 12: Tracking and Merging Workbooks
- Lesson 13: Recording Macros
- Lesson 14: Comments & Paste Special
