kolkata
Date
  • weekwid: false
  • widHeader: false
  • orgName: infidea11b@gmail.com
  • orwid: false
https://www.eventshigh.com/detail/kolkata/a5421c0a90650ed9c3ea5ec1465e0481-one-day-workshop-on-advanced

One day Workshop on Advanced Excel

0.0,0.0
Sat, 16 Nov 10:00AM - 5:30PM
The Senator Hotel
Rs 1950
216 people viewed this event.

Pricing & Offers

Pricing & Offers
Sat, 16 Nov
, 10:00AM
- 5:30PM
Adv Excel 2 - SOLD OUT
Sales expires in
₹ 1,950
Show

Details

Details

Overview of the Workshop

Infidea's upcoming Advance 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


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

  • MACROS (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

Inclusions: Lunch & Refreshments, Certificate of Training, Notes & Handouts, Practical Exercise.

Login to View Organizer Details
Like this event ? Share it with your friends !!
Show

Map & Directions

Map & Directions
The Senator Hotel 15, Camac St, Elgin, Kolkata, West Bengal 700017, India
Reviews
Reviews
No reviews available
Write a review
Be the first one to review! Share your experience.
Show

Frequently Asked Questions

FAQs
Have any query? Drop your questions here !!
Show
EventsHigh Specials, reporting, microsoft, data validation, data analysis, special operations, courses, Infidea Trainings, classes and workshops, startup and entrepreneurship,