Welcome to Getting Started with Excel 2013 - a free series of Excel video tutorials for beginners. If you're new to Excel, I recommend watching watching this course. If you have already used Excel but want a comprehensive knowledge of the basics, then you're in the right place.
This is based on the original getting started with Excel course that I have been teaching in person in the UK banking industry since 2007. Now fully updated for Excel 2013, this course has been used by students all around the globe. But the best part is that all the accompanying workbooks are free!
So if you're looking how to get started with Excel quickly and easily, you're in the right place. Just because it's free doesn't mean that you get a cut-down down version of another course. Yes, we do have an advanced Excel course, but this Getting Started course teaches you all the essential Excel functionality so you can get your first spreadsheet built in record time.
Learning Excel is a bit like building a brick wall. Many beginners have a basic foundation - they understand the essentials of spreadsheets. Then they start piling on a few bricks here and there. But as their wall of knowledge is constructed, it's full of holes. Eventually they hit a point where their wall can't sustain any more weight and it collapses. What a waste of time!
This course takes a step-by-step approach to working with Excel. Each lesson builds upon the previous one, so your wall is solid. So whether you're looking to do your job better, or if you're looking to improve your resume, you are in the right place.
A comprehensive workbook with examples is included to save you time. You can also ask me any questions via the course discussion board.
This lesson covers the course content and a little more information about the author.
The key topics covered in the course are:
This lesson covers the key differences between older versions of Excel and Excel 2013, what has changed and how it has evolved over time.
This lesson covers some key basic terminology that you must understand before progressing with the course. Definititions are included for:
This lesson covers how to use cells correctly. Topics include:
This lesson covers how to use and edit rows and columns. Topics include:
This lesson covers how to use and edit sheets. Topics include:
This lesson covers how to sort and filter data. Topics include:
This lesson covers how to use and navigate the ribbon menus in Excel 2013. Topics include:
This lesson covers how to create basic good looking charts. Topics include:
This lesson covers how to use basic formulas. Topics include:
This lesson covers how to save your work in Excel. Topics include:
This lesson covers how to print your work effectively in Excel. Topics include:
This lesson covers some basic best practice principles. Topics include:
This is a fantastic resource you can use to speed up your use of excel. It is packed with all of the keyboard shortcuts you can use in Excel 2013.
I'm an Excel developer and trainer with over 10 years using Excel for data analytics and business process improvement in the UK. I also run a consultancy business specialising in custom Excel apps and data analytics. Over the years, I've been asked to run so many training sessions on Excel that I finally decided to put my content online. My focus is on helping people get the most out of Excel with the minimum effort, pain, and the least boredom.
Let's face it, using Excel isn't always the highlight of everyone's day. For many it's a constant pain because they have to go to ask the office guru every time they need to do a VLookup, or a Pivot Table. Perhaps they don't even know what a Pivot Table is! My courses are all about helping you to get the most out of Excel, so that you can be faster and more effective with your spreadsheets, without boring you with technical manuals or long form lessons.
Having worked in a wide range of global financial institutions and consultancies during my career, I am constantly amazed at how much productivity large organisations miss out on by not having their staff fluent in Excel. There is so much opportunity to improve efficiency,automate tasks, get better data insights, reduce errors, and create happier staff, simply by improving the level of competence in Excel across organisations. I have seen countless Excel classes that focus just on what the various buttons in Excel do and how to use them. I never felt this was enough. Excel users need to know WHEN and WHY they should use these tools, not just HOW. There's also huge scope for to coach Excel users away from common pitfalls and bad practice. I created these courses to provide more comprehensive, 360° training for Excel users of all levels from beginners to seasoned experts.