arrow_back
Course Introduction
About the Training -Microsoft Excel Training
Connect with IWCampus Support
Getting started with Microsoft Excel
Introduction to Microsoft Excel
Workbook Rows and Columns
Excel Lab Sample file -IWCampus
Formating Rows and Columns
Cell data formats
Cut, Copy and Merge
Paste data to cells
Quick formula shorcuts
Excel file management
csv files
Formatting Data
Filter
Table format
Conditinal format
Data Validation
Manage Data
Text to Columns
Remove Duplicates
Import data from PDF
Import data from csv
Import data from Web
Import data from JSON
Excel Formulas
Simple formula
Excel Functions
How to use a Excel Function in Formula
Handling Text values
Logical Function in Formula
Cell Reference
VLOOKUP
HLOOKUP
Trace Formula
Formula Error Checking
Working with Data
Chart
Pivot Tables
Goal Seek
Forecast Sheet
Instert live data using Data Types
Workbook Security
Protect Workbook and Sheets
Advanced Topics
Sample File: Car Showroom Data Records
Manage Data using a form in Excel
Maintain Date format consistency using tool
Generate Auto numbers in Excel using Formula
Auto Generate Alpha-Numeric Codes
Automatic Dropdownlist and Validation
Generate Dynamic Year List
Highlight rows based on selected values in dropdownlist