Basic Microsoft Excel Training [Short Term Intensive Training]

Short Term Intensive Basic Excel Training Course

Participants will learn the essentials of Microsoft Excel in this course.
Participants will be able to navigate Excel, perform basic calculations with formulas and functions, create graphs and learn useful productivity features of Excel such as shortcut keys.

3 Keys Features of Reskill Training

Full Preparatory Support

You will receive support not only during the training, but also prior to it. A complete set of training material and equipment will be delivered to you by mail beforehand. This will allow you to receive high-quality training with minimum preparation time.

Flat Rate Pricing

With the concept of "More Training", we make the courses available at a clear fixed price, even for a customized single-company training program that provides an excellent training environment.

Online Training Options

We offer various training formats with no additional charge, whether it be in-person, online, or a hybrid of both(partially web-based). Please feel free to contact us regarding your needs.

Training Code: 100146   Information updated:

Basic Microsoft Excel Training Goals

Participants will be able to navigate Excel spreadsheets with confidence, perform tasks more efficiently and improve productivity.

Target Trainees

The following is a general list of target participants for the training and can be adjusted upon review. Please contact us regarding your needs.

All Employees

Result of Basic Microsoft Excel Training

  1. Master the essentials of Microsoft Excel to perform tasks more efficiently and improve productivity.
  2. Participants will be able to create visually persuasive proposals using charts and graphs.
  3. Participants will be able to create layout-oriented print designs.

Training Objectives

1. Learn the basic functions of Excel in a short period of time

Participants will learn all the basic concepts and functions of excel as well as Excel shortcut keys.

2. Learn basic calculations with formulas and functions, create visualizations of data through graphs

Calculations with formulas and functions, and visualizing data with graphs are some of the prime features of Excel. Participants will be trained from the very basics of the software.

3. Participants will be able to create layout-oriented and visually pleasing print designs

Participants will learn key features of the software that can be put to use right away and be able to create layout-oriented documents.

Estimated Training Duration

6 hours (subject to change)

Basic Microsoft Excel Training Curriculum

Other training content can be incorporated into the curriculum upon request at no additional charge.

1. Overview 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 [What are the goals?]
  • Overview of Excel [Spreadsheets/Sort function/Formulas and funcations/Create charts and graphs]
  • Basic navigation [Start/Save/Exit]/Excel interface
  • Basic learning of data entry (move the active cell) [Using the mouse/Enter and Tab/Using the arrow keys/other methods]
  • Data entry basics (text and numbers) and data correction
  • Efficient data entry[copy and paste/cut and paste/paste options/range selection]
  • Description of each format setting [Character font/Character placement/Display format]
  • Adding Rows/Columns/AutoFill
2. How 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 [How to use formulas/Inserting mathematical symbols/Using the numbers in sheets]
  • Basic excel formula and functions [SUM function gives the total value/AVERAGE function calculates the average value/COUNT function counts the total number of cells with numbers/Lookup function]
  • Using the function wizard
  • Relative and Absolute Cell References [relative/absolute/mixed references]
  • Work: Practice Excel formulas
3. Boarders and Graphs [Goal] Gain the ability to create easy-to-read charts and graphs by adding boarders
  • How to add and create boarders [Borders/How to draw borders/Formatting cells]
  • How to make a graph [pie graph/bar graph]
  • Chart Components [Graph Area/Graph title/Replace Graph Items and Data Series/Change the scale of the vertical (value) axis/Useful functions/(Reference) Move and resize a graph]
  • Work: Graphing excersice
4. Work: 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

Training Cost

We provide tailored training programs for an entire company at a fixed rate. We will send you a quotation based on estimated training duration and number of participants.

  • The number of participants, training content and training formats can all be adjusted afterwards with no additional charge.
  • Last minute changes can be made with no additional charge.

Basic Microsoft Excel TrainingParticipant Requirements

No particular requirements

Area

Online and in-person training are available worldwide.

Frequently Asked Questions

Click here to get a quotation in 10 seconds.
Yes. The course is designed to meet the needs of our clients and teach skills that can be put into practice right away.
Online and partially web-based courses are both available upon request.

List of Frequently Asked Questions>

Related Training Information

This page is about Basic Microsoft Excel Training course planned for a single company. Please see below for other training courses and related training programs.

Reskill provide training services for a wide range of businesses.

研修実績

TOP

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

Learn more about our services

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