10 MUST Know Microsoft Excel Functions for Business

Focused View

Donna Hanson

33:31

123 View

1. Introduction

1. Quick overview of the program from your instructor Donna Hanson.mp4

02:06

2.1 10 Excel Functions Manual.pdf

2. Download the workbook.html

3.1 10 Functions Working File.xlsx

3. Download the exercise spreadsheet.html

2. Basic Functions

1. 1 - SUM Function.mp4

02:13

2. 2 - AVERAGE Function.mp4

01:42

3. 3 - COUNT Function.mp4

01:35

3. Remedial Functions

1. 4 - PROPER Function.mp4

01:52

2. 5 - TRIM Function.mp4

02:11

3. 6 - CONCATENATE Function.mp4

02:37

4. Common More Advanced Functions

1. 7 - IF Function.mp4

03:48

2. 8 - SUMIF Function.mp4

02:44

3. 9 - VLOOKUP Function.mp4

04:22

4. 10 - IFERROR Nested in a VLOOKUP Function.mp4

03:07

5. Additional Content

1. Simple XLOOKUP Function.mp4

03:41

6. Check in on your progress

1. Checking in on what you have learnt.html

7. Additional Information

1. Whats Next.mp4

01:33

Description

Learn 10 Functions to Needed in Business Today

What You'll Learn?

Learners will be able to recognize 10 common Excel Functions used in business
Learners will understand what functions are and how they work in spreadsheets
Learners will be able to identify what each function does and how to apply it in their own spreadsheets
Learners will understand the format of Excel's common functions

Who is this for?

This program is designed for users of Excel who want insight on functions and want to understand how they can be utilized in a business context

More details

Description
As a professional Microsoft Office software trainer for over twenty five years, I am regularly asked what are the most used Microsoft Excel functions in business today.

Rather than have to attend a range of courses that take up time you just donâ€™t have and learn functions that you may never use, Iâ€™ve put together this short course to share 10 MUST Know Microsoft Excel functions for business.
This short course will help you understand 10 of the most commonly used functions in Excel to help make your day to day Excel use easier.
This course :
Â· Explains in simple terms each of the functions
Â· Shares what each function does.
Â· Shows you how to easily create each function step by step with videos and a downloadable workbook.
Â· Covers basic troubleshooting tips to help make ensure your functions are right.
Â· Shares simple and advanced functions in a way that is easy to understand.
Â· Provides a downloadable spreadsheet to enable you to try out the functions as you go through the program.
Topics covered include:
Â· Basic functions for simple mathematical outcomes
Â· Remedial functions for tidying up data to be analyzed
Â· Common advanced logical and look up functions
Â· An introduction to nested functions
Â· A bonus introduction to Microsoft 365â€™s latest lookup function.

Rather than waste time attending face to face courses that donâ€™t allow you to learn on your own time, this short course enables you to learn functions that will immediately help make your day to day Excel use easier.

NOTE: It doesn't matter what version of Microsoft Excel you are using, however earlier versions of Excel will not have access to the bonus function which only became available in Microsoft 365.

Who this course is for:
This program is designed for users of Excel who want insight on functions and want to understand how they can be utilized in a business context

User Reviews

Rating

average 0

Total votes0

Focused display

Excel Formulas and Functions

Donna Hanson

Instructor's Courses

About DonnaWant to reduce your stress and frustration with everyday Microsoft Office programs and also increase your productivity?Want to learn practical tools and features of Microsoft Office programs that relate back to what you do in your day to day work? Then I'd love to help.For over 20 years, I've has been working as a speaker, trainer and educator to businesses large and small. I believes the very technology that was supposed to make life easier has in fact created more work.I am passionate about productivity and believe that we need to get stuff done, faster and smarter so we can get back to enjoying our lives with those we love.My style is practical, engaging and fun, because I think when things are fun we learn more! I have a degree in Training & Development, and years of real world business experience which means no jargon sessions that focus on what you need to know to get more done in less time with less stressJoin me here and let me help you:- Learn what you need to do to make analyzing data in Microsoft Excel EASY.- Create documentation In Microsoft Word that is practical and professional EVERY SINGLE TIME.- Learn how to make your next presentation with Microsoft PowerPoint engaging and effectively get your message across to your audience.- Learn SECRET tips to help you IMMEDIATELY increase your productivity AND reduce your stress with Microsoft Word & ExcelHer motto is "You don't know what you don't know."

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.