Call us at +1-661-336-9555

cart

Are you new to Excel and need to learn how to write basic formulas in the software?  Have you inherited a spreadsheet from someone else, and you need to be able to decipher all of the formula code to figure out what is going on with it, or how to modify it?  Learn how to unlock the mysteries of formulas in Excel with this session.  Learn how to write basic formulas that can automate your worksheets.  Learn the difference between Functions and Formulas and how to use these powerful tools in Excel.  Learn tools to help you decipher and create more advanced formulas with the Function Library as you develop your skills.


  • Basic formulas and how they work in Excel
  • Order of operations in formulas
  • Addition, subtraction, multiplication, and division formulas
  • Simple Cell References
  • Writing more complex formulas
  • Copying and pasting formulas
  • 3D formulas
  • Overview of functions and syntax
  • Function Library helpers

New to Excel and need to understand formulas. Inherited a spreadsheet from someone else, and you need to figure out what is going on with it and how it works?

Any company/individual who uses Microsoft Office and 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
 
Live Webinar

Live Session for 1 Participant

$179

Live + Recorded Session

Get unlimited access to the link for six months for one participant, from the date of webinar completion.

$269

Live + Transcript

Get to attend the LIVE Session and also receive a PDF copy of the Transcript only after the completion of the LIVE webinar.

$249

Live + USB

Free shipment within 15 Working Days from the date of webinar completion.*

$399

On Demand

Transcript

PDF Transcript of the Training which are available once the webinar is completed.(Transcript for single user only)

$149

Downloadable Recorded Session

Get unlimited access to the link for six months.

$219

USB

Free shipment within 15 Working Days, from the date of webinar completion.*

$299

Group Session

Group Session Participants + Recorded

Live Session with unlimited participants. Invite any number of attendees to join.

$599

 

June 30, 2025

2-Hour Virtual Seminar on How to Conduct an Internal Harassment and Bullying Investigation to Determine Facts and Minimize Liability

Dr. Susan Strauss

Upcoming Webinars

Image

By Dr. Susan Strauss
2-Hour Virtual Seminar on How to Conduct an Internal Harassment and Bullying Investigation to Determine Facts and Minimize Liability
Date: June 30, 2025

Image

By Suzanne Lucas
FMLA Compliance in 2025: A Comprehensive Guide & Strategies for Effective Implementation
Date: June 30, 2025

Image

By Diane L. Dee
2025 EEOC & Employers: Investigating Claims of Harassment & Discrimination
Date: June 30, 2025

Image

By Ritu Arora
Integrating AI Tools in Microsoft Office
Date: July 1, 2025

Image

By Margie Faulk
How to Manage the Legal Landmine of the FMLA, ADA and Workers Compensation in the Workplace!
Date: July 2, 2025

Image

By Dr. B. Lynn Ware
Best Practices in Virtual Onboarding
Date: July 7, 2025

Image

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

Image

By William J. Rothwell
Effective Succession Planning
Date: July 8, 2025

Image

By Aimee Bernstein
Enhance Your Confidence and Leadership Presence
Date: July 8, 2025

Image

By Pete Tosh
Managing Toxic & Other Employees Who Have Attitude Issues
Date: July 9, 2025

Image

By Mark Gorkin
Stress, Change And Team Resilience Through Humor: An Interactive Playshop
Date: July 9, 2025

Image

By Dr. Susan Strauss
Female to Female Hostility @Workplace: All you Need to Know
Date: July 10, 2025

Image

By Suzanne Lucas
How to Document Employee Behavior
Date: July 10, 2025

Image

By Marcia Zidle
Unlock Employee Loyalty: Stay Interviews Will Keep Them Engaged Before They Start Looking Elsewhere!
Date: July 10, 2025

Image

By Jackie Kiadii
Cleaning Data without Complex Functions - A Course for Data Analysts
Date: July 11, 2025

Image

By Dr.Isaac Gottlieb
The Monte Carlo Simulations in Excel for Risky Investments
Date: July 11, 2025

Image

By Jenny Douras
Excel Formulas
Date: July 14, 2025

Image

By Bruce Lee
How to Give Corrective Feedback: The C.A.R.E. Model - Eliminating Negative Behavior, By Focusing On Accountability
Date: July 14, 2025

Image

By David Benaim
Interactive dashboards & analytics in Excel
Date: July 17, 2025

Image

By Nabil Mourad
Co-Pilot and AI in Excel
Date: July 18, 2025

Image

By Richard E Cascarino
ChatGPT for Accountants
Date: July 21, 2025

Image

By Terry Winship
Telling Stories with Excel data
Recorded Session

Image

By Bob Verchota
How to Conduct Exit Interviews - Implementing and Enhancing Your Exit Interview Program
Recorded Session

Image

By Don Phin
Onboarding is NOT Orientation - How to Improve the New Employee Experience
Recorded Session

Image

By David Benaim
50+ new Excel features so far this decade
Recorded Session

Image

By Jonnie Keith
How to Write Effective Audit Observations: The Principles for Bullet Proofing Your Audit Findings
Recorded Session

Image

By Rebecca Staton-Reinstein
Project Management for administrative professionals
Recorded Session

Image

By Mike Thomas
Outlook - Master your Mailbox - Inbox Hero Inbox Zero
Recorded Session

Image

By Marcia Zidle
Bootcamp for New Managers and Supervisors: Develop These Essential Leadership Skills & Be a Better Boss!
Recorded Session

Image

By Bruce Lee
Negotiating Skills For Professional Results - Winning Strategies Before, During, and In Closing, to Get More and Pay Less
Recorded Session

Image

By Diane L. Dee
Do's and Don'ts of Documenting Employee Behaviour, Performance, and Discipline
Recorded Session

Image

By Cathy Horwitz
Transform Data into Insights: A Beginners Guide to Excel PivotTables
Recorded Session

Image

By Aimee Bernstein
Empowering Conflict Resolution: Letting Go to Gain Control
Recorded Session

Image

By Justin Muscolino
Understanding Artificial Intelligence (AI) & using Chat GPT
Recorded Session

Image

By Mark Gorkin
Keys to Captivating an Audience: Informing and Inspiring through Conflict & Compassion, Courage & Creativity
Recorded Session

Image

By Bruce Lee
Harassment, Bullying, Gossip, Confrontational and Disruptive Behavior: A Manager's Guide on How to Detox and Neutralize a Negative Workplace
Recorded Session

Image

By Deb Schaffer
Copilot and HR: An Introduction for HR Professionals
Recorded Session

Image

By Paul J. Cline
Dealing With Difficult People In Life & Work
Recorded Session

Image

By Susan Fahey Desmond
HANDLING FMLA ABUSE
Recorded Session

Image

By Dr. Susan Strauss
Workplace Investigations 101: How to Conduct your Investigation Like a Pro
Recorded Session

Image

By Mike Thomas
Excel - Pivot Tables - The Key To Modern Data Analysis and Reporting
Recorded Session

Image

By Mark Gorkin
Transforming Anger And Conflict Into Collaborative Problem Solving: The Stress Doc’s Four Faces Of Anger – Model And Method
Recorded Session

Image

By Pete Tosh
Improving Employee Engagement & Retention Through Stay Interviews
Recorded Session

Image

By Dev Strischek
How to Write Right for Better Business Communication
Recorded Session

Image

By Don Phin
Negating Negativity in the Workplace
Recorded Session

Image

By Meredith Crabtree
Developing and Implementing Quality Culture in the Organization and Why it’s Important
Recorded Session

Image

By Gary Heppner
The Return to Work Program OSHA
Recorded Session

Image

By Bob McKenzie
With Mandatory Paid Leave Gaining Ground Is It Time To Do Away With Your PTO and Go Back to a Sick/Vacation Time Off Program
Recorded Session

Image

By Dr. Susan Strauss
Tattoos, hijabs, piercings, and pink hair: The challenges of a dress & appearance code
Recorded Session

Image

By Deb Schaffer
ChatGPT and Project Management: Leveraging AI for Project Management Excellence
Recorded Session

Image

By Marcia Zidle
Reduce Stress in the Workplace: Effective Ways to Handle Conflicts, Difficult People & Tough Situations!
Recorded Session

Image

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

Image

By Audrey Halpern
Managing Difficult Employee Conversations
Recorded Session

Image

By Dr. Susan Strauss
How To Conduct An Internal Harassment And Bullying Investigation To Determine Facts And Minimize Liability
Recorded Session

Image

By Melveen Stevenson
California Meal and Rest Breaks: What You Don't Know Can Cost You
Recorded Session

Image

By Don Phin
Hiring and Retaining Employees in this Crazy Economy
Recorded Session

Image

By Carolyn Troiano
FDA Technology Modernization Action Plan (TMAP) and Impact on Regulated Computer Systems and Data Integrity
Recorded Session

Image

By Don Phin
Creating Employee Handbooks that Protect You and Support the Companys Culture
Recorded Session

Image

By Edwin Waldbusser
How to Prepare For and Host a FDA Inspection and Respond to 483's
Recorded Session

Image

By Jonnie Keith
Writing Techniques for Auditors and Risk Management Professionals
Recorded Session

Image

By Ginette M. Collazo
Building GMP Excellence: A Guide to Implementing Compliant Training Programs
Recorded Session

Image

By Edlyn McGarity
Building Thriving Teams: Proactive Strategies for Managers to Prevent Burnout.
Recorded Session

Image

By Margie Faulk
2025 Top Employment Regulations That Will Impact Employers!
Recorded Session

Image

By Andy Lanning
Excel: Productivity Tips and Tricks
Recorded Session

Image

By Alan M Golden
Impact Assessments For Supplier Change Notices
Recorded Session

Image

By Justin Muscolino
Understanding the incredible uses and fallbacks of ChatGPT
Recorded Session

Image

By Dev Strischek
Why EBITDA Doesn't Spell Cash Flow and What Does
Recorded Session

Image

By Pete Tosh
Utilizing HR Metrics to Illustrate & Improve Human Resource's Contribution
Recorded Session

Image

By Edwin Waldbusser
FDA Regulation of Artificial Intelligence/ Machine Learning
Recorded Session

Image

By Meredith Crabtree
From Challenges to Compliance: Understanding Dietary Supplement Oversight by the FDA
Recorded Session

Image

By Rebecca Farabaugh
Designing Employee Experiences to Build a Culture of Compliance
Recorded Session

Unsubscribe

×

Subscribe Here

×