Microsoft Excel Essentials for the Real Time World

Focused View

Remy Lien

2:27:51

103 View

1 - Introduction

1 - Introduction.mp4

01:38

2 - Fundaments

2 - Excel Terminology Part 1.mp4

04:19

3 - Excel Terminology Part 2.mp4

03:35

4 - Data Navigation.mp4

03:48

5 - Data Selection.mp4

04:38

6 - Data Entry Editing.mp4

06:29

7 - Formula vs Functions.mp4

04:46

8 - Formula Application Part 1.mp4

04:22

9 - Formula Application Part 2.mp4

04:02

10 - Sum Auto Sum.mp4

03:09

11 - Average Min Max.mp4

03:47

12 - Absolute vs Relative.mp4

04:31

13 - Allignment.mp4

05:25

14 - Fonts Borders.mp4

05:25

15 - Format Painter.mp4

03:14

16 - Number Formats.mp4

03:14

17 - Styles Themes.mp4

02:47

18 - Rows Columns.mp4

05:11

19 - Find Select.mp4

03:01

20 - Data Filtering.mp4

03:31

21 - Data Sorting.mp4

03:37

22 - Conditional Formatting.mp4

04:04

23 - Basic Charts.mp4

05:28

24 - Editing Charts Part 1.mp4

02:38

25 - Editing Charts Part 2.mp4

02:37

26 - Move Resize Charts.mp4

04:09

27 - Count Functions.mp4

03:42

28 - Data Ranking.mp4

03:22

29 - Combining Texts.mp4

03:45

30 - Fixing Text Cases.mp4

02:13

31 - Extracting Texts.mp4

03:31

32 - Find Function.mp4

02:40

33 - Introduction to IF.mp4

05:32

34 - Nested IF.mp4

04:14

35 - COUNTIFS.mp4

04:19

36 - VLOOKUP.mp4

04:25

37 - VLOOKUP Approximate Match.mp4

03:30

38 - Naming Ranges.mp4

03:13

Description

Microsoft Excel Beginner to Professional. Includes New Formulas

What You'll Learn?

Excel Terminology
Data Navigation
Data Selection
Formula
Functions
VLOOKUP
Data Ranking
Fixing Text Cases

Who is this for?

Beginner who want to learn Excel

What You Need to Know?

No Experience Needed

More details

Description
Looking to learn Microsoft Excel and improve your data analysis skills but don't know where to start?
OR, you've been using Microsoft Excel for a while but don't feel 100% confident?
There is so much information out there. What do you need to succeed at work?
Iâ€™ve picked out the Excel Essential skills a Data Analyst needs and packaged them in a structured course.
In fact, I collected the most common Excel problems faced by my clients. I added in my 15+ years' experience in finance and project management. I included all the hidden tips and tricks I came to learn as an Excel MVP and put it ALL in THIS course. I also made sure it covers the absolute Excel beginners.
These practical, real-world examples help you understand the full potential of each feature. You'll learn how to use Excel for quick and painless data analysis.
There are many helpful and time-saving Excel formulas and features. We tend to forget what these are if we don't use them. This Microsoft Excel Essentials Course will give you the practice you need to be able to apply the best solution for the task at hand. This way you can do more in less time.
Who this course is for:
Beginner who want to learn Excel

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Remy Lien

Instructor's Courses

Remy Lien is an Expert of Microsoft Office Course and dedicated to helping you to learn Word, Powerpoint, Excel, Office 365. His courses are for those who want to shine at work, accelerate their careers and achieve more in less time.My courses include examples based on my experience as well as the consulting work I have done for international companies. Many of the Excel tips and tricks I share is based on the questions received from experienced professionals in my Excel training sessions.I places great value on keeping the courses not only informative but also engaging. For this reason, students will find enough challenges, exercises and downloadable files to practice so they can maximize the value gained from each course.My passion is learning, sharing and solving difficult data analysis problems.

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.