Briefly about the course Microsoft Excel

  • 20 hours (30 academic hours)
  • 10 days
  • Start training - as agreed
  • Education in your office or on Skype
  • Cost - from 5800 Kč per person

Enroll in a course!

Information about the computer course Microsoft Excel

Computer course MS Excel 2010 / 2013 is designed for students with elementary theoretical and practical skills of work on the personal computer as user. Applicant must be able to work on the keyboard and to know the file system (disks, folders and files).

Microsoft Excel enters into Microsoft Office packet. The program Microsoft Excel has a strong position in the market of office software. Market is updated more and more frequently and Microsoft Excel offers a more attractive technology, becoming variability and more comfortable to use.

Microsoft Excel 2010/2013 - the most popular office application to work with tabular data. According to a survey of computer media spreadsheets Excel are used in most offices.

Microsoft Excel 2013 - the latest version of the package Microsoft Office, has all the advantages of previous versions of Microsoft Excel. The developers called it as "tools for life".

Having mastered Microsoft Excel, you without special difficulties will be able to process and analyze tabular data.

This course will be interesting and useful for people of different professions, regardless of age, basic education and activities.

Instructor: Marina Tkachenko

 

Our advantages:

  • Individual training
  • The possibility of learning in your office
  • Convenient time employment
  • The course optimized for your tasks
  • Certified teachers
  • Free advice on the best bunch of programs to achieve maximum effect from training
  • Certificate of training center of CGClass

Cost of training MS Excel

On Skype

Individually in your office

Corporate Training
in your office (per person)

6200 Kč

7500 Kč

2–10 persons — 6400 Kč
over 10 persons — 5800 Kč

The program of the computer course MS Excel 2010 / 2013

Class

Introduction to interface: ribbon, tabs, groups, commands. Quick access toolbar. Status bar.
Work with file: create, save, open, close, recent files. Options.
Structure: workbook, worksheet, rows, columns, cells, formula bar.
Operations with sheets: rename, insert, delete, move, copy, select color for sheet.
Transactions with rows, columns, cells: adding, deleting, setting the size, move, copy, paste.
Show or hide columns and rows. Freeze rows and columns.
Data entry, editing. Moving data in the table. Selecting of ranges in the table.
How to speed up data entry: enter the data in the selected range, data duplication, auto-fil, auto-completion.

Class

Cell formatting: alignment, font, border, fill, size. Format painter. Clear the content and data formats.
Data Types: number, currency, accounting, date, time, percentage, fraction, scientific, text, general. Rounding, separators, digit capacity.
Conditional Formatting.
Adding notes to the cells. Changing, copying, viewing and display of notes.
Protection of information (for workbooks, worksheets). Hide formulas.
Printing documents from Microsoft Excel: print settings. View the document before printing. Defining the parameters of pages: size, orientation, centering on the page field. Create headers and footers. Setting and clearing the print area.

Class

Range names for more efficient processing.
Inserting special characters.
Inserting images. Using figures in the table.
Creation of SmartArt. Using WordArt.
Enter mathematical formulas. Using constants, brackets, math operations, cell references when entering the formula.
Relative and absolute references, references to other worksheets.

Class

Working with formulas and functions
Copying formulas.Errors in the formulas. Trace precedents and dependents in formulas. Using Watch window.
Different types of built-in Excel functions. Math & Trig functions. Statistical functions.

Class

Functions
Text functions. Date & Time functions. Lookup & Reference functions.
Logical functions. Financial functions. Editing function arguments.
Combining functions and formulas. Inserted functions.

Class

Charts
Creating charts based on the table data. Modification of charts.
Formatting charts. Printing charts.

Class

Creating and maintaining tables.
Remove duplicates. Distribute text to columns.
Data validation. Consolidation. Grouping and subtotals.
Sorting data. Sort by one criterion. Multi-level sorting. Sort by formatting.
Filtering data. Advanced sorting and filtering.
Get External Data.

Class

Pivot Tables and Pivot Charts
Create a Pivot Table. Configure the Pivot Table fields. Adding calculated fields to Pivot Table.
Creating a Pivot Chart. Updating Pivot Chart.

Class

Trendy forecasting.
Regression analysis: FORECAST, TREND, GROWTH.
Trendline. Seasonality.

Class

What-If analysis.
Writing macros using makro recorder. Create a button to run the macro. Editing macro with VBA editor.
Creation of custom templates.

On computer courses Microsoft Excel 2010 / 2013, we can offer you a personalized itinerary and corporate training.

We are waiting for you on the Microsoft Excel courses in Prague!