top of page

In Person 
Training

1499 PER 
PERSON

MICROSOFT EXCEL - BASIC / INTERMEDIATE

[2 DAYS, 3 HOURS EACH SESSION]

3rd June 04:00 PM - 07:00 PM & 4th June 10:00 AM - 01:00 PM

Graphic Designing

Modules covered

Brilliancy in Basics

Basic Formulas

Features Feast

Formulas Part II (Advanced)

Charts / Graphs

Pivot Table

Error Handling

  • Ground Level Understanding

  • File Management - File Types/Opening PDF

  • Data Input Techniques

  • Understanding References

  • Tab Navigation

  • 150+ Shortcutkeys / Keystrokes

  • Essential Prerequisites

  • Arithmetic Formulas / Functions

  • Date and Time Formulas

  • Text Formulas

  • Cell Formatting

  • View and Navigation

  • Workbook Protection

  • Data Management Techniques - Part I (Data Validation,Flash Fill and More)

  • Data Management Techniques - Part II (Dependent Data Validation,Conditional Format and More)

  • Live demo of 10+ Features

  • Advacanced Arithmetic formulas - Conditional Sum/Count

  • Logical Formulas - Variatiions of IF Formulas

  • Preparing Mini Dashboard with Key Formulas

  • Benefits of using charts and graphs to represent data

  • Common chart types and their uses

  • Creating and Formatting Charts

  • Editing Charts

  • Chart Analysis

  • Advanced Chart Techniques

  • Best Practices for Charts and Graphs

  • Hands-on Practice and Exercises

  • Live Demo of 15 Chart types/variations

  • Introduction to Pivot Tables

  • Creating a Pivot Table

  • Working with Pivot Tables

  • Advanced features of Pivot Tables

  • Pivot Table Options

  • Tips and Tricks for working with Pivot Tables

  • Overview of Errors in Excel

  • Understanding Errors

  • Techniques for Error Handling

Working from Home

HOW IT WORKS

  • Please note that this is a Offline / In-Person training happening at Lake View Park,West Mambalam Chennai(Near Duraiswamy Subway)

  • Maximum participants is restricted to only 10 and hence seats will be allotted on First Come First serve basis

  • Register your details – Name, Email Address, Phone – and submit this form.

  • Pay Rs.1499/- to UPID  -  9003039235@ybl / 9003039235@ibl

  • If you wish to pay through Bank Transfer request for it through WhatsApp at 9003039235

  • Share the Screen shot / Reference to WhatsApp ID 9003039235

  • You will receive all communications to your WhatsApp number and Email Address

Registration form

Thanks for submitting!

bottom of page