This is a online course is to gain comprehensive understanding of Microsoft Excel 2010. The aim is to learn about Microsoft Excel 2010 and its features. The tutorials will help you learn about the Basic Excel functions such as the Getting Started with excel 2010, Data Entry in Excel, Calculations, using Formulas, Formatting, Pivot Table, Shortcuts etc. You also learn various advanced functions such as the Arithmetic functions, Database functions, Data Tables, Pivot Charts, graphs and charts and much more.
This is a online course is to gain comprehensive Practical understanding of Excel VBAs and Macros. The aim is to learn essential concepts in Excel VBAs and Macros right from scratch. The tutorials will help you learn about creating First Macro, VBA Environment, Macros with IF Condition, Data Filter, charting with VBA, creating Userform, Referencing Sheets, Calculator - EMI Calculations, Arrays, EMI Calculator - Create Graph, Print Report and Email Report.
This online course is on specifically understanding statistical tools in excel. It includes video tutorials on understanding the descriptive statistics, data analysis tools, central tendency and dispersions, correlation & regression. Further we understand Histogram using data analysis and moving averages using data analysis.
This is a online course is to gain comprehensive understanding of the Excel 2010. The aim is to learn about the fundamentals functions in Excel 2010 and how it should be used. The tutorials will help you learn about Getting Started, Data Entry, Populating the Case Study in Excel, Formulas, formatting, Conditional Formatting, Charts and Graphs, Pivot Tables, Presentation, Prints, Short cuts and common errors.
This is a online course is to gain understanding of Excel 2010 - Advanced functions. The aim is to learn the advanced features Excel 2010 and how they can be used . The tutorials will help you learn Useful Excel Functions, Data Functions, What If Analysis, Functions for working with Text, Pivot Tables, Names and Dynamic Range, Auditing and Trouble Shooting formulas, Form Controls and advanced charts.
In this Bundle, you will learn MS Excel 2010, VBA & Macros, MS Word 2010, Outlook 2010, PowerPoint 2010 and MS Access 2010. This single bundle will help you to gain practical knowledge of all the Microsoft related 2010 packages along with the practical training approach.
This online training on Excel 2010 - Excel Graphs & Charts is for you to dedicatedly learn all about excel graphs and charts. In this course you get to learn how to prepare charts and graphs right from the fundamentals, learn different types if charts for different purposes, learn how to identify the apt chart for the data you wish to represent.
This office productivity online training is to specifically understand the excel 2013 Pivot tables. The course starts right from basic lessons and builds to advanced lessons with practical lectures on pivot. The tutorials are on the Basics of Pivot Table, Summarizing Data Using Pivot Table, Data Filtering, Pivot Table Formatting, Introduction of Pivot Chart, printing the pivot table, Using Macros In Pivot Tables and power pivot.
This course is for you to learn various advanced chart options available in Microsoft Excel. The tutorials will explain you Excel 2010 Sparklines, Range Charts, Funding Graph, Two Axis Graphs, Scenario Graphs, Bar to Pie chart, Combo Charts. We also look at some of the specialised charts such as the Invert Negatives chart, Scrolling Chart and creating histograms.
This wonderful online course is about Data Filtering using Pivot - 2010. You will learn in detail about Customized Sorting, Limited Data Display, Rule Based Sorting, Slicer Formatting, Removing Filters etc.
This is a online course is to gain understanding of Excel VBAs and Macros - Basic functions. The aim is to learn the basic features Excel VBAs and Macros and how they can be used . The tutorials will help you learn Introduction to VBA, creating the First Macro, VBA Environment, Macros with IF Condition, Data Filter, Charting using VBA, creation of Userform.
This is a online course is to gain understanding of Excel VBAs and Macros Advanced functions. The aim is to learn the advanced features Excel VBAs and Macros and how they can be used . The tutorials will help you learn how to create Userform , Looping, Referencing Sheets, Writing Formulas, Create Graph, Print using VBA.
This online course is to learn a very user friendly programming language known as Visual Basic for Applications (VBA). This basically helps in automating the routine tasks which can be easily carried out by the computer if programmed to do so. The tutorials are explained with the help of case studies and starts right from creating the first macro.
This beginner comprehensive course is to understand how VBA's and Macros can be used in order to avoid performing repeated tasks again and again. It is all in all practical course which has been taught right from scratch. The tutorials will explain creating the first macro, understanding VBA language, looping, graphs and charts using macros, user forms using macros and much more.
See the next 4 coursesLoading....
“One of the best videos. Seriously! What more can i say, You guys are the best people in town. Best learning website through online, proper information and great learning. I am highly impressed by their service.