MS EXCEL 2016 - Complete Advance

Introduction

Cell Reference

Filters

Conditional Formating

Hide Unhide, Format Painter, Remove Duplicates

DSUM, DAVERAGE, DCOUNT, SUBTOTAL

Data Validation

Vlookup, Hlookup, Index, Match Function

SUMIF, COUNTIF

Goal Seek, Solver

Paste Special

Lock and Unlock Cells

Import Data From Text File

Import Data From MS Access

Filtering in Pivot Data and Creating Pivot Chart

Bill Format Creation Using Data Validation, If Formula, Sum and