Adventures in Excel

Adventures in Excel, available at $19.99, with 10 lectures.

You will learn about 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 This course is ideal for individuals who are Students of business or Anyone wanting to develop their Microsoft Excel skills It is particularly useful for Students of business or Anyone wanting to develop their Microsoft Excel skills.

Enroll now: Adventures in Excel

Summary

Title: Adventures in Excel

Price: $19.99

Number of Lectures: 10

Number of Published Lectures: 10

Number of Curriculum Items: 10

Number of Published Curriculum Objects: 10

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Students of business
Anyone wanting to develop their Microsoft Excel skills

Target Audiences

Students of business
Anyone wanting to develop their Microsoft Excel skills

Microsoft Excel has hundreds, if not thousands, of functions and features. This course aims to cover some of the best – that is the ones I find most useful. In “Adventures in Excel”, I cover the simple-to-use but powerful functions that I use most often:

· Basic features including SUM, AVERAGE, MAX, MIN, PRODUCT, SQRT and POWER

· Key date functions including the calculation of due dates and days past due using EOMONTH, EDATE and DAYS

· Generating random numbers and random dates with RAND and RANDBETWEEN, and introducing the new RANDARRAY function

· The new IFS functions (new to Office365) – AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS and SUMIFS

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

· The most useful logical functions and IS functions – AND, OR, NOT, ISBLANK, ISTEXT, ISNUMBER and ISERROR

· How to create a drop-down list

· The new XLOOKUP function and how it compares with the popular VLOOKUP function

· Pivot tables – how to create one and how to use one to analyse data

There is so much in Microsoft Excel that I can’t cover it all in one course – that might need 100 courses. Instead, in this course – Adventures in Excel – I start with some simple calculations and move onto some of the features and functions that I use most often. There’s no visual basic or macros in here just powerful but simple to use functions. These functions are easy to use, and, unless your role is extremely specialised, they are probably the ones you’ll use 90% of the time.

I hope you find the course helpful.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: L1 Basic Functions

Lecture 3: L2 Date Functions

Lecture 4: L3 Random Numbers

Lecture 5: L4 IFS so many IFS

Lecture 6: L5 Text Functions

Lecture 7: L6 Logical Functions

Lecture 8: L7 Creating a Drop-Down List

Lecture 9: L8 VLOOKUP and XLOOKUP

Lecture 10: L9 Pivot Tables

Instructors

Ross Maynard
Process Improvement Specialist

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 0 votes
5 stars: 0 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu