This training helps participants learn the basics of Excel for data management and document creation.
New Employee Young employees Mid-level employees Manager
In this training participants will learn about important Excel tools, as well as the basic and detailed usage of Excel.
Most of the time, employees work on Excel files that were already created. And it is not uncommon that workers don't know hot to use function options, graphs and chart creation to create an Excel file from scratch. This training helps participants understand the functions and mechanisms available in Excel and how to use them effectively, so they can work more efficiently and effectively.
Here are some of the popular training that teaches practical Excel functions.
People who are used to Microsoft Word often get confused about the concept of "cells." In this training, participants will learn how to change cell sizes, merge cells, and create tables.
Learn how to turn Excel charts into graphs that are easy to read. While graphs can be made at the click of a button, it is important to know which graph to use for different purposes. This can help create an effective document.
Excel is about calculations. Instead of doing the math manually, workers should use Excel to calculate average, sum, ratio, etc. Learning how to use simple functions can open doors to learning other functions. Participants will not only learn the basic functions, but also the functions needed for their specific tasks.
Reskill's Microsoft Excel Training has the following features.
Courses are available according to your training goals. Topics include Excel introduction, advanced applications using functions, VBA courses that require programming, macros, etc.
The curriculum focuses on practical training and learning from making actual documents. Participants will be able to apply what they learn here at work right away.
The following are the training content covered in the Basic and Application courses, which are the most popular ones.
The application course is meant for those who already have a basic understanding of Excel.
The following are other training courses available in this program.
Excel Macros Training
Excel VBA Training
Excel Training for temporary employees
Excel Training - The Basics | Excel Training - The Applications | |
---|---|---|
Explanation of Excel features | ● | |
Formatting | ● | |
Auto-Fill | ● | |
Explanation of functions | ● | ● |
SUM | ● | |
AVERAGE | ● | |
COUNT | ● | |
Relative reference/absolute reference | ● | |
IF | ● | |
IFS | ● | |
COUNTIF | ● | |
SUMIF | ● | |
VLOOKUP | ● | |
ROUND Function(Round down/up) | ● | |
Rank Function | ● | |
DAYS, EDATE | ● | |
Conditional Formatting | ● | |
User Format Setting | ● | |
Input Setting | ● | |
Border | ● | |
Pie charts | ● | |
Bar charts | ● | |
Compound charts | ● | |
Database creation(sorting・tabulation) | ● | |
Pivot tables・pivot graphs | ● | |
Comprehensive Exercises(Basic) | ● | |
Comprehensive Exercises(Application) | ● |
This training helps participants learn the basics of Excel for data management and document creation.
Training Course Title | Training Duration | |
---|---|---|
In-company Basic Microsoft Excel Training [Short Term Intensive Training] |
6 hours
(Can be changed) |
|
In-company Advanced Excel Training [Functions to Pivot Tabels] |
6 hours
(Can be changed) |
Here is an example of a curriculum for Microsoft Excel Training. Please use it as a reference for the flow of the training.
01Overview of Excel
Gain the ability to expertly navigate the Excel user interface, perform basic calculations with formulas and functions.
02How to create formulas, functions, and do calculations
Understand the rules for using function in formula and gain the ability to perform basic calculations with formulas and functions.
03Boarders and Graphs
Gain the ability to create easy-to-read charts and graphs by adding boarders
LASTWork: Excel Exercise
Implement what you learnt and put it into practice.
Learn more about our services
Learn more about our services
Office Hours Mon-Fri 9AM-6PM Local Time