This video course was designed to give you a comprehensive yet simple step-by-step guide and exercise workbook for your business needs. It is filled with business spreadsheet tips and shortcuts to make your work life almost effortless!
Heres a breakdown of this 10 part video series in more detail:
Video #1 - Introduction
Before we go through the exercises and dig deeper into the video course, I will first give you an overview of what to expect. This will make it easier for you to absorb and apply the following information.
Video #2 - Excel 101
In this video, you will be given a layout of the exercise workbook intended to help you throughout the video course. You will also learn the basics of Excel so that you can understand the program if you’re a beginner, or to simply refresh your knowledge if you’re a current or previous user.
Video #3 - Customizing Worksheets
Sorting is one of the most widely used functions of Excel. In this video, you will learn techniques to quickly sort and organize your data.
Video #4 - Adding Fully Automated Customized Formatting – Part I
Automating customized formats on your spreadsheet can make life so much easier since you only have to do it once. Thus, I will teach you very specific shortcuts you can apply to help automate your reports and trackers.
Video #5 - Pricing and Niche Continuity Models
One of the biggest questions people ask me is, “How should I price my continuity program?” To answer this, I’m going to is show you different types of continuity models so that you can replicate and follow them.
Video #6 - Adding Fully Automated Customized Formatting – Part II
In this video, we will go more in depth on how to automate your reports and trackers. By the end, you’ll be able to automate all sorts of processes like a professional!
Video #7 - Extract the Information You Need – The Fast Route, Part I
There are more ways to automate your business by using features that can extract the specific information you need. This video will show you the best techniques to make the extraction of this information faster and easier.
Video #8 - Extract the Information You Need – The Fast Route, Part II
Here, we will dive deeper into more ways to extract and manipulate your data. I will show you a unique Excel feature to tweak your data and make it more relevant to your specific business needs.
Video #9 - Extract the Information You Need – The Fast Route, Part III
Finally, you are getting closer to automating your business with these helpful techniques and shortcuts. In this video, I will show you another useful Excel feature that will help you find the information you need faster than ever before.
Video #10 - 15 Quick Excel Functions You Wish You Had Always Known
The last video of this series will show you 15 useful quick functions of Excel that will save your hours of work using manual computations. I will give you clear and detailed explanations and demos of these incredibly useful hacks!