Excel courses / programme / Excel teacher online
The agenda of Excel for Beginners and for Advanced Users courses you will find linked below:
Excel for Beginners:
Basic information on Microsoft Excel:
Introduction to Excel:
- worksheet functions in a workbook
- a ribbon functions’ overwiev
- context menu use
- customize the Quick Acess Toolbar
- dialog box launch
Inserting and editting data:
- types of data in a worksheet
- inserting text and value to a worksheet
- inserting dates and time
- modification of cells’ content
- numbers’ format functions
Main worksheet actions:
- basic rules for a worksheet use
- worksheet view
- use and work of rows and columns
Cells selection:
- selecting cells and a range of cells
- copy and drag functions for the range of cells
- naming the boxes
- adding comments to cells
Tables:
- what’s a table?
- creating a table
- modification of a table
- use of tables for different purposes
Worksheet formatting:
- formatting tools overwiev:
- adjusting a text
- colouring and shading
- borders and styles
- Format Painter use
Formulas and functions:
- introducing formula and function section:
- basic information on formula
- inserting a formula to a worksheet
- formula bar and formula edit
- cell formula reference
- the most common formulas errors
- advance technique of creating file names
- useful tips
Formulas usage for text function:
- introduction to Excel text function
- text function review
- advance text formulas
Date and time formats:
- Excel interpretation of date and time formats
- functions referring dates
- functions referring time zones and time units
Math and trigonometry formulas (functions):
- counting and summation of worksheet cells
- basic counting formulas
- advance counting formulas
- sum formulas
- conditional sums / one criteria
- conditional sums / a few criteria
Excel for Advanced Users:
Management and data analysis:
- data sorting
- filter data / advance filter
- filter data via many criteria (or, if)
- tools for data analysis
Advance formatting techniques:
- view type, fields, colors, fonts, borders and styles
- adapting numbers and date formats
- tables, styles, rows, columns and cells setup
Displaying time and date in Excel:
- description of time in Excel – time as a number (format numbers)
- creating time and date and its proper formatting
- time operations, time functions practical use
Inserting and using charts in Excel:
- inserting data, formatting for charts organization (Excel data table)
- chart mode selection for particular data:
- column, line, pie, bar, area charts etc.
- advance charts e.i. stock exchange charts, radar charts, area charts etc.
- charts edit: adding elements, changing fonts and styles
Searching data options:
- using logic functions: if, or, and
- using functions: row function and column function
- using functions: chose, find and index
- using nested function for searching within other search functions.
Excel functions:
- using functions in Excel
- math and trigonometry function and its logic variation based on proper criteria
- statistics, math and text functions usage
PivotTables:
- creating and updating a PivotTable
- working with data within PivotTables: how to sum, sort and filter data
- adding conditional formattin to a PivotTable
- creating charts on basis of PivotTables
- Pivot Tables modification via macros
- analitical tools based on PivotTables
Advanced use of Excel 2013:
- keyboard shortcut selection
- the ribbon effective use and customizing Quick Access Toolbar
- fixing the most common formula errors – analysis
Excel course / contact
If you are interested in our offer as above, please do not hesitate to contact us to set all the necessary details. Please, remember to provide us with a short information referring your Excel skills level and possible terms for classes to be held.