Learn Excel step by step in a recorded and detailed course. Perfect for those who are starting from scratch or want to refresh their knowledge! Excel 2021 and Office 365 version - the most recent versions available. You can watch and practice whenever you want, as much as you want, on your computer and at your own pace!
Learn Excel step by step in a detailed, recorded course. Perfect for those starting from scratch or wanting to refresh their knowledge!
The course is based on Excel 2021 and Office 365 - the most current versions available.
You can watch and practice whenever you want, as much as you want, on your computer and at your own pace!
Opening: Introduction to Excel
Initial introduction to Excel, benefits and basic tools.
View the sheet
Using the sheet, rulers, and menus.
Data entry
Working with data such as date, number and text.
Correcting typos
Methods for quickly and effectively correcting errors.
Data design
Designing texts, phone numbers, and more.
Tables
Create and design neat tables.
Dates and numbers
Format and design of numbers, dates, percentages, and currencies.
Autofill
Using autofill to complete series.
Excel formulas
Writing and testing basic formulas.
Dragging formulas
Dragging and adjusting formulas to the sheet.
Functions in Excel
Introduction to useful functions.
Excel combined with AI
Using Excel's AI-based tools.
Bonus - Vlookup
Retrieving data from tables using the Vlookup function.
The course is suitable for beginners and those who want to refresh their knowledge!