Hello and Welcome to the ABSOLUTE BEGINNERS Guide to Excel 2016!
For the duration of this course I will instruct you in learning Excel with step-by-step bite sized lectures that will slowly improve your understanding of this powerful program. The focus of this course is tailored to the user whom has had little or no experience within the excel spreadsheet environment.
The version of Excel used in this training course is 2016 for the Windows 7 operating system. Other operating systems such as Windows 8 and Windows 10 are also applicable for this course should you be using those instead. You will be following along with me during this course so you will need a copy of Excel or at the very least a trial version to follow along.The course structure is designed to be followed quite easily and all materials being presented are also available in their completed form at the end of each section for your later reference. No prior experience in Excel from any version is required to start this course as the novice level is the intended audience, so start today!
In this lecture you will discover what the function of the ribbon bar is along the top of Excel.
in this lecture you're going to learn about the quick access toolbar and how easy it is to use.
In this lecture you learn about the many different shapes and styles of the cursor.
In this lecture you will learn about how to use the help menu and the context menus.
In this lecture you can learn about the status bar and what its function is.
In this lecture you can learn the difference between a workbook and a worksheet.
In this lecture you can learn how to change the style of a border, fill and color.
In this lecture you're going to learn what the formula bar is.
In this lecture you can learn about how to enter data into a cell.
In this lecture you learn about the redo and the undo function of Excel.
In this lecture you learn about charts, their usefulness and their variety.
In this lecture you can learn about cell formatting.
In this lecture you're going to learn about what formulas are and how they are used to calculate and sort data.
In this lecture you can learn how to copy formulas that you've already created and move them to different cells.
In this lecture you're going to learn how to change the format of the data that's in your cells.
In this lecture you can learn about conditional formatting.
In this lecture you going to learn how to place images or take desktop images and place them inside of your Excel worksheet.
In this lecture you're going to learn the difference between the static and a non static reference self.
In this lecture you going to learn what a pivot table is and how it can be used.
In this lecture you're going to learn about our fill and how it can be used to save you an enormous amount of time when creating worksheets.
In this lecture you going to learn how to insert columns and rows within your worksheet.
In this lecture you going to learn how to use the sort function with your data.
In this lecture you going to learn how to use a slicer table and discover its usefulness with varying types of data.
In this lecture you going to learn how to use find and replace within the context of your worksheet or workbook.
In this lecture you going to learn how to add comments to your worksheet.
In this lecture you want to learn how to password protect your worksheets and your workbooks, rows and columns.
In this lecture you going to learn how to print your pages.
In this workbook you're going to learn different things save and save as in regards to your worksheet and workbooks.
My name is Scott Beowulf Kaine and my steadfast commitment to learning has earned me not only a Bachelors Degree in Computer Science, but also two Masters' Degrees in both Psychology and Marketing. I have combined these skills in the corporate arena into building a path to success that has been highly rewarding and very lucrative. The methods that I am able to share here, I feel, are the blueprints of self sufficiency and financial security.
As a Corporate marketing business consultant, I have over 10 years experience in training sales leaders in making their mark in their respected industry; furthering not only their personal careers but enhancing personal growth in the process. My forte is not only limited to the area of traditional marketing however; I have been a part of many online and training programs along with graphic design and film production companies across the nation.
My exposure to training of both students and professionals alike, spans across the United States from California to Nevada to New York to Oklahoma. I’ve worked with talents in London to New Zealand and have trained sales leaders and scholars who are trailblazers in their firms to this very day. Allow me to help you in developing your visionary talents and dreams into an exceptional skill for your future!
I look forward to teaching you everything I have learned, and with time, hope to pass onto you all the skills and inspiration you need to become a successful and independent entrepreneur or simply just more informed then you were yesterday! The path to financial or personal success starts with a single step, as with anything, we all start somewhere and I would be honored if you started with me!