www.eventbrite.com Open in urlscan Pro
13.224.189.126  Public Scan

Form analysis
0 forms found in the DOM

Text Content

 * EventbriteEventbrite
 * Search eventsSearch
   Search eventsSearchParis
   
   --------------------------------------------------------------------------------
   
   Paris
 * * Find Events
   * Create Events
   * Help Center
      * Help Center
      * Find your tickets
      * Contact your event organizer
   
   * Log In
   * Sign Up

 * EventbriteEventbrite
 * Search eventsSearch
 * * Log In
   * Sign Up
   * * Find Events
     * Create Events
       * Solutions
           Solutions
         * Event Ticketing
         * Event Marketing Platform
         * Eventbrite Ads
         * Payments
       * Industry
           Industry
         * Music
         * Food & Beverage
         * Performing Arts
         * Charity & Causes
         * Retail
       * Event Types
           Event Types
         * Concerts
         * Classes & Workshops
         * Festivals & Fairs
         * Conferences
         * Corporate Events
         * Online Events
       * Blog
           Blog
         * Tips & Guides
         * News & Trends
         * Community
         * Tools & Features
     * Organizer Resource Hub
     * Create Events
     * Contact Sales
     * Get Started
     * Help Center
       * Help Center
       * Find your tickets
       * Contact your event organizer

Search eventsSearch


ACTIONS PANEL

 * Like Event
 * Share this event

Thursday, March 14


VIRTUAL SEMINAR ON MASTERING EXCEL FORMULAS AND FUNCTIONS





This two-and-half-hour workshop will cover key functions and formulas to let you
tap MS Excel's power & increase your productivity 10X.

58 followers

By TheComplyGuide
58 followers
191 events hosted 📈
Follow
Follow


DATE AND TIME

Thursday, March 14 · 6 - 8:30pm CET


LOCATION

Online




REFUND POLICY

Refunds up to 1 day before event



ABOUT THIS EVENT

 * 2 hours 30 minutes
 * Mobile eTicket

COURSE OVERVIEW:

An Excel formula is an equation or calculation that is stored in a worksheet
cell. A formula enables you to perform simple or complex calculations on
numbers. So think of any scenario that involves addition, subtraction, division,
or multiplication and that's where you'd use a formula.

Functions are built-in formulas that have been programmed to perform a specific
calculation. They range from simple such as SUM and AVERAGE (used to calculate
the total and average of numbers in a range of cells) to the powerful IF and
VLOOKUP.

Functions aren't limited to calculating numeric data. They can save you a ton of
time when working with text and dates too.

 * Need to calculate someone's age from their date of birth?
 * Need to combine text items from several cells into a single cell?
 * Need to convert a list of lower-case text items to capital letters?
 * Need to compare items in two lists?

This almost 3-hour (150-minute) webinar will show how all of the above (and much
more!) can be done by using Excel functions.




WHY SHOULD YOU ATTEND:

Although it is perfectly possible to use Excel without ever creating a formula
if you don't, you're missing out on a huge part of the application's power.

Learning how to create formulas will automate your calculations and save you a
ton of time. No more using your fingers. No more mental arithmetic. No more
using the calculator app on your Smartphone! Let Excel do the work for you!

Excel has over 450 built-in Worksheet Functions (pre-defined formulas). Nobody
needs to know them all however, no matter what your job role is, no matter what
industry you work in, there are some key Functions that everyone should know how
to use.

This 150-minute practical, hands-on workshop will cover powerful MS Excel
Functions and Formulas in detail and show how you can use them to increase your
productivity 10X and save a ton of time.




AREAS COVERED:

 * Creating formulas to perform mathematical calculations
 * Copying a formula - the Gotchas you need to know about
 * Cell Names - how to make formulas logical and understandable
 * Combining text strings from multiple cells
 * Converting text from lowercase to uppercase and vice versa
 * Performing calculations on dates and times
 * Logical functions (IF, COUNTIF, SUMIF, and more)
 * VLOOKUP, HLOOKUP, INDEX, and MATCH
 * GETPIVOTDATA
 * Trapping Errors - Using functions to bullet-proof your worksheets
 * Creating complex functions the easy way




WHO WILL BENEFIT:

 * Any Excel user who needs to go beyond the basics of using formulas or simply
   wants to become more comfortable and productive in using Excel formulas and
   functions
 * Any Excel user who deals with large lists needs these tools and techniques to
   effectively manage the lists and become more productive. Nearly all Excel
   users, except for those just getting started, are candidates for this
   webinar.




ABOUT THE INSTRUCTOR:

Mike Thomas has worked in the IT training business since 1989. He is a subject
matter expert in a range of technologies including Microsoft Office and Apple
Mac. In 2012 He founded theexceltrainer.co.uk where he has produced nearly 200
written and video-based Excel tutorials. He has recorded several Excel training
courses and in his career delivered hundreds of courses and webinars on a wide
variety of technology-related topics.

Mike is a Fellow of The Learning and Performance Institute and has worked with
and for a large number of global and UK-based companies and organizations across
a diverse range of sectors. In addition to training, he also designs and
develops Microsoft Office-based solutions that automate key business tasks and
processes.

3-hour

Refund policy:

Attendees may cancel up to two working days before the course start date and the
refund will be processed within two working days.

We will process/provide a refund if the webinar is canceled. Refunds will not be
given to participants who do not attend the webinar. On-demand recordings can be
requested in exchange. Webinar may be canceled due to lack of enrolment or
unavoidable factors. Attendees will be notified 24 hours in advance if a
cancellation occurs. Substitutions can happen anytime.

If you have any concerns about the content of the webinar and are not satisfied
then please reach us at care@thecomplyguide.com





TAGS

 * Online Events
 * Things To Do Online
 * Online Classes
 * Online Business Classes
 * #excel_training
 * #advanced_excel_training
 * #excel_formula
 * #excel_webinar
 * #ms_excel_training
 * #ms_excel_basics
 * #ms_excel_masterclass


ORGANIZED BY

TheComplyGuide
58 following this creator
191 events hosted
 * Contact
 * Follow

Comply Guide is a training and content provider in the regulatory compliance
space.

We partner with organizations and individuals to address their unique learning
needs, provide training and coaching to help them gain complete knowledge about
best practices, SOPs, and regulations pertaining to their jobs and/or industry.

View more
Organizer website
Report this event




$345 – $695
Get tickets




SITE NAVIGATION


USE EVENTBRITE

 * Create Events
 * Pricing
 * Event Marketing Platform
 * Eventbrite Mobile Ticket App
 * Eventbrite Check-In App
 * Eventbrite App Marketplace
 * Event Registration Software
 * Content Standards
 * FAQs
 * Sitemap


PLAN EVENTS

 * Sell Tickets Online
 * Event Planning
 * Sell Concert Tickets Online
 * Event Payment System
 * Solutions for Professional Services
 * Event Management Software
 * Halloween Party Planning
 * Virtual Events Platform
 * QR Codes for Event Check-In
 * Post your event online


FIND EVENTS

 * Browse Online Events
 * Get the Eventbrite App


CONNECT WITH US

 * Report This Event
 * Help Center
 * Terms
 * Privacy
 * CA Privacy Notice
 * Accessibility
 * Community Guidelines

Eventbrite + Ticketfly

© 2024 Eventbrite