Course Overview
14h 2m | 119 Videos | 89679 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.
| Where do our learners come from? |
| Professionals from around the world have benefited from eduCBA’s Comprehensive MS Excel 2007 courses. Some of the top places that our learners come from include New York, Dubai, San Francisco, Bay Area, New Jersey, Houston, Seattle, Toronto, London, Berlin, UAE, Chicago, UK, Hong Kong, Singapore, Australia, New Zealand, India, Bangalore, New Delhi, Mumbai, Pune, Kolkata, Hyderabad and Gurgaon among many. |
