Excel for the Real World

U1: First contact with Excel

- The top bar
- The Ribbon
- The spreadsheet
- Leaf handling
- Save book
- Save as / Save a copy
- Autosave (only for Excel 365)
- Save options

U2: Data entry and editing

- Data entry
- Editing and deleting data
- Data entry by reference
- Undo and redo

U3: Handling Rows, Columns and Cells

- Insert and delete rows and columns
- Adjust row and column dimensions
- Hide and show rows and columns
- Line break in a cell
- Naming ranges and cells

U4: Formats

- Basic cell formats
- Data alignment
- Text format
- Copy format

U5: Cell Fill and Paste Options

- Cell Paste Options
- Autofill cells

U6: Formulas and Functions

- Region settings
- Formula vs Function
- Arithmetic operators
- Comparison operators
- Ampersand operator (&)
- Reference operators
- Order of priority
- Relative, absolute and mixed references
- Function syntax
- Important note about functions
- Automatic functions
- Wizard and function library
- Common mistakes
- AVERAGE and AVERAGEA functions
- COUNT and COUNTA functions
- COUNTIF and COUNTIFS functions
- SUM function
- SUMIF and SUMIF functions
- RANDOM and RANDBETWEEN functions
- ROUND function
- IF function
- Nested Sl function
- IF.SET function
- And and Or Functions
- IFERROR function
- VLOOKUP function with arg. False
- VLOOKUP function with arg. True

U7: Printing and other functionalities

- Print preview
- Print settings
- Repeat headers for each sheet
- Header and footer
- Document printing 1

U8: Pivot tables

- What is a pivot table?
- How to structure information?
- My first pivot table
- Recommended pivot tables
- The field list panel
- Review of the data source table
- Add and remove fields
- The area of ​​values
- The areas of rows and columns
- The filter area
- Field hierarchy
- Create field groupings

Course evaluation

- This course contains a final exam

G-Tools: For Students

- Exclusive access to cutting-edge student tools: improve your employability, participate in exclusive events, take advantage of our intelligent virtual assistant, and more.

⚑ Certificate of completion

- Your personalized digital certificate, a unique badge of your achievements, with international validity, course duration and QR code for instant verification.