A Full Day Workshop on “Advanced Excel”

A Full Day Workshop on “Advanced Excel” 

Kolkata : Saturday 24th February 2024, 10:00AM – 5:00PM;

Infidea’s upcoming Advanced MS-Excel Training offers real, practical benefits in the general use of Excel Spreadsheets; making your spreadsheets more accurate, reliable, automatic and interactive. Our aim is to equip participants with a strong understanding of using Excel’s advanced functions. This training session is designed for people doing M.I.S management tasks or detailed complex data analysis and who will understand functionalities in MS-Excel to reduce time and eliminate errors in MS- Excel reporting.

Who should attend

• Our workshop is designed for existing MS- Excel users with moderate knowledge of spreadsheets.
• You may be a Senior Manager, Chartered Accountant, Financial Analyst, Business Administrator or anyone who is keen to improve their working knowledge of Microsoft Excel.

Pre Requisites

• Prior knowledge of MS Excel.
• Personal Laptop to be carried by the participant.

Workshop Topics

• Formulas & Functions

Common functions,(AVERAGE, MIN, MAX, COUNT, COUNTA, ROUND, INT),Nested functions, Name cells / ranges, Relative, Absolute, Mixed cell references: >, <, = operators, Logical functions using IF, AND, OR, NOT, The LOOKUP function, Date and time functions.

• DATA Analysis

Sub Total Reports, Auto Filter, Advanced Filter, Multi Filter, Password Protecting Worksheets, Linking Multiple Sheets, Sheet Referencing, Linking Between Word/Excel/PPT, Conditional formatting

• Functions:

LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF

What-if-analysis, GOAL SEEK, Data Table, NESTED IF, Reporting, Character Functions, Date Functions, Age Calculations, Consolidation of Data, Data Validation. Match Index.

• Pivot Tables

Enter the Pivot Table Data, Create the Pivot Table, Adding Data to the Pivot Table, Filtering the Pivot Table Data,Change the Pivot Table Data, Analyse Data Columns in Pivot Tables, Adjust Data to Analyse.

• MACRO’S (Int)

Macros, Definition and use, Record a macro, Assign a macro, Run a macro

• Develop the Worksheet

Plan a worksheet, Row and Column labels, Split worksheet / box / bar, Copy data and formulas, Display /move toolbars, Enhance worksheet Appearance

• Special Operations

Use multiple windows: Copy/ paste between Worksheets, Link worksheets, Consolidate worksheets, Import and link from other Applications.

• Data Cleaning
  Trim(), Upper(), Lower(), LEN(), Left(), Right(), MID()
• Charts
  Line Chart, Column Chart, Bar Chart, Pie Chart, Clustered Column Chart, Combo Chart, Stacked Column Chart.
• Excel Shortcut Keys
• Wrap Up

Administrative Details:

Venue: The Senator Hotel

Address: 15 Camac Street. Kolkata – 700017 (Near Minto Park)

Date: 24th February 2023 | Timing: 10:00AM-5:00PM (Full Day)

Delegate Fees: Rs. 1950 /- + Applicable Taxes

Inclusions: Lunch, Refreshments, Certificate & Soft Copy of Workshop Materials.

Why attend an Infidea Workshop?

Why do corporates / professionals choose to attend workshops conducted by Infidea?

• Masters of Management Development Workshops

Infidea stands out as the leading Learning & Development Organization with a remarkable record of hosting monthly open workshops for the past 9 years. With over 60+ workshops held across Kolkata, New Delhi, Bengaluru, and Gurgaon, we proudly offer the most extensive and impactful selection of Open/Public Workshops available.

• Unmatched Program Quality

Our success lies not only in having exceptional facilitators, quality content, and modern delivery methods but also in the value we create for our clients. The consistent stream of successful workshops across multiple locations since 2014 is a testament to the trust and positive reinforcement we receive from our clients. Their faith in us fuels our drive to keep pushing forward.

• Convenience & value for money

Infidea's workshops are thoughtfully scheduled on weekends, allowing participants to attend without disrupting their weekday work commitments. Our program pricing is carefully structured to offer a premium experience without straining the budget. The flexible mode of attendance empowers corporates to regulate their expenses based on the number of attendees they wish to send.

• Not just a program but a 360-degree experience

Infidea's workshops attract a distinguished group of senior industry leaders, making them an outstanding platform for cultivating professional relationships and expanding networks through shared interests and passions. Our open workshops offer a holistic experience, combining a safe and hygienic environment, exceptional program delivery, ample networking opportunities, valuable certification, and delightful refreshments.