TRAINING COURSES
Microsoft Excel 2019 – Intermediate
Summary
- Price:
- $385.2
- Language:
- English
- Funding:
- WSQ/SDF,SkillsFuture Credit
- No. of Days:
- 2 Days
- Location:
- Central
| Funding | Individual | |
| Full Cost | S$385.2 | |
| Please refer to the "Funding" tab to understand details breakdown | ||
| How much you need to pay? | Login to find out more about the funding | |
Course ID |
Course Start Dates / Time |
Remarks |
Course Status |
|
No Course Date |
||||
This course is designed for participants who want to learn to how to manage data ranges, protections, create tables, create charts, insert formulas/functions, tracing errors, manage names, sort and filter of data. In additions, you will learn Vlookup formulas, IF functions and have an introduction to the Pivot Tables for reporting or summarizing your data.
Some of the topics include :-
- Using Paste Options and Paste Special Commands
- Create and Manage Conditional Formatting
- Learn how to use Name Manager
- Displaying and Tracing Formulas
- Understanding of Formula Errors.
- Use of Logical Functions such as IF, AND and OR
- Use of Conditional Count, Sum and Average Functions
- Learn Nested IF and Vlookup Functions
- Use of Database Functions such as DSUM()
- Learn the Protection of Workbook, Worksheet & Element
- Create a Custom AutoFill List
- Creating a Custom Number Format
- Sorting by Multiple Columns and Custom List
- Use of Advanced Filter
- Working with Tables by Adding and Removing Data
- Use of Table Total Row
- Removing Duplicate Rows of Data
- Introduction to basic use of PivotTable
- Creating and Working with Charts
Essential Excel Fundamental
- What’s New in Excel 2019
- Understanding the Excel Program Screen
- Changing Excel’s Default Options
- Customizing the Quick Access Toolbar
- Entering Content Automatically
- Using Paste Options and Paste Special Commands
- Applying Conditional Formatting
- Creating and Managing Conditional Formatting Rules
Introduction to Functions and Formulas
- Overview of Formulas and Cell References
- Entering Formulas
- Absolute and Relative References
- Formulas with Multiple Operators
- Inserting and Editing a Function
- Cell and Range Names
- Displaying and Tracing Formulas
- Understanding Formula Errors
- Using Logical Functions
- Using Conditional Count, Sum and Average Functions
- Using Lookup Functions
- Using Database Functions
Managing Workbooks and Protections
- Splitting and Freezing a Window
- Working with Multiple Workbook Windows
- Protecting Workbooks
- Protecting a Workbook Structure
- Protecting Worksheets and Worksheet Elements
Working with Data Ranges
- Creating a Custom AutoFill List
- Creating a Custom Number Format
- Sorting by Multiple Columns and Custom List
- Filtering Data
- Creating a Custom AutoFilter
- Using an Advanced Filter
Working with Tables
- Creating a Table
- Adding and Removing Data
- Working with the Total Row
- Sorting a Table
- Filtering a Table
- Removing Duplicate Rows of Data
- Slicers
- Formatting the Table
- Summarizing a Table with a PivotTable
- Converting to a Range
Creating and Working with Charts
- Choosing and Selecting the Source Data
- Using Quick Analysis
- Choosing the Right Chart
- Inserting, Moving, Resizing and Deleting Chart
- Elements of a Chart
- Modifying Chart Data
- Changing Chart Data
- Filtering Chart
- Changing Chart Layout, Style and Colors
- Working with Chart Labels
- Changing Chart Gridlines
- Changing the Scale
- Emphasizing Data
- Changing Chart Type
- Using Sparklines
- Location:
- Central
- Address:
- Multiple Location
- Building Name:
- -
- Postal:
- -
@Ask Training
@ASK Training Pte Ltd is specialised in providing ICT Training (Microsoft Office 2010, Microsoft Office 2013, PC Maintenance, Video and Audio Editing & Website Design) and Soft Skills Training (Management, Interpersonal, Writing, Presentation & Motivational Skills) to government agencies and corporate clients in Singapore.
In 2014, we are accredited by WDA as an Approved Training Organisation (ATO) to provide WSQ Training and Assessment. We have since expanded our training programmes to include ICDL (International Computer Driving Licence) certification courses.
As a committed training provider, we strive to deliver effective training programmes for participants to enjoy personal growth in learning and achieve higher business productivity in their organisation.
Training Center
Total No. of Review Submitted: 0 |
Average Score: |
Rating |
Remarks |
From |
When |
Course |
No Course Review |
||||
The following are details breakdown of the funding
| Individual | ||
| *Funding | ||
| WSQ | Login to find out more about the funding | |
| SkillsFuture | - | |
| Productivity & Innovation Credit | - | |
| How much you need to pay? | Login to find out more about the funding | |
Note
- Funding is subjected to approval from the government agencies
- The amount is calculated based on the "Up to" percentage of the course fees
- Taking into assumption that you have not fully utilized the SkillsFuture Credit and Productivity & Innoviation Credit Scheme
Other courses available by @Ask Training
Expected Investment
| Total Cost | S$ 0 |
| Expected Saving | S$ 0 |
 |
|
| Expected Investment | S$ 0 |
Total Cost
| Course Fee | S$ 385.2 |
| Number of employee(s) | 0 |
|
|
|
| Total Cost | S$ 0 |
Copyright © TTW Pte Ltd. All Right Reserved
