Learn MS Excel B to A

Microsoft Office is playing main role in Business World and MS Office Excel (workbook) and MS Office Word (document) are the most in use Programs. Therefore, expertise in MS Office Excel/xlsx and Word/doc is a key for improvement in Office Environment.

You can learn Excel 2007-2016 from Beginning to Advanced Level with this application even if you first time start using MS Excel

The following courses are included in this app.

Basics of MS Excel
===============

What is Microsoft Excel
Terminologies used in MS Excel
Basic Tips & Shortcut Keys
Formation of Data
Graphics in Excel
WordArt & SmartArt
Page & Print Setting
Scaling
Formula Auditing
Proofing
Securities
View Setting
Make Your Own Toolbar
Charts
Sparklines
Link with Internet
Make Your own Toolbar
Text to Column
Remove Duplicates
Recovery
PDF
Hyperlink
Data Subtotal & Grouping
Work on 2 Workbooks
Pivot Table
Filter
Sort

MS Excel Formulas
===============

New Functions in MS Excel 2016 (New Addition)
Counting formulas
Date & Time formulas
Depreciation calculator
Financial formulas
Logical formulas
Lookup formulas
Reference formulas
IF Statement
Mathematical formulas
Text Manipulation formulas

Shortcut Keys
===========
File
Selection
Formula
Editing
View
Miscellaneous

Advanced Tools & Techniques
======================

Paste Special
Go to Special
Name Range
Data Validation
Securities
What if Analysis
Macros
Advanced Conditional Formatting
Advanced Pivot Table Techniques
Charts At Next Level
Add-in Solver
Web Queries
Consolidate
Database Queries
Quick Access Toolbar
Dashboard

Visual Basic Application (VBA)
=======================

Introduction & Basic of VBA
Variables
Conditional Logic
String & String Functions
Loops
Arrays
Subroutines
Message box
Functions
Text Files
User Form
Charts

New Features of MS Excel 2016
========================

Tell Me
Real Time Teamwork
6 New Charts
3D Maps
Smart Lookups