This beginner course will allow you to create a simple spreadsheet such as managing household income and expenses but also data manipulation (create, modify, formatting/alignment, sorting, filter, simple formulas, shortcuts, move/select , tabs...)
I will show you:
- Elements (toolbar, menus, tabs, etc.)
- How to create a file (blank sheet or from a template) + save
- Tips and tricks about tabs
- Shortcuts + tips and tricks for selecting an info zone,
- Display menu (display the information without losing the title...)
- Conditional formatting
- Layout for printing
- Create a table
-WordArt
- Import data to format
- Subtotals / group
- Protect the workbook
Another module will also arrive for more advanced functions:
- PivotTables
- More complex formulas (concatenate, vlookup, xlookup...)
- Audit
- Graphics
- Power query
- Macros
- ... on demand
Reviews (0)
No reviews yet. Take a class with this teacher and help improve her or his profile by posting a first review!
Good-fit Instructor Guarantee
If you are not satisfied after your first lesson, Apprentus will find you another instructor or will refund your first lesson.
Online reputation
- Instructor since December 2021
- Phone number verified
- Google connected