Excel, create by Doing!
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!
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!
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.
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.
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.
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.
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:
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:
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:
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.
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:
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
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.
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:
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!
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.