Microsoft Excel - Mastering Formulas in Excel
- 28.03.2021
- 201
Created by Keith Griggs | Published 8/2020
Duration: 42m | 3 sections | 9 lectures | Video: 1280x720, 44 KHz | 790 MB
Genre: eLearning | Language: English + Sub
A very basic knowledge of ExcelA working copy of Excel installed.
Master Formulas in Excel from a self confessed Microsoft Excel fanatic (Windows Excel 2007 to Excel 2019)
How to count cells
How to round numbers
How to compare two lists
How to use vlookup
How to use hlookup
How to copy formulas
I am using Excel version 2019 for Windows, but hopefully your version will not be much different
Welcome to my Mastering Formulas in Excel course.\n\nYou will learn the fundamentals of working with formulas, which really unleashes the hidden power of Excel.\n\nI used the Windows version of Excel current in 2020 to make this course, but other versions should not be that different.
I will be creating a spreadsheet during the course that you can . The idea is that you work along with me, then you can compare our spreadsheets. This is the very best way to learn.
I love Excel, and I hope to share my passion and enthusiasm for this amazing software onto you, as well as passing on all my skill and knowledge. Pretty soon you will be using Excel like a master, and you will save yourself so much , as well as look like a genius!\n\nIn this course I cover:
\n\nBasic introduction to finding and using Formulas in Excel
A closer look at some simple formulas
How to count cells with data
How to round numbers
How to compare two lists
Extracting data from a table using vlookup and hlookup functions
Copying formulas so that they work - absolute and relative references
DOWNLOAD
uploadgig
rapidgator
nitroflare