Excellence in Excel! Create a Stock Control tool in Excel!

Name: Excellence in Excel! Create a Stock Control tool in Excel!
Rating: 4.3 (58 reviews)

Learn how to use Excel by creating a valuable stock control tool in Excel.

Created byNicky Wong

Last updated 1/2022

English

What you'll learn

Grasp on how Excel truly works!
Create time-saving tools in Excel
Create a stock control tool to manage your stock automatically in Excel.
Have a system to easily track your stock unit in Excel.
Understand and apply how the VLOOKUP function works.
Manage stock instantly with Excel.

Course content

6 sections • 21 lectures • 1h 29m total length

What will you learn in this course?1:37
Excel Introduction

Welcome to this course! Im excited to have you here! Excel is a wonderful tool to create powerful programs. Sadly, many people cannot grasp the true power of Excel. In this course you will learn the formula`s and functions to create practical Excel sheets and tools.

The real power of Excel is creating a worthwhile tool by doing! I do not want to you learn a basic Excel function and let you go. I want you to understand the practical use of Excel by using just a few tools to create something that has a value of a lifetime.
Download the Excel file with the Raw Data.2:00
Excel Introduction

In this part you can download the raw data. You will not receive the full data. Why? Because I truly want you to learn it by doing. This course is titled: Create by Doing! It is a challenge and the big question is, can you do it?

Download the Excel sheet so you have the Raw Data at hand that you need for the upcoming lectures.

Making Tab 1, the Data & formula`s6:05
Excel Tab 1

In this part you will learn how to add the raw data for the First tab. You will get started with the first Tab and start placing the Raw Data in the tab. This is the first step of the stock control system. This system will be completely systemized once you follow the course and do as demonstrated.
Making Tab 1, the Style & Design3:36
Excel Tab 1

In this part you will learn how to create the proper design for an Excel sheet. Many people consider design as the least important task in Excel. Design is very important, and is a professional way of communicating with the user of the sheet. You will understand that some colors will tell the user something. You should use this method of communication. It is very similar to the way traffic lights communicate the color Red and Green. They have a specific meaning.
Exercise Test 11:27
Excel Exercise 1

In this part you will have a mini exercise. This challenge is designed so you will learn and repeat what you recently saw. Practice by creating this mini exercise. Now there is a challenge for you. How well did you understood the lessons of Section 1? This is your challenge, create an equal box as on shown in this video.
Exercise Test 1 Demonstration4:17
Excel Exercise 1

In this part you will get the answers of the mini exercise. You can double check if you did it properly. You will see here exactly how you had to do test 1 in Excel. Follow along and double check.

Making Tab 2, the Data14:44
Excel Tab 2
In this part you will learn how to create and connect data with the Second Tab. You will get started with the first Tab and start placing the Raw Data in the tab. This is the first step of the stock control system. This system will be completely systemized once you follow the course and do as demonstrated.
Making Tab 2, the layout1:11
Excel Tab 2
Exercise Test 20:34
Excel Exercise 2
In this part you will have a mini exercise. This challenge is designed so you will learn and repeat what you recently saw. Practice by creating this mini exercise. Now there is a challenge for you. How well did you understood the lessons of Section 2? This is your challenge, create an equal box as on shown in this video.
Exercise Test 2 Demonstration4:41
Excel Exercise 2

In this part you will get the answers of the mini exercise. You can double check if you did it properly. You will see here exactly how you had to do test 2 in Excel. Follow along and double check.

Making Tab 3, the Data14:20
Excel Tab 3
In this part you will learn how to create a more intelligent excel sheet. You will learn how to use the IF statement let Excel communicate to you based on specific criteria (key metrics). This system will be completely systemized once you follow the course and do as demonstrated.
Making Tab 3, the styles1:24
Excel Tab 3

In this part you will learn how to create a more intelligent excel sheet. Now you will design the layout and give it a professional look. This system will be completely systemized once you follow the course and do as demonstrated.
Exercise Test 30:44
Excel Exercise 3

In this part you will have a mini exercise. This challenge is designed so you will learn and repeat what you recently saw. Practice by creating this mini exercise. Now there is a challenge for you. How well did you understood the lessons of Section 3? This is your challenge, create an equal box as on shown in this video.
Exercise Test 3 Demonstration4:27
Excel Exercise 3

In this part you will get the answers of the mini exercise. You can double check if you did it properly. You will see here exactly how you had to do test 3 in Excel. Follow along and double check.

Making Tab 4, the formula & layout6:27
Excel Tab 4

In this part you will start to connect the items that are short on stock. You will make an orderform that automatically creates a form that you can use to send to a supplier. The main goal is to see how great Excel can be connected with every piece of information.
Exercise Test 41:03
Excel Exercise 4

In this part you will have a mini exercise. This challenge is designed so you will learn and repeat what you recently saw. Practice by creating this mini exercise. Now there is a challenge for you. How well did you understood the lessons of Section 4? This is your challenge, create an equal box as on shown in this video.
Exercise Test 4 Demonstration5:01
Excel Exercise 4

In this part you will get the answers of the mini exercise. You can double check if you did it properly. You will see here exactly how you had to do test 4 in Excel. Follow along and double check.
Excel Core Principles you must remember.

Final Points3:45
Excel Final

Congratulations of completing this course. Remember that you always should continue learning and improve it. That is why I would like to hear from you! Do you want to create something new? Did you like this learning method? Just let me know!

You have learned alot of quality information and understand how to use some functions to create a practical tool. You might wonder what can I do next? This is what you can do from now on:

Go and rate my course!

Go ahead and tell me what you want to learn more about Excel in the discussion board!

How can you use this knowledge in your daily life?
Excel Reference Sheet by Udemology4:00
Excel Reference sheet

You learned a lot and I truly believe you want to make sure you remember all the information as well. So here you have a reference sheet. I placed the best functions on this sheet with a very brief explainaton. Are you on a mobile phone? Do not worry! I have also a mobile format ready for you!
Bonus video: Special video on request11:27
Excel Bonus

In this part you will learn how to make your order form more relevant. The order form will be automaticly updated and only display the items that you want to order instead of the entire product list. This video is a bonus video after a request from a student.
Bonus Lecture: What to learn next!0:39
Learn more about Excel

You can never be an overachiever! Get the next course for a great price!

Requirements

Have Excel installed on your computer
Have an open mind and willingness to take action
Have a working Excel 2007, 2010 or 2013

Description

Excel, discover its real power!

Have you ever understood the real power and purpose of Excel?
Do you understand how to create real time saving Excel tools?
Do you truly find it difficult because there is too many formula`s to understand Excel?
Do you wonder how on earth an accountant can do so much work with so less time and you stuggle to get ahead in Excel?
Do you want to make real use of Excel and save time and money?

In this course you will start to understand how you can create useful tools that are all interconnected! Excel is not a spreadsheet. It is a time-saving tool if you really understand how it works.

In this course you will see what you can do and how you can do it! In this course you will not get the entire tool box. If you do not know how to use the basic tools you do not need to know all the tools. You only need to know the right tools for you!

In this course you learn, do and create. I truly belief this course is the best course for you because you will learn and practice by creating your tool. You will see instantly how Excel really works.

Excel is not a Spreadsheet! Excel is an answering machine. It should give you answers and validate information that you put in!

======================================================================

This course is an absolute time saver!

Now you can try this as well! This course is 30 days backed up by Udemy. You can try and discover it yourself and if you discover that this course is not the right course for you! You can get the money back in a blink of an eye!

=======================================================================

Time is the most valuable thing in life!

In this course you receive all tricks to win and own you time! So, this your time to take action. Get your time back and click on the button "Take this course"!

Life does not wait for the waiters. Go and take this course now!

Who this course is for:

Businessmen and professionals that need to create tools in Excel
Professionals that want to understand the power of Excel
Entrepreneur that needs to get their feet wet in Excel
Students who want to improve their Excel skills

Excellence in Excel! Create a Stock Control tool in Excel!

What you'll learn

Explore related topics

Course content

Welcome2 lectures • 4min

Create Tab 14 lectures • 15min

Create Tab 24 lectures • 21min

Create Tab 34 lectures • 21min

Create Tab 43 lectures • 13min

Thank you!4 lectures • 20min

Requirements

Description

Who this course is for: