confeplanet


Excel Formulas and Functions

All Days
Information & Technologies | Recorded Webinar | Duration: 60 Minutes
Tom Fragale

Live webinar instructions will be emailed to you 3 days prior to the event. || The recording, digital download, and full transcript will be available within 48 hours after the webinar.
Description

More and more, your company is asking you to do some things with Excel spreadsheets that may leave you challenged or even overwhelmed.

Maybe someone else worked on a spreadsheet, and then they moved on, and now you are in charge of that spreadsheet.

That is called inheriting a spreadsheet. That is what it is actually called. But inheriting a spreadsheet is not as fun as inheriting a million dollars.

Maybe there are some formulas in the spreadsheet that you don’t understand. Or maybe your company is asking you to do certain tasks, and you know there must be a way to get those tasks done, but you don’t know how to actually do it.

Do you struggle with Excel formulas? Do calculations take a long time, and you know there must be a better way to accomplish things in Excel, but you don't know where to turn? Then this course is for you. This course will show you the most popular functions and formulas in Excel and how to use them very efficiently. This webinar will make you more productive in Excel.
 

What you'll learn?

  • Basic Math formulas
  • Autosum and relative references
  • Absolute references
  • Range names
  • Linking sheets and workbooks
  • If, and, or, and the nested if functions
  • Countif, Sumif, Averageif, Countifs, and Sumifs functions
  • Vlookup and Hlookup functions
  • Match and Index functions
  • Date/time functions and calculations
  • Text functions

    Why should you attend?

    More and more, your company is asking you to do some things with Excel spreadsheets that may leave you challenged or even overwhelmed.

    Maybe someone else worked on a spreadsheet, and then they moved on, and now you are in charge of that spreadsheet.

    That is called inheriting a spreadsheet. That is what it is actually called. But inheriting a spreadsheet is not as fun as inheriting a million dollars.

    Maybe there are some formulas in the spreadsheet that you don’t understand. Or maybe your company is asking you to do certain tasks, and you know there must be a way to get those tasks done, but you don’t know how to actually do it.

    Do you struggle with Excel formulas? Do calculations take a long time, and you know there must be a better way to accomplish things in Excel, but you don't know where to turn? Then this course is for you. This course will show you the most popular functions and formulas in Excel and how to use them very efficiently. This webinar will make you more productive in Excel.

    Who should attend?

    • Business owners 
    • CEO’s / CFO’s / CTO’s
    • Managers of all levels
    • Anybody who uses Excel on a regular basis, and want to be more efficient and productive
    • Administrators
    • Salespeople
    • Trainers
    • Bankers
    • Office workers
    Rhanda McKown

    Tom Fragale

    Tom Fragale is a computer professional with over 30 years of professional experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel. He has trained over 30,000 business people in online webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.

    Live webinar training is a virtual event that takes place in real time, where a speaker presents information, and participants can interact through a web conferencing platform.
    Login to your dashboard and get your Live Instruction. You will also receive a notification via email. Live instructions will be emailed 12 hours before the live webinar.
    Recording and Transcript will be available 24 hours after the live date.
    Login to your dashboard and download the presentation (PDF).
    A Digital Download is a digital file (webinar, video, audio, or other content) that can be downloaded and used without further processing. The download link is valid for 30 days. Please save it to your local storage for lifetime access. This link is unique to you and should not be shared.
    Login to your dashboard and click on Digital Download. Download instructions will also be sent via email.
    A transcript is a written record of the spoken words in a webinar, including presenter content and participant questions. It can be accessed within 30 days.
    Login to your dashboard and download the transcript (PDF). Download instructions will also be emailed. The transcript is available for 30 days.
    An on-demand session is a pre-recorded webinar that can be watched anytime with 30 days’ access.
    Login to your dashboard and watch the recording. Instructions will also be emailed. Access is valid for 30 days with unlimited views.
    Login to your dashboard and download the Invoice (PDF). A confirmation email will also be sent once the order is confirmed.
    You can download the registration form or request a call.
    Login to your dashboard, go to My Profile, and change your password.