Excel in One Day Training Course

Course Code

excel1day

Duration

7 hours (usually 1 day including breaks)

Requirements

  • Computer literacy
  • Knowledge of any operating system

Overview

This live instructor-led training (onsite or remote) will guide you through the most important tools of MS Excel. A combination of comprehensively prepared training materials and the expertise of the instructor will demonstrate the vast possibilities of excel spreadsheet use. 
In compartision to other typical excel courses, this tarining will uncover many uniqe excel functionalities that will speed up and enhance your work.

Format of the Course

  • Interactive lecture and discussion.
  • Hands-on implementation in a live-lab environment.

Course Customization Options

  • To request a customized training, please contact us.

Course Outline

The outline below is a suggested list of topics to be discuessed during the course of the training. The final curriculum may differ from the presented topics below, depending on the experience, expectations and needs of the participants.

 

Adjustment of the working environment

  • Hotkeys, facilities
  • Create and modify toolbars
  • Options paste special (transpose)
  • Formatting (style, format painter)
  • Tool - go to

Organization of information

  • Management sheets (naming, copying, color change)
  • Assign and manage the names of cells and ranges
  • Protect worksheet and workbook
  • Secure and encrypt files

Data analysis

  • Logic
  • Basic Features
  • Advanced Features
  • Creation of complex / multiple formulas
  • Scenarios
  • Search result
  • Solver
  • Charts
  • Graphics support (shadows, charts, AutoShapes)

Database management (list)

  • Data consolidation
  • Grouping and outlining data
  • Sorting data (over 4 columns)
  • Advanced data filtering
  • Database Functions
  • Subtotal (partial)
  • Tables and Pivot Charts

Automation of work

  • Conditional Formatting
  • Create your own formats
  • Check the validation

Testimonials

★★★★★
★★★★★

Related Categories

Related Courses

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in the US!

As a Business Development Manager you will:

  • expand business in the US
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!

This site in other countries/regions