This Advanced course focuses on analysing data in Excel. You will also find it helpful if you spend most of your working day using Excel and need to learn more about the various functions.
By the end of this course you will be able to
work with logical functions such as IF, AND, OR and NOT
count up blank cells
add up cells that meet a certain criteria with COUNTIF
use V and H lookups to quickly pick up data
perform calculations based around dates and also create different types of charts depending on the data you have
Estimated Course duration is 3 - 4 hours. Each lesson take on average 3-5 minutes to complete.
You can also access our Quick Tip Videos, that only last a few minutes, under Tips and Tricks.
Course Content
string(3) "596"
Logical Functions
IF Function
Nesting Functions
AND & OR Functions
Not Function
Nested IF Functions
Maths and Statistical Functions
Count A Function
Count Blank Function
Count IF Function
Sum IF Function
Integer Function
Displaying and Printing Formulas
Lookups
VLookups
HLookups
Using Index
Using Match
Text Functions
Case
Left and Right
Concatenate
Working with Dates and Times
Calculation with Dates and Times
Subtracting Time
Subtracting One Year from Another
Working Out Your Age
How Many Days to a Future Date
Number of Weekdays Between 2 Dates
Add Days, Weeks, Months, or Years to a Date
How Many Minutes Have You been Alive
Charts
Column Charts
Line Charts
Bar Charts
Pie Charts
Area Charts
Scatter Charts
Stock Charts
Surface Charts
Doughnut Charts
Radar Charts
Bubble Charts
Histogram Charts
Pareto Charts
Waterfall Charts
Box and Whisker Charts
Sunburst Charts
Treemap Charts
Use the X inside a lesson to save your progress. Then click Continue
