Microsoft Excel Training 【Make your daily work go easier and smoother.】

This training helps participants learn the basics of Excel for data management and document creation.

Learn the basics of Excel and apply it at work.

Who Benefits the Most

New Employee Young employees Mid-level employees Manager

  • For those who are planning to change career and get a job that requires Excel skills.
  • For those who want to create documents quickly and to increase work efficiency.
  • Those who want to learn basic Excel skills, such as creating tables and using functions, regardless of industry or job position.
Lineup Overview Feature Curriculum

Information updated

Training in this category helps resolve further issues and concerns

Training Issue
  • When employees do not know how to utilize Excel's rules or formula setup.
  • For those who want to improve productivity by learning about Excel's function set up for data input.
  • For those who want to create impressive documentation by learning how to create graphs or formulas for different purposes.
  • For those who want to better utilize Excel by learning the right way to use it.

Microsoft Excel Training Overview

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.

The Excel functions you want to master.

Here are some of the popular training that teaches practical Excel functions.

How to use cells.

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.

How to make graphs.

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.

How to use functions.

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.

Features of Microsoft Excel Training

Reskill's Microsoft Excel Training has the following features.

Goal-oriented training courses available.

Courses are available according to your training goals. Topics include Excel introduction, advanced applications using functions, VBA courses that require programming, macros, etc.

Practical Learning

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.

Excel Basics and Application courses

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)
Get a Quote (in 10 secs.) General Inquiry Request Information

Lineup of Microsoft Excel Training

Microsoft Excel Training

This training helps participants learn the basics of Excel for data management and document creation.

Training Course TitleTraining Duration
Microsoft Excel Training In-company Basic Microsoft Excel Training [Short Term Intensive Training] 6 hours
(Can be changed)
Microsoft Excel Training In-company Advanced Excel Training [Functions to Pivot Tabels] 6 hours
(Can be changed)

Training Curriculum

Here is an example of a curriculum for Microsoft Excel Training. Please use it as a reference for the flow of the training.

  1. 01Overview of Excel

    Goal

    Gain the ability to expertly navigate the Excel user interface, perform basic calculations with formulas and functions.

    • Motivation and attitude towards learning
    • Overview of Excel
    • Basic navigation /Excel interface
    • Basic learning of data entry (move the active cell)
    • Data entry basics (text and numbers) and data correction
    • Efficient data entry
    • Description of each format setting
    • Adding Rows/Columns/AutoFill
  2. 02How to create formulas, functions, and do calculations

    Goal

    Understand the rules for using function in formula and gain the ability to perform basic calculations with formulas and functions.

    • Basic calculations with Excel
    • Basic excel formula and functions
    • Using the function wizard
    • Relative and Absolute Cell References
    • Work: Practice Excel formulas
  3. 03Boarders and Graphs

    Goal

    Gain the ability to create easy-to-read charts and graphs by adding boarders

    • How to add and create boarders
    • How to make a graph
    • Chart Components
    • Work: Graphing excersice
  4. LASTWork: Excel Exercise

    Goal

    Implement what you learnt and put it into practice.

    • Exercise 1: Discount
    • Exercise 2: Multiplication tables
    • Exercise 3: Expense management
    • Level up: Demographics
Get a Quote (in 10 secs.)

TOP

研修のお問い合わせはこちら

Learn more about our services

Office Hours Mon-Fri 9AM-6PM Local Time