4 Hour Live Virtual Training on MS Excel Formulas and Tools of the Trade

4 Hour Live Virtual Training on MS Excel Formulas and Tools of the Trade

Courses

August 6 | 1PM

Online

11341

Sorry, this show is already over but head here for other fun events!

Invite your friends

and enjoy a shared experience

INVITE

Invite your friends

and enjoy a shared experience

INVITE
About the Event

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.

Terms & Conditions

11341

Sorry, this show is already over but head here for other fun events!

Discover Digital Events

We bring you online experiences to make sure you've got an exciting plan every day.
Bake a cake, get in some yoga, and stay entertained with digital events on the Paytm Insider app.

  • Unsure if you would be able to go?

    Worried your boss may cancel your holiday or your professor may put up weekend lectures? Dont worry, you can easily transfer your ticket to your friend later!

  • Going out with friends?

    Unlock rewards or cashbacks the next time you are going to an event with your friends. Just use the ‘Buy Together’ option for an event if you see one on its page.

Curated & Handpicked EventsPaytm Insider aims to give you experiences in Online worth your time and money, and hopefully, encourage you to try something new. Be it curing post-work blues or making your weekend (more) awesome, you'll find it here. Explore live events (music, comedy, theatre, art); dining experiences; weekend getaways (treks, adventure, tours, travel, cycling, amusement parks); and live sport (cricket, football, kabaddi, badminton) matches; workshops (photography, marketing, cooking, baking, painting) and more.
Music Events: Gigs & FestivalsCalling all music lovers! Watch your favourite artists, live - at festivals, club shows, gigs or concerts. Paytm Insider has the best curated music events, across genres: rock, metal, EDM, pop, fusion, hip-hop, jazz, classical, Bollywood and world, at some of the best live music venues in the country. Paytm Insider hosts several top properties, including Bacardi NH7 Weekender, Timeout, SulaFest, Mood Indigo, Gaana Crossblade Music Festival, Locals DISTRICT, Lager n Barrel, MPower Fest. Also look forward to superstars like Arijit Singh & AR Rahman hosting their tours here.
Comedy Shows & EventsWho doesn't enjoy a good laugh? You'll find the latest shows by the best Indian comedians - Zakir Khan, Kanan Gill, Biswa Kalyan Rath, Kenny Sebastian, Comicstaan finalists (Nishant Suri, Rahul Dua & others) and more, on Paytm Insider. Catch them doing tours of their specials, trying new material, hosting an open mic, and more. Catch the big names of comedy at Headliners and LOLStars; or shows to see up-and-coming comics enthrall audiences, and open mic events where you'll see and cheer on fresh talent! International legends like Russel Peters, Eddie Izzard & Bill Burr have ticketed here in the past.
Cheer Your Favourite Sports Team On!Paytm Insider is home to world-class sporting experiences across India: Vivo Indian Premier League, Indian Super League (FC Goa, Kerala Blasters, Jamshedpur FC, Mumbai City FC, Delhi Dynamos), Vivo Pro Kabaddi (Tamil Thalaivas, U Mumba, Haryana Steelers, Bengal Warriors, Jaipur Pink Panthers), I-League, Vodafone Premier Badminton League, Premier Futsal, and international cricket matches (Test, T20 and ODI). Can't get to a stadium? You'll find amazing screening experiences too - especially the EPL, Champions League and F1.
Weekend Travel: Trekking, Camping & AdventureAfter a tiring week, one of the best ways to unwind is to head to the great outdoors. You will find excellent options for trekking, camping & adventure activities like white water rafting, waterfall rappelling and paragliding near Online. Paytm Insider teams up with experienced and responsible travel groups and event organizers so you have a memorable and safe experience. These events are for novices as well as experienced folks. You will also find special seasonal experiences like fireflies, camping, rafting and more on Paytm Insider.
Discover your city with Paytm Insider
Paytm Insider

Paytm Insider is a platform that helps you discover and buy the best in events, travel and food in your city. We strive to curate experiences that are worth your time and money, possibly something you have never tried before.

For event organizers

Paytm Insider is built by the same team that created Bacardi NH7 Weekender (us) and we sure know what goes into putting together a great experience. Our technology, marketing and customer support can help you build a community of not just ticket buyers, but also fans.