Excel beginners tutorial: basic formulas and functions
Автор: AnnMatt Erasmus
Загружено: 2020-10-22
Просмотров: 1852
Excel tutorial basic formulas and functions
In this Excel tutorial I work through basic formulas and functions. I demonstrate how to use the following Excel formulas. How to enter basic formulae in Excel as well as using Sum and Add, Subtract, Divide and Multiply data entered in Excel spreadsheets. .
1. Max and Min
2. Average
3. Count and count if
4. Excel If – function
Remember all excel functions and formulas start with the ‘=’ sign. When the = sign is typed Excel ‘knows’ a function or formula is to follow and will provide, prompts, drop down menus and guidance for completing the formula.
Why not watch the whole Excel tutorial course of 7 videos for beginners here:
• Excel beginner's tutorial: create your fir...
Comments are most welcome, if you decide to try this please send us some feedback☺️ Why not visit our channel and browse through our other videos? / annerasmus
Video Chapters time stamps
Here are some time stamps for browsing the content of this video:
00:00 Beginning
01:04 How to enter a basic formula like 2 + 2 in an Excel worksheet
02:29 How to use Excel functions: Sum, Average, Minimum, Maximum etc
04:09 How to Auto-populate cells with a formula or function in Excel
09:31 How to use Count and Count if commands in Excel
11:56 How to use Excel's 'If' function for beginners
13:56 How to access formulas and functions in Excel for beginners
An illustrated text version of this tutorial appears on the blog: https://basiclowdown.com/excel-tutori...
Short Disclaimer/disclosure: My videos/articles are for informational and educational purposes only, you should consult with a professional before attempting anything seen or done in my videos/articles. Please read full disclaimer here: https://basiclowdown.com/disclaimer-d...
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: