MS Excel 2007 Course - Beginners and Advanced | MS Excel 2007

This is a comprehensive training on learning the basic and advanced functions in Excel 2007. The course has been taught using interactive video tutorials and practice examples. The module will enable you to learn various Logical, Arithmetic, date functions, convert text to string, Pivot Tables, Conditional Formatting, check boxes, hyper links and other basic excel tools. The advanced section will include understanding CHOOSE, VLOOKUP, HLOOKUP, data tables, graphs and charts.

346

 14h 2m | 119 Videos | 98945 Views |   All Levels

MS Excel 2007 Course – Beginners and Advanced

This Excel Combo 2003-2007 course is a comprehensive online tutorial that will take at another level of using Microsoft Excel. It would complete your learning of this interesting and awesome spreadsheet software that will help you gain proficiency in completing your mundane tasks. This extensive course has been divided broadly into four major modules viz. Basic Excel, Advanced Excel and VBA’s and Macros. It also includes a practice test at each level which will help participants practically implement their learning.

MS Excel 2007 Course would equip you to learn the following Excel features:

Basic Excel functions such as Logical functions, Arithmetic functions, Date functions, Aggregation functions etc.

• Using Excel functions such as Auto and data filter, Sort, Arrays, Data validation and many more.
• Advanced formulae, Special cases in graphs, What if analysis, Analyst research, and graphs
• VBA’s and Macros involving Looping, preparing graphs and charts using Macros, Create Radio buttons, Combo box, List box, Checkbox.

Target Audience for MS Excel 2007 Course:

It is for people who want to learn Microsoft Excel for real-world applications, for example, to create and analyze reports, graphs, and charts etc.

• Those who wish to create simple Macros
• For all students/professionals of any educational background

MS Excel 2007 Course Highlights

• Basic Excel

The tutorials would start with the most basic part of excel in order to help the participants learn about excel tools and functions right from the scratch. It includes tutorials that cover the fundamentals of using Excel features to perform various tasks in excel. One would get training on the basic excel functions such as the and/if/or functions, ABS, INT, LARGE, MAX, MIN etc., learn how to use excel tools such as auditing features, grouping tabs, creating text top column, check boxes, hyperlinks etc.

•  Advanced Excel

Going one step further this module would provide training on the advanced formula in excel. Here you will find step by step tutorials on the most useful and most used advanced functions and formula in Excel. The tutorials are on the excel functions such as the CHOOSE, VLOOKUP, HLOOKUP, Offset, Forecast function, data tables, goal seek, solver, learning different types of analyst graphs such as band charts, range chars etc.

• VBA’s and Macros

This module in this course has been included to help the participants learn how to create their own macros so that one can take their Excel skills to the next level. I have been explained I a very easy fashion assuming that you have no experience with coding. Looping has been explained using examples, also at the end, it includes solving a sum using VBA Macros.

Back to top ^