← Back to courses
Data Science and AI
Excel Formulas and Functions
One week from typing numbers to calculating with them
A one-week classroom course on the formulas and functions area of Microsoft's own Excel training. You learn how formulas and cell references work, then the functions used every day for totals, conditions, lookups, text and dates. This course prepares for no exam.
5Modules
BeginnerLevel
1 weekDuration
COURSE THUMBNAIL
What you will be able to do
Write formulas with correct relative and absolute references
Use logical and lookup functions to answer questions about data
Clean text and work with dates
Course outline
01
Formulas and cell references
02
Totals, averages and counts
03
Logical functions: IF and friends
04
Lookup functions
05
Text and date functions
Tools you will use
Microsoft Excel
What you need
General computer skills
