Microsoft Excel Beginners to Intermediate (Complete Course)

Focused View

BIO BEN

7:30:19

99 View

1. Things to know before we start

1.1 11.05.20 stock movement.csv

1.2 12.05.20 stock movement.csv

1.3 13.05.20 stock movement.csv

1.4 14.05.20 stock movement.csv

1. 101 Introduction.mp4

09:24

2. The Very Basic Knowledge

1. Be data sensitive.mp4

06:20

2. ButtonsStatus Layout.mp4

15:25

3. Keyboard or Mouse.mp4

04:07

4. NavigationSelectionShortcut.mp4

13:48

5. CopyPasteFill.mp4

26:20

3. Case Introduction

1. Company Background.mp4

03:11

2. Current Issues.mp4

03:29

3. Boards Requests.mp4

01:38

4. Break Down.mp4

03:48

5. Planning.mp4

03:28

4. Input (bring the data into Excel)

1. FileData Type Accepted.mp4

04:01

2. Import Data without A Linkage.mp4

07:58

3. Import Data with A Linkage.mp4

20:33

5. Processing (cut off clutters)

1. Clean - Make The Bad Good.mp4

27:54

2. Organise - Better with A Container.mp4

59:14

3. Summary - Pivit Table.mp4

40:37

4. Beautification.mp4

01:13:05

6. Output (Find Ways to Share Your Work)

1. Protect Your Work.mp4

05:51

2. Paper.mp4

15:51

3. Or Paperless.mp4

08:38

7. Streamline

1. Workflow Review.mp4

08:17

2. Alternative Way.mp4

05:56

3. Trial And Error.mp4

46:31

4. From a Users Perspectives.mp4

09:25

8. Whats Next

1. The Pyramid.mp4

08:43

2. Think Differently.mp4

06:56

3. Database.mp4

09:51

Description

Same Excel, Different Way to Learn

What You'll Learn?

Build up a solid foundation with basic Excel skills
Learn multiple ways to handle large sets of data
Learn Power Query for data importing and normalisation
Master logical and efficient method to smooth your workflow
Learn formula, table, conditional formatting, data validation and more
Equip yourself with Excel advance skills for analysis and reporting
Learn table, pivot table, sharing and more

Who is this for?

Beginner to heavy Excel user

Excel user who wants to learn more Excel from different perspectives

More details

Description
This course takes a solo case study approach to bring you into this fantastic Excel world. Combining one case study with different Excel features and skills, this course will help you enhance those techniques/methods when you interact with a real-world example.
You will be walked through a complete process of problem-solving in Excel, which consists of the following:
1. Stage One - How to bring your data into Excel
2. Stage Two - How to process your data in Excel
3. Stage Three - How to share your work with others
Different features/methods will be introduced in various degrees per underlying issues at different stages.
There are many features and methods, including but not limited to the following:
1. POWER QUERY
2. CONDITIONAL FORMATTING
3. DATA FORMATTING
4. TABLE
5. FORMULAS
6. REFERENCE
7. DATA TRANSFORMATION
8. PIVOT TABLE
9. PAGE SETUP
10. DATA VALIDATION
11. ...
Whether a feature is basic or advanced is determined by how you use it. That's why we do not label any features as either basic or advanced. Even some so-called advanced features can be learned in just 30 secs!
After this course, you should be able to:
1. See the big picture from a process design perspective before you execute your plan in Excel
2. Smooth your workflow for projects in the long run
3. Make the report neat and understandable for your audiences
By following the below formula, you are halfway to becoming a successful Exceller:
EXCEL=LEFT("EXperiment",2)&LEFT("Concrete",1)&LEFT("Elastic",1)&LEFT("Leverage",1)
Let's dive in and start your Excel journey today!
Who this course is for:
Beginner to heavy Excel user
Excel user who wants to learn more Excel from different perspectives

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

BIO BEN

Instructor's Courses

Hi Everyone,It's Ben here.I am a Certified Microsoft Office Excel/Access database expert.By being exposed to real company issues with affordable and hands-on solutions, I am an expert in process trimming and Excel training for different-level users.I am also a Microsoft Access Developer in Purchase Order Systems, Stock Management Systems, Invoicing Systems, and Stock Reconciliation and Audit.Let's start your Excel and Access journey by joining the course!

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.