top of page

Introduction into the Excel environment

  • They will distinguish between different Excel screens and will know how and when to use them.

  • They will understand cell references. 

 

 

​Main abilities - Worksheets

  • Input data for table calculations.

  • Edit, delete and move data from tables.

  • Insert and delete columns and rows.

  • Adjust column width and row height.

  • Working with several rows and columns at once.

 

 

Move and Copy Data

  • Data move and copy using the Excel menu icons. 

  • Data move and copy using the mouse and keyboard shortcuts.

 

Cell Formatting

  • Correctly apply cell formatting.

  • Correctly apply advanced cell formatting using the Formatting Screens.

  • Deleting Formattings.

  • Copying Formattings using "Format Painter".

 

Working with Excel Sheets 

  • Efficiently insert and rename new worksheets. 

  • Deleting Excel Worksheets.

  • Move and copy worksheets using the mouse.

What does the training offer?

 

In one standard length Excel training of 8 hours the curricullum will explain and exemplify the functions listed below. For maximum efficiency the training's concept is based at the client's location. For trainings outside your office, please contact us for a personalized offer. 

 

So, after the training, the students will master the following: 

The ability to easily handle an Excel workbook has become an important part of most people's workday. Even so, this is an area in which many easily get stuck. This happens because they don't have enough trust in their abilities or lack the knowledge.

 

This training will give them the trust and specific abilities to use Microsoft Excel for data input, modify and analyze the information needed for their job. They will learn to use Excel's functions and formulas to manipulate numbers as well as text strings, and will learn to generate charts that will help them communicate the information without effort to their clients, colleagues or managers.

 

vs.

Automatic Data Fill-in

 

  • Quickly copy cell contents by "dragging down"

  • Automatically enter sequential dates, days or months

  • Create your own numeric sequences

 

Formulas and functions

  • Accurately enter an Excel formula

  • Accurately enter an Excel function e.g. Sum, Min or Max

 

Freeze rows and Columns

  • Keep a portion of the sheet visible while the rest of the sheet scrolls

 

Printing

  • How to use Print Preview

  • How to change margins and paper size

  • Using Headers and Footers

  • Scaling the page to fit on A4

  • Using Page Break Preview

  • Using Page Layout View

 

Simple Charts

  • How to insert a simple chart to show your data accurately.

  • How to modify a chart

Standard Prices

* The prices include the transportation of the trainer team on a 100 km radius around Cluj Napoca;

** The accomodation and meal costs (where these are necessary) are not included;

 

Training excel cluj

Training excel cluj

Training excel cluj

Training excel cluj

Training excel cluj

Training excel cluj

Training excel cluj

Training excel cluj

Training excel cluj

Training excel cluj

Training excel cluj

Training excel cluj

Training excel cluj

Training excel cluj

Training excel cluj

Training excel cluj

Training excel cluj

Did you know?

... there are still people that even with an open Excel worksheet, that tend to use a handheld calculator.

 

bottom of page