
Please complete a short survey to help be improve and create better courses: complete the quick survey now.
This lecture explains, in depth, how to use one of the most popular and powerful functions of Excel - Lookups.
Specifically, we go through vertical and horizontal lookups (vlookup & hlookup), including why,when and how to use them.
Ever wondered if you could use words and name instead of cell references? Wouldn't you rather point your looks to the volumes table rather than $A$1:$B$18? Well named ranges allow you do just that - in this lecture you learn how to create, modify and use named ranges, including in lookup formulas.
In this lecture I show you how to create, edit and delete comments in Excel. The lesson also discusses when comments should be used and when to avoid them.
Lastly I show you how to print comments.
In this lesson you will learn how to print excel spreadsheets. You will learn how to prepare documents so you can print what you want to. I will show you how to set up documents, go through different page views and learn how to add the same (column) header to each of your page.
Lastly I will show you how to save your documents in PDF so they can easily be sent via emails or otherwise distributed.
The Excel beginners training from scratch course will introduce you to the industry standard and popular spreadsheet software. This Excel training course is perfect for those wanting to learn Excel from the very beginning and you will become comfortable using some of the core features that Excel has to offer.
The course will introduce you to a number of features, tool and techniques of Excel and is perfect for students, entrepreneurs, housewives, business owners, professionals or anyone else looking to learn Excel. By the end of the course you will have mastered the basics of Excel and will be able to manage workbooks, use formatting, perform calculations, use formulas and create charts.
This is a hands-on beginners Excel course and you will learn by watching the instructor as he describes each action as he performs it. The course takes a project based approach, which means that you will be able to practice as you are learn and by the end of the course you will even complete a project from beginning to end – creating a fully functional budgeting spreadsheet with charts, formulas and a host of other features.
Note: The instructor uses Excel 2010 to teach the course, but the course should be suitable for those with Excel 2007 onwards. There are some differences in the menu structure if you are using Excel 2013.
Instructor: Abhijat Saraswat (Ab)
The course is taught by Ab, who is an Excel whizz and has been using Excel for over 10 years, since Excel 95. He uses Excel almost on a daily basis and has taught Excel to a large number of students including executives of large organisations, small business owners and entrepreneurs.