Essential Excel With Tips Trick Shortcuts and Job Success

Focused View

Marcus Menti

3:01:54

115 View

1. Introduction.mp4

01:55

2. Brief about MS EXCEL.mp4

06:42

3. Logical Functions.mp4

17:37

4. File Tab.mp4

13:22

5. Extra Simple functions.mp4

13:31

6. Home Tab.mp4

20:12

7. Simple Mathematical Functions.mp4

11:00

8. Insert Tab.mp4

22:04

9. Errors in Excel.mp4

16:32

10. Page Layout, Formulas Data Tab.mp4

20:49

11. FV and PV.mp4

04:35

12. Most Useful Shortcut keys.mp4

12:37

13. Four Lookup Functions.mp4

20:58

Description

Master Advanced Excel Formulas. Solve Complex Problems. Learn Advanced Excel Skills to Save Time & Impress

What You'll Learn?

A deep understanding of the most useful and advanced functions of Excel
Excel Functions, Formulas
VLOOKUP, HLOOKUP
Apply charting techniques that the pros use and be the charting boss of your office

Who is this for?

People who want to learn Excel.

What You Need to Know?

Installed Excel on Windows

Understand English Language

More details

Description
Those who desire to develop their skills in Excel should enroll in this course. You'll pick up new techniques, hints, functions, and shortcuts that will boost your productivity and efficiency at work. This course was developed to show Excel users how to avoid typical spreadsheet pitfalls and unlock Excel's full potential. We are confident that taking this course will help you gain the abilities you need because all the knowledge that is covered in it and that you will learn is exactly what we wish we had known when we first started using the Excel tool in a professional setting.

We'll dive into a broad range of Excel formulas & functions, including:

Lookup/Reference functions
Statistical functions
Formula-based formatting
Date & Time functions
Logical operators
Dynamic Array formulas
Text functions
By the end of the course you'll be writing robust, elegant formulas from scratch, allowing you to:

Easily build dynamic tools & Excel dashboards to filter, display and analyze your data
Create your own formula-based Excel formatting rules
Join datasets from multiple sources with XLOOKUP, INDEX & MATCH functions
Manipulate dates, times, text, and arrays
Automate tedious and time-consuming tasks using cell formulas and functions in Excel
If you're looking for the course with all of the advanced Excel formulas and functions that you need to know to become an absolute Excel ninja, you've found it.
Who this course is for:
People who want to learn Excel.

User Reviews

Rating

average 0

Total votes0

Focused display

Introducing Marcus Menti, a passionate advocate for computer technology literacy and a new premium instructor on Udemy. With six years of experience teaching computer application packages and a passion for sharing knowledge, Marcus brings a wealth of expertise to the platform.As a former teacher assistant, Marcus understands the importance of clear communication and making complex concepts easy to understand. With a Bachelor's of Science from Utah State University and a Master's of Science from Edinboro University of Pennsylvania, he has a strong academic foundation for the Udemy challenge.Marcus discovered his passion for teaching and helping others while in college, where he volunteered to help fellow students and gave back to the community. This passion has led him to continue sharing knowledge and expertise throughout his career.Believing in the power of education to enrich lives, Marcus is committed to providing a supportive and engaging learning experience on Udemy. His courses cover a wide range of topics, from basic computer skills to advanced software and web development applications, and are designed to meet the needs of students and business professionals of all levels.Join Marcus on Udemy and take the first step towards mastering the world of computer technology. With His expertise and dedication, you'll be on your way to success in no time.

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.