Preview Microsoft Excel Professional -Training

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