Call us at +1-661-336-9555

cart

Excel is an amazing program that can do some complex and advanced calculations to help automate your spreadsheets and make your job easier.

This webinar will focus on some of the more commonly used complex formulas in the business world. If you already know how to do simple calculations and write a basic IF statement, then this course will take you to the next level by showing you how to create Lookup functions, nest IF statements with other functions, and show you some other useful functions to apply to your spreadsheets.


  • Vlookups and Hookups
  • Nesting IF statements with other functions
  • Text functions
  • Single Result Array formula
  • SUMIF Function

If you are ready to take Excel further than just basic formulas, this course will teach you how to work with more complex functions. Learn the functions most commonly used in business spreadsheets that can help you get more automation.


  • Business users who use Microsoft Office and use spreadsheets

Jenny Douras is President at AdvantEdge Training & Consulting. She has over 25 years of experience in management, employee development, operations, instructional design, and training. Jenny has managed teams of up to 300 people across multiple states and countries, working with several Fortune 500 clients. From this experience, she developed her Remote Employee Management Class. She also sat on the board of directors for the Rocky Mountain Chapter of the American Society for Training and Development for three years and is an active member of the Colorado training community.

View all trainings by this speaker
 
 

April 25, 2024

EEO-1 Reporting Form Requirements for 2023 and How Companies Can Be Compliant

Harold Levy

Upcoming Webinars

Image

By Harold Levy
EEO-1 Reporting Form Requirements for 2023 and How Companies Can Be Compliant
Date: April 25, 2024

Image

By Cathy Horwitz
Understanding Excel's Basic Formulas and Functions
Date: April 26, 2024

Image

By Dr. Susan Strauss
Emojis, AI, Algorithms, Vulnerable Workers And Systemic Harassment – YIKES! Are You Ready To Apply The New Proposed EEOC Guidelines And Court Rulings?
Date: April 26, 2024

Image

By Jason Dinesen
IRS Form 1099 Reporting: Compliance Requirements
Date: April 26, 2024

Image

By Justin Muscolino
Currency Transaction Reports (CTRs) - how to avoid issues with filing
Date: April 29, 2024

Image

By Carolyn Troiano
FDA Technology Modernization Action Plan (TMAP) and Impact on Regulated Computer Systems and Data Integrity
Date: April 29, 2024

Image

By Marcia Zidle
Hybrid Workplace: 10 Best Practices to Manage Your Team’s People, Priorities, & Performance
Date: April 29, 2024

Image

By Charles H. Paul
FDA Audit Best Practices - Do's and Don'ts
Date: April 30, 2024

Image

By Ben Currie
Managing Termination of Employment in the Canadian Workplace: New Developments and Best Practices
Date: May 1, 2024

Image

By Audrey Halpern
Do's and Don'ts of Giving Effective Feedback for Performance Improvement
Date: May 1, 2024

Image

By Pete Tosh
Utilizing HR Metrics to Illustrate & Improve Human Resource's Contribution
Date: May 1, 2024

Image

By Amber Vanderburg
Recruitment Strategies for 2024
Date: May 1, 2024

Image

By Mary Gormandy White
Interviewing Skills for Supervisors and Hiring Managers: Keys to Conducting Effective Candidate Interviews
Date: May 1, 2024

Image

By Daniel T. Bloom
Project Essentials: The Project Charter
Date: May 2, 2024

Image

By Diane L. Dee
Kicking your Employee Retention Efforts into Overdrive: Stay Interviews, Pay Transparency, and Other Effective Strategies
Date: May 2, 2024

Image

By Bruce Lee
The Totally Organized Professional Is All About Outcomes
Date: May 2, 2024

Image

By Jeff Kasoff
Supplier Management: Overcoming Challenges and Exploring Opportunities
Date: May 2, 2024

Image

By Justin Muscolino
Understanding the incredible uses and fallbacks of ChatGPT
Date: May 3, 2024

Image

By Paul J. Cline
Ultimate Persuasion Strategies! - Secret Influence Tools & Skills
Date: May 3, 2024

Image

By Carolyn Troiano
Data Integrity and Privacy: Compliance with 21 CFR Part 11, SaaS/Cloud, EU GDPR
Date: May 3, 2024

Image

By Rebecca Staton-Reinstein
Project Management for administrative professionals
Date: May 6, 2024

Image

By Richard E Cascarino
Accounting For Non Accountants : Debit, Credits And Financial Statements
Date: May 6, 2024

Image

By Marcia Zidle
Onboarding is Not Orientation: How to Improve Your New Hires’ Experience & Their Retention
Date: May 7, 2024

Image

By Don Phin
Coaching At Work- Improving Employee Engagement And Performance
Date: May 7, 2024

Image

By William J. Rothwell
Using High-Performance Coaching for Managers to Address Performance and Behavior Issues
Date: May 7, 2024

Image

By Edwin Waldbusser
21 CFR Part 11 - Compliance for Electronic Records and Signatures
Date: May 7, 2024

Image

By Beverly Beuermann-King
Gossip-Free: Leadership Techniques to Quell Office Chatter
Date: May 7, 2024

Image

By Jonnie Keith
Writing Techniques for Auditors and Risk Management Professionals
Date: May 8, 2024

Image

By Bob McKenzie
Responding to EEOC Discrimination Charges-What's Your Business Case?
Date: May 8, 2024

Image

By Deborah Jenkins
Conflict Resolution - Prevent, De-escalate, Resolve
Date: May 9, 2024

Image

By Ginette M. Collazo
Implementing an Effective Human Error Reduction Program
Date: May 9, 2024

Image

By Patrick Haggerty
When Employees Travel: Wage and Expense Rules Employers Must Know
Date: May 9, 2024

Image

By Jason Dinesen
Form 1099-MISC and 1099-NEC Compliance Update 2024
Date: May 10, 2024

Image

By Alan M Golden
Validation Statistics for Non-Statisticians
Date: May 10, 2024

Image

By Dev Strischek
Why EBITDA Doesn't Spell Cash Flow and What Does
Date: May 13, 2024

Image

By Don Phin
Understanding the Math of HR… So You Can Show How HR Impacts the Bottom-Line
Date: May 14, 2024

Image

By Danielle DeLucy
Sunshine Act Reporting - Clarification for Clinical Research
Date: May 14, 2024

Image

By Dr. John Ryan holds
Food Safety And Quality In Home Food Delivery
Recorded Session

Image

By Margie Faulk
New Domestic Violence, Sexual Assault and Stalking Leave Notice Regulations! What Should Employers do to Ensure Compliance?
Recorded Session

Image

By Janette Levey Frisch
Wage and Hour Issues - The Exempt Vs Non-Exempt
Recorded Session

Image

By Miles Hutchinson
Nonresident Alien Information Reporting Using Forms 1042-S And W-8
Recorded Session

Image

By Ronald Sereika
Analyzing Financial Statements
Recorded Session

Image

By Deborah Covin Wilson
Managing Medical Leave In California, What'S The Difference Between Fmla, Cfra And Pdl
Recorded Session

Image

By Donna K Olheiser
What Are Ach Payments, How Do They Work And What Does That Mean - Essentials Of Ach Payments
Recorded Session

Image

By Margie Faulk
Due Diligence Steps For Form 1099
Recorded Session

Image

By Paul J. Sanchez
Capital Ratio Computations For Depository Institutions
Recorded Session

Image

By Catherine M. Mattice
Employee Engagement: Keeping Your Workforce Motivated To Improve Results
Recorded Session

Image

By Toni G. Cesta
Compliance Measures For Case Management
Recorded Session

Image

By Thomas Nollner
How To Identify & Monitor Your High Risk Customers
Recorded Session

Image

By Neil Malek
Mastering Excel Pivot Tables: The Ace Analytical Tool Of Excel Instead
Recorded Session

Image

By Deborah Covin Wilson
Workplace Civility - Respectful Habits Lead To Increased Productivity, Decreased Liability
Recorded Session

Image

By Ray Graber
Credit Card Surcharging - Who Is Going To Do It And What Are The Stipulations For Compliance?
Recorded Session

Image

By Janette Levey Frisch
Interview Questions And Pre-Employment Screening What Every Employer Needs To Know - Title Vii, Ada/Adaaa, Pdl, Gina, I-9S And Affirmative Action
Recorded Session

Image

By David H. Ringstrom
Excel Proficiency: Pivot Table Basics
Recorded Session

Image

By Paul J. Sanchez
Use Of Analytical Procedures (Aps) For Accountants, Auditors, Financial Analysts And Others
Recorded Session

Image

By David H. Ringstrom
Excel Proficiency: Dashboard Time-Saving Tactics
Recorded Session

Image

By Catherine M. Mattice
Bullying Versus Harassment Versus Violence: Understanding The Similarities And Differences, And Risks For Employer Liability
Recorded Session

Image

By Danielle DeLucy
Preparing And Investigating Oos/Oot Results In A Regulated Environment
Recorded Session

Image

By Joy McElroy
Gaining And Re-Establishing Control Of Your Cleanroom
Recorded Session

Image

By Teddy Burriss
Writing an Effective Investigative Case Report
Recorded Session

Image

By Lisa Marsden
Application Of New Cms Quality Indicator Process In Healthcare And Food Service
Recorded Session

Image

By E. Pete Lewis
Uncovering Overlooked Tax Breaks : Planning Considerations in 2018
Recorded Session

Image

By Mike Thomas
Excel Power Query: The Powerful Get & Transform Tool for Importing and Manipulating Data
Recorded Session

Image

By Karla Brandau
Catapult Your Career with Microsoft Outlook Productivity Tools
Recorded Session

Image

By Deborah Covin Wilson
Managing Medical Leave In California: What’S The Difference Between Fmla, Cfra And Pdl
Recorded Session

Image

By Jeff Kasoff
Best practices for purchasing and supplier controls in the medical device industry
Recorded Session

Image

By Candace Curry Leuck
Finance for Non-Financial Managers: Accounting, Analysis and Budgeting
Recorded Session

Image

By Loren Gelber
FDA Regulations for Pharmaceutical Good Manufacturing Practice (GMP)
Recorded Session

Image

By Rebecca Staton-Reinstein
Leaders Who Win: 7 Strategies for CEO Success You Need Now
Recorded Session

Image

By Marcia Zidle
Workplace Conflict: How to Handle Disagreements, Difficult People, Tough Situations and Be Less Stressed
Recorded Session

Image

By Paul R Hales
Hipaa Social Media Violations - Widespread, Risky, Highly Visible - Learn The Two Simple Steps To Comply With Hipaa
Recorded Session

Image

By Ronald L. Adler
HR Metrics: 2018 Update
Recorded Session

Image

By David E Sanders
Child Support and Garnishments - All You Need To Know
Recorded Session

Image

By Paul J. Sanchez
Analytical Tools - Use of Financial Statement Analytical Procedures (APs) Designed to Focus on Bank Areas of Concern
Recorded Session

Image

By Robert Peoples
Technical Writing Best Practices
Recorded Session

Image

By Margie Faulk
Multi-state Regulation Coordination! Learn How Employers Can Ensure Compliance with Current, New and Proposed State Specific Laws!
Recorded Session

Image

By Candace Curry Leuck
Preparing the Statement of Cash Flows
Recorded Session

Image

By Teddy Burriss
Using Linkedin As A Business Tool
Recorded Session

Image

By Deborah Covin Wilson
Is it FMLA or the "Friday-Monday Leave Act"? How to Identify and Investigate Employees Who Are Gaming the System
Recorded Session

Image

By Janette Levey Frisch
Guidelines For Dealing With Psychiatric Issues At Work
Recorded Session

Image

By Paul J. Sanchez
Accounting for Income Taxes – A Timely Refresher and Update
Recorded Session

Image

By Lisa Marsden
Third Party Vendor Risk Assessment for Financial Firms - Rules, Regulations and Best Practices
Recorded Session

Image

By Laura Goodrich
Innovate and Create by Leveraging The Power of Generations
Recorded Session

Image

By Gregory Powell
The ABCs of Document Retention & Retrieval
Recorded Session

Image

By Donna K Olheiser
2018 NACHA Operating Rules: An Update on Changes Ahead
Recorded Session

Image

By Michael D Haberman
How to Conduct Workplace Investigations - Best Practices and Know How's
Recorded Session

Image

By Rebecca Staton-Reinstein
Leadership: Strategic Planning and Decision Making
Recorded Session

Unsubscribe

×

Subscribe Here

×