Microsoft Excel is a very powerful program. It can do many things. But it is so important to understand how to use the formulas and functions that Excel has. This webinar will show you how to build and manage formulas and functions in Excel.
WHY SHOULD YOU ATTEND?
Excel spreadsheets have really become essential in the workplace. They are used for many purposes, from budgets, to forecasts, from financial spreadsheets, to even more scientific purposes and everything in between. But, all spreadsheets require formulas and functions. Formulas are mathematical equations in Excel, and functions are built-in formulas. Building formulas is a crucial skill in Excel, one that has to be mastered. In this webinar, you will learn how to create formulas from the data, This skill will put you heads and shoulders above everyone else who does have this skill, making you and an even more valuable part of your team. Imagine being able to make your own powerful spreadsheets that automatically show the results you want because of the powerful formulas you have created , instead of having to rely on someone else to make the formulas work for you. You can be more productive, make your team or department shine with great looking spreadsheets, and you can save time as well.
AREA COVERED
- Absolute references
- Linking formulas from one sheet to another
- Built in functions :
- If
- Sum
- Count
- Average
- Sumif
- Countif
- Average
- Vlookup
- Date
LEARNING OBJECTIVES
- Creating simple math formulas
- The Mathematical Order of Operations
- Autosum
- Relative Formulas
WHO WILL BENEFIT?
- 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
Excel spreadsheets have really become essential in the workplace. They are used for many purposes, from budgets, to forecasts, from financial spreadsheets, to even more scientific purposes and everything in between. But, all spreadsheets require formulas and functions. Formulas are mathematical equations in Excel, and functions are built-in formulas. Building formulas is a crucial skill in Excel, one that has to be mastered. In this webinar, you will learn how to create formulas from the data, This skill will put you heads and shoulders above everyone else who does have this skill, making you and an even more valuable part of your team. Imagine being able to make your own powerful spreadsheets that automatically show the results you want because of the powerful formulas you have created , instead of having to rely on someone else to make the formulas work for you. You can be more productive, make your team or department shine with great looking spreadsheets, and you can save time as well.
- Absolute references
- Linking formulas from one sheet to another
- Built in functions :
- If
- Sum
- Count
- Average
- Sumif
- Countif
- Average
- Vlookup
- Date
- Creating simple math formulas
- The Mathematical Order of Operations
- Autosum
- Relative Formulas
- 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
Speaker Profile

Tom Fragale is a computer professional with over 30 years of professional experience. He has trained over 30,000 business people in on-line 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 …
Upcoming Webinars

Female to Female Hostility @Workplace: All you Need to Know

Maximizing Productivity with ChatGPT: AI Solutions for HR, …



2-Hour Virtual Seminar on Empowering Presentations with Pow…

Pivot tables beginner to advanced + 20 advanced Pivot table…

Understanding Artificial Intelligence (AI) & using Chat GPT

Creating Loyal Customers Through Excellent Customer Service

Understanding and Communication New Immigration Policies (2…

Navigating Talent Management and Retention Strategies.

HIPAA is Unsettled – Safe Compliance Strategies

Project Management for Non-Project Managers - Scheduling yo…

How to Prepare For and Host a FDA Inspection and Respond to…

Empowering Conflict Resolution: Letting Go to Gain Control

Onboarding Best Practices for 2025: Proven Strategies to Po…

Navigating 2025 Employment Laws: What Every Employer Needs …


Managing Toxic Employees: Strategies For Leaders To Effecti…

How to Conduct Exit Interviews - Implementing and Enhancing…

Adapting to Change: Strategies for Personal & Team Resilien…

Introduction to Excels Built-In Solver – Advanced Decision-…

How to Manage the Legal Landmine of the FMLA, ADA and Worke…

FDA Technology Modernization Action Plan (TMAP) and Impact …

Design Control for Medical Devices Including Verification/V…

Stress, Change And Team Resilience Through Humor: An Intera…


Developing and Implementing Quality Culture in the Organiza…

GROUPBY and PIVOTBY functions. Pivot table killers?


Negotiating Skills For Professional Results - Winning Strat…

Use the power of AI to turbocharge your MS Excel


Trust in Leadership: Building and Maintaining Trust as a Le…

Conquer Toxic People - Learn To Protect Yourself And Get Yo…

Excel - Pivot Tables - The Key To Modern Data Analysis and …

AI and Human Resources: The Great Opportunity!

Tools and Tactics for Grieving, Surviving, and Thriving in …

Bootcamp for New Managers and Supervisors: Develop These Es…

How To Conduct An Internal Harassment And Bullying Investig…

How Generative AI can be used in Banking Risk and Compliance

Creating Employee Handbooks that Protect You and Support th…

Excel Power Skills: Master Functions, Formulas, and Macros …

Emotional Intelligence: Mastering the Emotions of Great Lea…

Managing Toxic & Other Employees Who Have Attitude Issues


The Five Cs Of Commercial Credit: The Basic Elements Of Cre…

SOPs - How to Write Them to Satisfy those Inspectors

Improving Employee Engagement & Retention Through Stay Inte…


How to Give Corrective Feedback: The CARE Model - Eliminati…