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

Form analysis
0 forms found in the DOM

Text Content

Skip Main Navigation
Eventbrite
Trigger search event experience
Browse Events
Organize
Help
Log InSign Up
Menu
Page Content


ACTIONS PANEL

 * Like Event

Wednesday, August 2


3-HOUR VIRTUAL SEMINAR ON MASTERING EXCEL FORMULAS AND FUNCTIONS

This hands-on workshop will cover key functions and formulas that will allow you
to tap MS Excel's power and increase your productivity 10X.

By TheComplyGuide
30 followers
Follow


WHEN AND WHERE


DATE AND TIME

Wednesday, August 2 · 5 - 8pm UTC


LOCATION

Online


REFUND POLICY

Refunds up to 1 day before event


ABOUT THIS EVENT

 * 3 hours
 * 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 3-hour 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 3-hour 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.

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


ABOUT THE ORGANIZER

Organized by
TheComplyGuide
30 followers
 * 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
 * Community Engagement
 * 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

© 2023 Eventbrite







About cookies on this site
Experiences are everything. Eventbrite, along with our organisers and partners,
use cookies to give you a more personalised and efficient online experience.
Cookies allow us to monitor site usage and performance, provide more relevant
content and ads, and develop new products. You can accept these cookies by
clicking "Accept" or reject them by closing this banner. You can also manage
cookies and learn more about our partners by clicking on "Cookie Settings". For
more information, please visit our Privacy Policy.

We store your consent for 13 months with 21 partners for Essential cookies,
Performance and functionality cookies, Analytics and customization cookies,
Organizer cookies, Advertising cookies.

Read our policy
Reject AllAccept AllManage Settings