Aug

06

4 Hour Live Virtual Training On MS Excel Formulas And Tools

Thursday 01:00 PM - Online Workshop/Class · NA · Bangalore

About the Course
In this practical and interactive webinar, you will work along with the instructor. As you progress through the provided spreadsheet of exercises, you will learn a handful of the most often used formulas in Excel. These will include: VLookup, HLookup, Index and Match (solved at last!), Text to Columns, Concatenate, remove Duplicates, IF Functions, Flash Fill and more! You will also discover the tools Andy uses almost daily, but are overlooked and mostly forgotten in Excel. These include, Formula Auditing, Formula Watch, Show Formulas and special tools to add to the Quick Access Toolbar. 

Course Objective

  • Text To Columns and then Reverse w/ Concatonate
  • Use two types of IF Functions (Logical and Error)
  • Understand the syntax of the VLookup and HLookup formulas 
  • Understand the syntax of the Index and Match formulas (finally ‘simply’ explained) 
  • Transpose Data that may be organized incorrectly
  • Remove Duplicates while staying in charge of the process with Conditional Formatting
  • Flash Fill (new in 2016)
  • Absolute Ref vs Named Range in Formulas
  • Formula Auditing + Show Codes
  • Formula Watch Window
  • And hidden tools to add to your Quick Access Toolbar

Who is the Target Audience?

  • Accountants, Accounts, Audit
  • Aviation
  • Banking, CFOs
  • Controllers, CPAs
  • Education
  • Energy
  • FDA
  • Finance, Financial consultants
  • Human Resource
  • Insurance
  • Investments
  • IT
  • Logistics & Supply Chain
  • Marketing
  • Medical Devices
  • Pharmaceutical
  • Retail,Sales
  • Telecom

Basic Knowledge:
This is an intermediate level class. Attendees should be familiar with Excel and use it on a regular basis, at least weekly.

*Organizers/Venues are solely responsible for the service, availability and quality of the events including all or any cancellations/modifications/complaints.
Know about Location & Place
Address :
For Bulk Booking Discounts (10+ tickets) & Best Corporate Deals, Enquire here:
Terms & Conditions

  • Please carry a valid ID proof along with the valid ticket.
  • High Ape is not responsible for any injury or damage occurring due to the event.
  • People in an inebriated state will not be given entry.
  • Being only a ticketing portal, High Ape does not take any responsibility for the activities going on inside or outside the event, as the entire responsibility of it is of the organizer/venue.
  • Please go through the details on the Event Details Tab and the Checkout page thoroughly before booking the tickets, as the tickets which are NOT booked in compliance with it will not come in the ambit of discussion.
  • Internet handling fee per ticket applied. Please check your total amount before payment.
  • Tickets once booked cannot be exchanged or refunded.
  • Unlawful resale (or attempted unlawful resale) of a ticket would lead to seizure or cancellation of that ticket without refund or other compensation.
  • In case a booking confirmation e-mail and SMS gets delayed or fails because of technical reasons or as a result of incorrect e-mail ID / phone number provided by the user etc, a ticket will be considered 'booked' if the payment has been processed by High Ape and you will have to contact our representatives for issue of tickets.
  • Venues/Organizers are solely responsible for the service; availability and quality of the events.
  • In certain circumstances, HighApe reserves the right to cancel the tickets owing to any internal reason which requires such action. In such cases, the customer will be provided full refund for the ticket within 7-10 working days.
  • Venue/Organisers rules apply.

Event by
Bio :

We are a sole event promotion company.

*Organizer's contact details will be provided post-booking in your e-ticket confirmation.
Book new year events at lowest prices
Best prices catch now

Quick Look

dates Thursday, 06 Aug 01:00 PM - Thursday, 06 Aug 05:00 PM
prices 11000 INR

organiser Organised by: Ercess Live

details Special Details: Joining details will be shared post registration