12+
Оглавление - Jump into Excel. Training Course from Beginner to Intermediate in two hours
- Briefly about this course and me.
- Creating an Excel file from scratch
- Introduction to the Interface
- Filling in the file with the initial information
- Copy operation
- Paste operation
- Editing tables
- Sort operation
- Deleting a column
- Сreating a new column
- Formating the Header of table
- Mathematical calculation
- Formulas with Operators, Constants, References and Functions
- Main Excel Functions
- Preparing the Final table for printing
- Additional useful skills of working with tables
- How to repeat Header in every printing page
- How to insert additional rows and columns
- How to insert, show or hide a Note
- How to format cells using buttons on the Home tab
- How to change the format of all selected rows or columns
- How to group and hide columns and rows
- How to use the filter
- How to change number of decimal places on the Home tab
- How to change Cell Format not on the Home tab
- Conditional formatting operation
- Analytical tables in Excel
- How to summarize data. References. VLOOKUP Function or INDEX and MATCH Functions
- How to show totals of the table in a grouped form
- How to define logic or introduce a new criterion or new group
- How to correct errors in source data
- PivotTables
- Charts
- Сonclusion