Excellence in Excel! Create a Stock Control tool in Excel!
4.1 (29 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,873 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excellence in Excel! Create a Stock Control tool in Excel! to your Wishlist.

Add to Wishlist

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.1 (29 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,873 students enrolled
Created by Nicky Wong
Last updated 3/2015
English
Current price: $10 Original price: $25 Discount: 60% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 1 Article
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
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!

  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!
Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
21 Lectures
01:33:29
+
Welcome
2 Lectures 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.

Preview 01:37

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.

Download the Excel file with the Raw Data.
2 pages
+
Create Tab 1
4 Lectures 15:25

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.

Preview 06:05

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.

Preview 03:36

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

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.

Exercise Test 1 Demonstration
04:17
+
Create Tab 2
4 Lectures 21:10

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 Data
14:44

Excel Tab 2


Making Tab 2, the layout
01:11

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

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.

Exercise Test 2 Demonstration
04:41
+
Create Tab 3
4 Lectures 20:55

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 Data
14:20

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.

Making Tab 3, the styles
01:24

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

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.

Exercise Test 3 Demonstration
04:27
+
Create Tab 4
3 Lectures 12:31

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.

Making Tab 4, the formula & layout
06:27

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

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.

Exercise Test 4 Demonstration
05:01

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.

Excel Core Principles you must remember.
3 questions
+
Thank you!
4 Lectures 15:28

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?
Final Points
03:45

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!

Excel Reference Sheet by Udemology
4 pages

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 video: Special video on request
11:27

Learn more about Excel

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

Bonus Lecture: What to learn next!
00:16
About the Instructor
Nicky Wong
3.9 Average rating
429 Reviews
32,169 Students
22 Courses
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.