Adventures in Excel Introduction

Course overview

What you'll learn

• Basic Excel functions including SUM, AVERAGE, MIN, MAX, PRODUCT, POWER and SQRT

• Useful date functions including TODAY, EOMONTH, EDATE, and DAYS

• Generating random numbers using RAND and RANDBETWEEN; generating random dates; and randomly picking an item from a list or table

• The new RANDARRAY function in Office365

• The new IFS functions in Office365 including AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS, and SUMIFS

• Text functions including TRIM, LOWER, UPPER, PROPER, LEFT, MID, RIGHT, FIND, TEXTJOIN and CONCATENATE

• Logical functions AND, OR, and NOT and IS functions ISTEXT, ISNUMBER, ISBLANK and ISERROR

• How to create a drop-down list

• The new SORT and FILTER functions in Office365

• VLOOKUP and the new XLOOKUP function

• How to create a Pivot table and analyse data with one