This course is for those who want more from Excel and want to give their Excel knowledge new depths. This course will introduce you with some of the Excel’s advanced features and functionalities that will help you to give your professional career a new boost.
In this course you will be provided an in-depth knowledge of Excel’s in built functions and their structure, Advance filtering techniques with built-in Adavanced Filter command, splitting long text strings in different columns based on delimiters, weaving magic in your Excel worksheets with Custom Number Formatting along with performing various kinds of lookups using Vlookup, Hlookup, Index-Match, Offset, Address etc, on top of all you will learn the use of VBA (Visual Basic for Application) to record macros for faster execution of various tasks which will save a lot of manual work and reduce possible errors.
By the time you finish this course, you will be able to consolidate data from different worksheets and create your own attractive dashboards using charts, Pivot Table, Function based reports.
Our aim is to make your analytical abilities a new boost and make you more productive and efficient in your day to day professional life.
What you'll learn in Ms-Excel Advanced .
Here we train for the advance level of Ms-Excel wherein we cover below topic along with some important basics and tests.
User Forms ( User forms come handy in our day to day data entry needs, therefore we make sure that you never miss out on the following )
Series (Own list creation) (Introduction to Series)
Paste Special (Cell attributes pasting tricks)
Data Validation (With data validation we ensure that correct data is being entered always)Data Validation
Filter / Advance Filter
Data Sort (organizing data in ascending or descending order)
Text to Column
Go to (Selection tips and Tricks using GoTo UF)
Custom Number Format (Learn magic with cell values)
Conditional Formatting (Format cell value based on conditions)
Date & Time Functions
Lookup & Reference Functions
Math & Trig Functions
Fetching live data from internet
Importing data from other databases like Access, Sql etc
Practicals made me effective. I do want to thanks Manoj Sir for providing such rare study material.