Excellence in Excel! Create an invoicing tool in Excel!
4.3 (6 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.
28 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excellence in Excel! Create an invoicing tool in Excel! to your Wishlist.

Add to Wishlist

Excellence in Excel! Create an invoicing tool in Excel!

Excel invoicing tool for automatically creating invoices. Save time and money on invoices by creating one in Excel!
4.3 (6 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.
28 students enrolled
Created by Nicky Wong
Last updated 3/2015
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 1 hour on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create an invoicing tool that works dynamically!
  • Make a list of products that you can select from and all aspects will change along with it.
  • Automatically calculate the total order in seconds!
  • Understand how you create product lists with dropdown buttons!
  • Use the VLOOKUP formula tool in creative ways.
  • Use the powerful INDEX & MATCH formula to automatically display essential information.
  • Use the transpose option for quickly storing data.
View Curriculum
  • Have an openmind and the willingness to take action (Massive Action)!
  • Have a working Microsoft Excel 2007, 2010 or 2013!

Excel, create by Doing!

  1. Are you looking for a useful Excel course where you truly learn something practical and create a valuable tool?
  2. Are you also wasting a lot of time to create a invoice for you customer?
  3. Do you feel your invoice could be way quicker because you always fill up the basic information?
  4. Would you be interested in creating a wonderful time and money saving invoicing tool in Excel and create invoices in seconds!

If so, this course is for you!

This course will teach you how to use Excel functions and create a useful Invoicing tool. Many people learn Excel functions and all the possible options that you can do with Excel. The real thing is that you will probably not use 80% of the power of Excel.

Excel is powerful but if you do not understand how to use it, your knowledge remains powerless. This course will show you how to use just a few functions and create in the meanwhile a very useful tool. This learning method is named CREATE BY DOING!

If you feel intimidated by Excel do not worry! The real issue is not Excel or You but by the method of learning it! Yes, the way you learn something can be successful or unsuccessful. This course uses the SPEED LEARNING methods of the learning cone. What is that? This is a method development make sure you truly remember 90% of everything you learn. How? Just by doing and following the exercises.

This course is active, and you have to do the exercises and follow along.

Why should I take this course? Your competitor has a bigger course!

I understand you point, but do you know the difference between have a toolbox and understanding to use just only 2 tools. I can teach you every tool you want that you can add all the tools in your toolbox. But would you be able to see the practical value out of it? I do not think so.

What if I give you just 2 tools, a screwdriver and a saw and teach you how to create a great piece of furniture? That would be 100% more valuable and that is what I do! I teach you to make useful tools that you can use for your personal life. By doing you create your furniture! That has a lifelong value!

There is a real difference between knowledge and power. Knowledge is only potential power, without the practical use of it, it becomes powerless. Power is the knowledge that you apply in your daily life! This course is powerful because you use the tools and put it into great use.

I never succeeded in Excel, is this course suitable for me?

Success is a path you walk. Learning Excel is exactly the same. Did you fail before; perhaps you took the wrong path. You learned from a bad teacher or a boring book. If you took the wrong path all you need is readjust your path and start walking again. This course truly is a very easy and slow paced course with much repetitions and exercises. The way to learn is by doing and by great explanations. This course has it both many times over!

Go and try this out for a month!

To make it even better, you can test it out for a month. This basically means that if this course is not right for you, you can get your money back in a blink of an eye. There is truly no reason not to do it and it has no risk at all.

Start taking actions right now and take this course. In life you have winners and losers. The winners take action at once and the losers keep on looking and waiting for the right time. In life there is never a right time except NOW! I truly belief you are winner because you are looking and reading this course.

Alright winner, it is time to take action! Click on “Take this course" and start making great pieces of Excel Furniture!

Who is the target audience?
  • Business Owners that need to have a invoicing tool that is quick and automatical in Excel.
  • SMB owners that want to save time and money by having a powerful Excel tool that is fully in their control.
  • Businessman that needs Excel to improve their productivity or automation.
  • Professionals who need to use Excel in their daily business life.
  • Students who want to improve their Excel skills and expand their capabilities with Excel.
  • Every student that has a real Passion for Excel and its capabilities.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
13 Lectures
Start Here
2 Lectures 01:48

Excel Introduction

Welcome students, Im excited to have you here. In this course you will get a brief overview of what you will learn in this course. Many people have seen basic Invoicing tools in Excel or would like to make one, but are they really functional?

Most likely you have to retype everything over and over. Well, now not anymore! Well, if you know how to create a formula that will do all basic work, so you just focus on the essentials and you will reduce your time alot.

The main goal is learning how to make a dynamic invoicing tool in Excel!

Preview 01:48

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. 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 files with Raw Data
2 pages
Basic tabs, the essential to make it dynamic.
2 Lectures 16:38

Excel Tab 1 & 2

In this part you will start to use the Raw Data and implement that into two different tabs. First of all you wil make a basic product tab and secondly a customer/client tab with all the core information. This is the basic part, but it will be essential for you to understand it.

Preview 06:34

Excel Tab 3: Invoice History

In this lecture you will create the Invoice History tab. This tab will be crucial so you can instantly track every invoice you send out! This is your tracking system and very useful. You will understand that every part of this will be found in the invoice itself.

Preview 10:04
Invoice header section
2 Lectures 14:13

Excel Invoice Header

In this lecture you will start to create the header of the invoice tab. You will first create the basic layout and add the right design and colors and place a logo/picture in your invoice template.

Creating the invoice header, the layout

Excel Invoice Header

In this lecture you will connect the formula`s that are essential for the upper part of the Invoice. You will make the list dynamic and connect all essential informaton of the client.

You will learn how to make:

  • A dropdown list with all clients
  • Display the address of the clients autmatically with VLOOKUP formula
Creating the invoice header, formula`s
Invoice body section
5 Lectures 31:08

Excel Invoice Tab

In this lecture you will create the Invoice tab body section. This is the second part of the invoice and you will first create the layout. You will create the table with the prices and display the core information. You will make:

  • The body design
  • The color design
Creating the invoice body, the layout

Excel Invoice Body

In this lecture you will learn how to create the formula`s that are essential for the body. The goal is to make the calculation automatic. Once you select the product all else should roll out without any effort. You will make:

  • Product Dropdown List
  • VLOOKUP function
  • IFERROR function
Creating the invoice body, the formula`s

Excel Invoice Body

In this lecture you will use the INDEX & MATCH formula. This function is similar to VLOOKUP expect that it can do something that VLOOKUP is not able to do. It can search and select values that are located at the beginning of the column.

Creating the invoice body, using the INDEX & MATCH function.

Excel Exercise Test 1

In this lecture you will receive a challenge. Are you ready to take on this challenge? You learned a lot and not it is time to start practice what you have learned. In this exercise you have to do 3 things:

  1. Create the special dropdown list
  2. Use the VLOOKUP formula
  3. Use the INDEX & MATCH formula!

Good luck with this exercise and if you have trouble, you can discover how to do it in the next lecture.

Excel Exercise Test 1

Excel Exercise Test 1

In this lecture you will get the answer. How did the exercise went? Did you had a hard time or was it easy? In this part you can double check how replicate the Excel sheet. Follow along and check if you did everything properly.

Excel Exercise Test 1 Answers
Thank you
2 Lectures 03:43

Excel Summary

In this lecture we will recap everything what have been covered. You have learned many different aspects and created a dynamically changing invoice tool that will save you much time and money. You learned to create:

  1. Product DROPDOWN lists
  2. Customer DROPDOWN lists
  3. COUNTA Function
  4. VLOOKUP Function
  5. INDEX & MATCH Function
  6. Understand every tab that you created and how they are interconnected.
What you have learned

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
About the Instructor
Nicky Wong
4.1 Average rating
461 Reviews
33,319 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.