Microsoft Excel: Most Useful Excel Functions

Focused View

Zahed besharati

1:23:27

547 View

1. Introduction

1. Introduction.mp4

02:25

2. worksheet.mp4

01:22

2. SUM

1. SUM function.mp4

03:19

3. MAX

1. MAX function.mp4

03:32

4. MIN

1. MIN function.mp4

03:43

5. Multiply and an easy way to copy the formula

1. Multiply and Small green square.mp4

06:48

6. COUNT

1. COUNT function.mp4

06:22

7. COUNTA

1. COUNTA FUNCTION.mp4

05:30

8. AVERAGE

1. AVERAGE FUNCTION.mp4

05:55

9. IF FUNCTION

1. IF FUNCTION.mp4

09:24

10. VLOOKUP

1. VLOOKUP FUNCTION.mp4

08:00

11. DROP DOWN LIST

1. DROP DOWN LIST FUNCTION.mp4

11:51

12. CONCATENATE

1. CONCATENATE FUNCTION.mp4

04:57

13. FLASH FILL

1. Flash Fill Feature in Excel.mp4

10:19

14. My Excel Worksheet File

1.1 New Microsoft Excel Worksheet.xlsx

1. WORKSHEET.html

Description

How to use FLASH FILL, SUM, AVERAGE, MAX, IF, MIN, DROP DOWN LIST, COUNT, VLOOK UP, COUNTA and CONCATENATE in Excel

What You'll Learn?

Learn Excel functions from zero.
Identify formulas and functions and know the difference between the two.
Reduce complexity of your spreadsheets.
Use the 11 most important Excel functions in common spreadsheet computations.
Use the SUM, AVERAGE, MAX, IF, MIN and DROP DOWN LIST functions in Excel.
Use the FLASH FILL function in Excel.
Use the COUNT, VLOOK UP, COUNTA and CONCATENATE functions in Excel.

Who is this for?

You currently use Microsoft Excel and want to improve your skills.

Suitable for any level of Excel user from beginning to advanced.

What You Need to Know?

Microsoft Office Software Installed.

More details

Description
Excel functions empower you to do more and save time for yourself. It doesn't matter if you are a manager or a fresher if you know the excel formulas and function you can increase your productivity exponentially.Â If you don't, you may not Finish your work on time. So yeah, Excel functions are great tools and they deserve to be learned.
In spite of the usefulness and easiness, not everyone is good with excel functions. Actually most people don't put effort. But believe me, it worths the effort.
If you are good with these functions, you can be exceptional among your colleagues. You will be able to solve problems in minutes that will take others hours.
The Excel functions work fantastically and increase your speed of working exponentially. You can learn about 11 important excel functions here.
My main goal in this training is to increase your awareness of the top tools and functions in Excel to help you solve complex problems.
Why You Should Learn these Excel Functions:
1: Simple Calculations
2: Get the work done faster
3: Automate the repetitive task
4: Design Impressive Dashboards
5: Allows you to Visualise Data
6: Be Exceptional at Workplace
7: Work Faster With Excel Shortcuts
Who this course is for:
You currently use Microsoft Excel and want to improve your skills.
Suitable for any level of Excel user from beginning to advanced.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel Formulas and Functions

Zahed besharati

Instructor's Courses

I am MSc Mechanical Engineer and currently work at Ministry of Education. I do research in Mechanical Engineering.My most recent publication is 'Title: Optimal design and operation of district heating and cooling networks with CCHP systems in a residential complex'.Skills and Expertise:Vibration Analysis - Condition Monitoring - Energy Simulation (ENERGY PLUS & eQUEST) - Energy Optimization (GAMS & MATLAB) - Designing (AUTO CAD & CATIA & CITY ENGINE & SKETCH UP) - Computation (MAPLE & EES) - Preventive Maintenance

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.