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!
You may also like
- Write Unity CG Shaders From Scratch (2D, 3D)
- Data Visualization for Beginners
- JavaScript Crash Course: Learn the Fundamentals and Beyond.
- System Design for Big Data Pipelines
- C# .NET Core 8 with MS SQL Complete Beginner to Master 2024
- Data Science: Credit Card Fraud Detection – Model Building
- NestJs – Build Modern APIs in NestJs with Unit Testing
- Mastering IntelliJ IDEA for Java Devs
- MS SQL Server – Basics To Advanced
- Build TPS Zombies Survival Game – Unity 3D Game Engine
- React Native with Redux (Redux Toolkit) and Axios 2022
- Salesforce Lightning Web Components: Zero to Hero
- Introduction to Python (crash course)
- Favicon Grabber Using JavaScript
- Electron JS Complete Guide With Projects
- React Fundamentals – The Complete Guide For Beginners
- Let's Learn Laravel – For Beginner to Expert (2023)
- MongoDB Tutorial for Beginners (2024)
- Build Mobile Apps Without Coding – The Complete Guide
- Salesforce Flows – Learn Salesforce Lightning Flows Fast