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

Learn how to use Excel by creating a valuable stock control tool in Excel.
4.3 (21 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
8,407 students enrolled
$19
$25
24% off
Take This Course
  • Lectures 21
  • Length 1.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2015 English

Course Description

Excel, discover its real power!

  1. Have you ever understood the real power and purpose of Excel?
  2. Do you understand how to create real time saving Excel tools?
  3. Do you truly find it difficult because there is too many formula`s to understand Excel?
  4. 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?
  5. 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!

What are the requirements?

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

What am I going to get from this course?

  • 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.

What is the target audience?

  • 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Welcome
01: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.

2 pages

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.

Section 2: Create Tab 1
06: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.

03: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.

01: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.

04: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.

Section 3: Create Tab 2
14: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.

01:11

Excel Tab 2


00: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.

04: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.

Section 4: Create Tab 3
14: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.
01: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.

00: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.

04: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.

Section 5: Create Tab 4
06: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.

01: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.

05: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.

3 questions

This Quiz is designed to make sure you really know the power of Excel. You receive a quiz with a few questions. These questions are ment to enforce your knowledge about Excel.

Section 6: Thank you!
03: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:

  1. Go and rate my course!
  2. Go ahead and tell me what you want to learn more about Excel in the discussion board!
  3. How can you use this knowledge in your daily life?
4 pages

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!

11: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.

Article

Learn more about Excel

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Nicky Wong, Data Analyst, Market Researcher, Data Visualizer!

Nicky Wong is an expert in translating data into market opportunities. Data is his passion, Excel, Databases and Big Data are truly wonderful topics. As an absolute data lover and he is always looking for ways to analyze it. It started with stock market facts and now quickly turned to everything that is unique and different.

However, all the information have one primairy goal and that is "How to use this information to gain a competitive advantage". As a Market Researcher with it roots in Marketing Nicky understands that knowledge is power. Whatever you do make sure you use data at your advantage.

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

My vision of Data and the future

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

Why Data visualization matters!

I truly belief that Big Data is giving us all a new obstacle to overcome! Information overload is a serious challenge and with Big Data it only multiplies the issue. If you are a data miner you will know that much data has no meaning if you cannot connect any meaningful dots.

Large chunks of data, reports and tables are not effective. It is impressive to get a huge database but it is demotivating for others to read data. The biggest data trend is increasing this issue! Big Data = Information Overload x 10.

From (Digital) Information Age to the (Digital) Understanding Age

A data analyst can analyze data but the most important skill is Data Visualization! These so called "data visualizers" will develop a new skill gathering meaningful information and present it in a very understandable and effective way.

The issue is not anymore the data but the way to give meaning and communicating meaning to others. The person who can do that will have a huge advantage in the so ever growing Big Data world.

Big Data is here! Data Visualizer is on it`s way! In all of my courses I use techniques to create understandable data and present it in an impactful manner.

Ready to start learning?
Take This Course