Excel Formulas and Functions
Faculty : Mr.Tom Fragale
26 August 2026
Faculty : Mr.Tom Fragale
Industry :
Live On : Wed
Duration :
Overview
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.
Why should you Attend?
Working with formulas and functions in Excel is absolutely critical to building powerful financial and analytical worksheets and is the most important skill set for many Excel users. It’s essential for Excel users who need to unleash the power of this software to learn more about Excel functions, formula concepts, and invaluable shortcuts. This session presents in-depth coverage of specific formulas and functions, as well as providing attendees with the perspective they need to understand the scope and depth of these critical Excel features.
All examples will be presented within the context of Excel worksheets based on real-life examples encountered over the past 25 years of Excel consulting and teaching experience.
With so many functions, it’s no easy task to know which functions are available and which ones you might have overlooked. Numerous productivity tips, shortcuts, and accelerator tools will be presented throughout the session.
Areas Covered:
- 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
Who will benefit?
This webcast will be of a valuable assistance to the below audience.
- 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
- All Excel Users
REGISTRATION OPTIONS
Avail 10% off by using code 'SAVE10'
LIVE SESSION FOR ONE PARTICIPANT
If you signup & can’t make it, do not worry! We have alternate arrangements.
$199.00
SPEAKER DETAILS:
Mr.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 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 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.
RELATED WEBINARS
REFUND POLICY
Participants/Registrants for our live events, may cancel up to 72 hours prior to the start of the live session and ComplianceTrain will issue a letter of credit to be used towards any of ComplianceTrain’s future events. The letter of credit will be valid for 12 months.
ComplianceTrain will process refund in cases where the event has been cancelled and is not rescheduled within 90 days from the original scheduled date of the webinar. In case if a live webinar is cancelled, participants/registrants may choose between recorded version of the course or a refund. Refunds will not be processed to participants who do not show up for the webinar. A webinar may be cancelled due to unavoidable circumstances, participants will be notified 24 hours before the scheduled start of the event. Contact us via email: contactus@compliancebyte.com