excel 365 – advance level

DATE & TIME : October 8 & 9, 2021 | 9.30 AM to 5.00 PM

PROGRAMME FEE : INR 5000 plus 18% GST

FACULTY : Mr. Mehul Shah is having more than 15 years of experience in the

field of Accounts, Finance, IT Teaching. An avid user of

spreadsheet & Tally, he successfully implemented ERP in an

Educational Institute. He has 3 years of experience in a KPO

(Accounts & Finance) where he managed around 100 people.

For registration, please contact:

AHMEDABAD MANAGEMENT ASSOCIATION

AMA Complex, ATIRA Campus, Dr. Vikram Sarabhai Marg, IIM-A Road, Ahmedabad 380 015.

E-mail: ama@amaindia.org • Website: www.amaindia.org

Phone: 079-26308601-05 • Mobile No.: 7203030990

SUMMARY

Most organizations rely heavily on Microsoft Excel to consolidate, analyze, and report

financial information and other important data. Your company is probably no exception. If you

work with data of any kind, learning Excel's advanced functions to taking on greater

responsibilities in your organization.

EXCEL 365 – ADVANCE LEVEL

ON CAMPUS

Sagar Drugs–AMA Computer Centre

Observing Social Distancing Norms laid by Government

LEARNING OUTCOMES

Day-1

Ÿ Open files automatically

Ÿ Working with Heavy Files

Ÿ Using AutoRecover

Ÿ Protecting your Work

Ÿ Data Types

Ÿ Pasting in special ways

Ÿ Selecting special types of cells

Ÿ Data Validation

Ÿ Conditional Formatting

Ÿ Advance Naming Techniques

Ÿ Co-authoring

Ÿ Creating Views

Day-2

Ÿ Advance Functions

Ÿ Advance Filter

Ÿ What-If Analysis

Ÿ Array Formula

Ÿ Advance Lookup Techniques

Ÿ Advance Pivot Table

“Participants should have knowledge of Sort and Filter data, VLOOKUP,

HLOOKUP, XLOOKUP, MATCH, INDEX.”