Workshop On Advanced Excel

 

A Full Day Workshop on “Advanced Excel”

Kolkata : Saturday 26th November 2020, 10:00AM – 5:30PM; 

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 & Macros Formulas

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

• DATA Analysis

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

• Functions:

LOOKUP, VLOOKUP, HLOOKUP, COUNTIF, SUMIF

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

• 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, Use AutoFormat: Create, use and modify styles and templates, Print features: Create /edit an outline, Graphic Operations.

• Wrap Up

 

Administrative Details:

Venue: The Senator Hotel

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

Date: 26th November 2022 | Timing: 10:00AM-5:30PM (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 is probably the only Learning & Development Organization which has been conducting open workshops every month for the last 3 years. We have conducted more than 50 such workshops spanning across 4 different cities i.e. Kolkata, New Delhi, Bengaluru & Gurgaon making us most experienced & effective in the category of Open / Public Workshops.

• Unmatched Program Quality

Having the best of the facilitators, quality content or modern delivery modes would have been of little use if the same did not translate into creating value for our clients. The very fact of being able to churn out one successful workshop after another across locations since 2015 proves the faith our clients have on us providing us positive reinforcement to carry it forward.

• Convenience & value for money

Infidea’s workshops are conveniently conducted on weekends for enabling participants to attend our programs without hampering their professional commitments during the week days. The pricing of the programs is designed in such a way so as to deliver the best of experience without a pinch in the pocket. The mode is so flexible that corporates have the liberty to regulate their budget depending the number of attendees that they wish to send across.

• Not just a program but a 360-degree experience

Infidea’s workshops are attended by many senior industry leaders and therefore have become an excellent platform for building new professional relationships and meet new contacts by sharing interests and passions. Our open workshops provide a complete experience with safe & hygienic environment, top-notch program delivery, excellent networking opportunity, a valid certification and delicious refreshments.