Course description
This course will teach you how to use formulas and advanced functions, create and format tables, sort and filter, visualize data with graphs.
Course structure
For individual and corporate training, it is possible to adapt the syllabus.
Completion and summary of basic concepts
- keyboard shortcuts to facilitate work
- menu Insert differently, Find and replace
Formatting tables
- about inserting and removing cells, rows and columns
- about hiding and showing rows and columns
- about copying formats
Conditional Formatting
- using the cell value
- using the formula
- quick styles in conditional formatting
Formulas
- basic mathematical operations
- modification of the formula
- quick formula check
- about copying and moving formulas
- relative and absolute addressing of cells ($A$1)
- about entering more complex formulas
- about naming cells and regions
- about the effect of moves and copies in absolute addressing
Features
- about the use of basic functions and their display in the formula bar
- about entering a function in a cell
- editing formulas with functions
Function
- using basic functions and displaying them in the formula bar
- entering a function in a cell
- editing formulas with functions
- IF function
- selected functions from the Text, Date and Time category
Connection
- about linking sheets, Microsoft Excel workbooks
- about linking with Microsoft Word and Microsoft PowerPoint
Graphs
- automatic chart format – recommended charts
- basic types of graphs
- about creating and editing a chart
Database in Microsoft Excel
- about basic concepts
- the principles of working with data
- about anchoring the partitions
- about sorting data by value or format
- automatic filter
- about data grouping
Printing
- print area
- about repeating the header on each page
- about advanced page appearance settings for printing
