Globalquest Solutions’ Webinar Series

Discover what makes information technology great every single month. Globalquest Solutions invites you to tune in and attend our webinars each and every month.

Dec 16th
Part 3
Microsoft Office SharePoint Register

Excel - Part 3

This assumes that everyone knows how to open up Excel and enter some numbers or text. What we will go over includes a combination of keyboard and mouse commands that will make navigating and entering data easier.

  1. Using and building formulas
    • a. Using Named Ranges
    • b. Building formulas one function at a time
  2. How to lookup data
    • a. Vlookup
    • b. Hlookup
    • c. Xlookup (Microsoft 365 only)
    • d. Index and Match
    • d. Choose
  3. Using SUMIF, AVERAGEIF,COUNTIF functions
  4. Formulas using IF statement and IFERROR statement
  5. Filtering your data
    • a. Using the SUBTOTAL function
    • b. Using Advanced Filter

Upcoming Events

Excel Series
Microsoft Office Excel Coming Soon

Past Events

Nov 18, 2020
Part 2
Microsoft Office Excel On Demand
Nov 11, 2020
Part 1
Microsoft Office Excel On Demand
oct 11, 2020
Episode 1
Microsoft Teams
Microsoft Office Teams On Demand
IT support buffalo