MS EXCEL 2016 - Complete Advance

10 50

Includes

  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

What Will I Learn?

Cell Reference - Filters

Conditional Formating

DSUM, DAVERAG, DCOUNT, SUBTOTAL

Data Validation, Pivot Table, Vlookup & Hlookup, Index, Match Function

Goal Seek, Solver, Paste Special

Import Data

Projects

Curriculum For This Course

Introduction
Cell Reference
Filters
Conditional Formating
Hide Unhide, Format Painter, Remove Duplicates
DSUM, DAVERAGE, DCOUNT, SUBTOTAL
Data Validation
  • Play
    Subscribe 13:56https://player.vimeo.com/
Vlookup, Hlookup, Index, Match Function
  • Play
    Subscribe 13:12
SUMIF, COUNTIF
  • Play
    Subscribe 06:55
Goal Seek, Solver
  • Play
    Subscribe 05:59
Paste Special
  • Play
    Subscribe 06:39
Lock and Unlock Cells
  • Play
    Subscribe 03:27
Import Data From Text File
  • Play
    Subscribe 05:26
Import Data From MS Access
  • Play
    Subscribe 02:25
Filtering in Pivot Data and Creating Pivot Chart
  • Play
    Subscribe 05:24
Bill Format Creation Using Data Validation, If Formula, Sum and Multiplication

Instructor : Chandranath Roy

Name - Chandranath ROy

Contact - +91 9804516943

Email - chandranathroy3@gmail.com 

I help companies use Excel better to improve their reports by providing customized training sessions, Dashboard Training and Enhanced Visualization Techniques. I also help improve processes, by designing interfaces and tools with VBA for Excel. 

Requirements

Basic Knowledge of MS Excel.

Description

This training provides you everything you need to know about Microsoft Excel.

It covers the most advanced features, after taking this online class you will be able to use Microsoft Excel at an expert level.