One of my first students, Rick, messaged me to say "I thought it was outstanding! It was extremely easy to follow and hit on some critical key points for a beginner."
The course will gently lead a total beginner through all the steps to create and format a basic spreadsheet.
It will demystify a lot of jargon, and also provide some killer tips that will save a lot of time, and wow your boss.
The course assumes no prior knowledge. Each lesson builds on the previous one. So it is designed for you to start at the beginnning and work your way through. However if you prefer, you can jump around and just do the lessons you want.
I create a spreadsheet during the course. You can download this at the beginning. Follow along with me on a blank spreadsheet and try and create something similar. You will learn much faster this way.
I try and keep the lessons fun and relaxed as that is my style. I hope that you like the course. Please let me know what you think.
I have used Excel extensively over the last 25 years in my career as an accountant in industry. I used to set up massive spreadsheets so that every month, I just to used to push a button and generate the monthly accounts with summary and detailed pages with graphs.
It saved me so much time, and work, and made life very easy. Also it eliminated any human error, so the accounts were always accurate, which avoided any embarrassing incidents.
I really love Excel, so decided to become a trainer, and help others learn to produce the same results in a fraction of the time.
PreviewHow to open workbooks and save them as different file types (1:42)
StartSave time with the quick access toolbar and other top row icons (1:32)
StartIntroduction to the ribbon - where you can access the brains of Excel (2:28)
StartThe name box and formula bar (1:23)
StartTabs, worksheets and zoom (2:01)
StartSaving as another name or filetype (1:59)
StartNavigation part 1 - using end then arrow (2:03)
StartNavigation part 2 - ctrl and left or right arrow plus timesaving navigation tip (2:09)
PreviewHow to freeze rows and columns (2:42)
PreviewHow to add and delete rows and columns, undo and redo (3:01)
StartHow to move rows and columns (3:12)