Account
MBEA

ABOUT MBEA

Discover who we are and what we do

MEMBERSHIP

Register/Renew your MBEA Membership to gain access to special benefits.

RESOURCES

View our curated resources for Business Education

CONTACT US

Have a question? Reach out to MBEA here to get your answer.

Teaching Articles

  • Home
  • Blog
  • Teaching Articles
  • Summer Excel 2019/365 Certification Tips

Summer Excel 2019/365 Certification Tips

  • Posted by patrickwschultz
  • Categories Teaching Articles
  • Date July 14, 2021
  • Comments 0 comment

Excel 2019/365 Certification Tips

I recently attended the 2021 NBEA Hybrid Convention and wanted to share some of my “takeaways” pertaining to certifying in both the Excel 2019/365 and Excel Expert 2019/365.  I admit that even though I certified in Excel 2019/365 in August 2020, I forgot about some of these items that Chadwick Springer and Carrie Leffler from Auburn University shared.

I also learned about a few new features with Excel such as the formula SWITCH, funnel chart, box and whisker chart, maps, and 3D map. Maps were fun to play with and I’m going to incorporate this into my International Business assignment this year.

Before I list some of my takeaways, I do want to say that if you can ever attend the NBEA convention either face to face or virtually it is worth it!  I hope these items help you and your students excel in the certification test!

Anyone trying to certify in the Excel content must know:

  • Manage worksheets and workbooks – import .txt and .csv
  • Customize headers/footers
  • Freeze and unfreeze row/column
  • Change/apply print settings
  • Define name ranges
  • Name a table
  • Remove (or apply) conditional formatting
  • Insert relative, absolute, and mixed references
    • Use/know sparklines
    • Create chart sheets
  • Need to know formulas:
      • Count – this is just numbers.
      • CountA – which has letters and/or numbers – any type of information
      • Countblank – counts empty/open cells as well as those with numbers/text
  • Format text but using formula:   Upper; Lower; LEN
  • Formatting text using Concat – must use Concat not Concatenate. 2016 used Concatenate and in 2019 you will get it wrong if you use this.
      • Concat…this formula allows last name & first name to be in same cell when they have been entered into separate cells in the spreadsheet.
  • TextJoin – ignores empty values for example joining the phone number and extension into one new column. (Use this since some people don’t have an extension.)
    • IFS; MAXIFS

Excel Expert need to know:

  • Manage comments
  • Configure editing and display language
  • Use language-specific features
  • Manage and format data
  • Group and ungroup
  • Calculate data by inserting subtotals and totals
  • Remove duplicate records
  • Advanced Formulas:
    • IF vs. IFS; Switch; SUMIF; SUMIFS; MAXIFS; MINIFS
    • Calculate dates by using Weekday or Workday
    • Forecasting using IF, AND, NPER
  • Macros – record, name, and edit simple macros

Again, I hope this information I learned will help you and your students. One more suggestion, if you don’t already use the Gmetrix platform to help your students prepare, I highly suggest purchasing it.  The skill reviews and practice exams truly have been a game-changer for my student’s success in certifying the first try verses multiple attempts.

Hope everyone has a restful Summer!!!

-Treasa

Tag:Excel, Excel 2019/365 Certification Tips, MBEA 1936, MBEA Summer

  • Share:
author avatar
patrickwschultz

Previous post

2021 Convention Promotion Contests
July 14, 2021

You may also like

techtools
10 Teacher Picks for Best Tech Tools
19 February, 2021

Leave A Reply Cancel reply

Your email address will not be published. Required fields are marked *

Search

Categories

  • Business
  • MBEA Fall Conference
  • MBEA Summer Boot Camp
  • Teaching Articles

Choose the MBEA experience

Our rich history is the foundation for our values. Join us to make your business education experience unforgettable.

NEWSLETTER​

Get the latest MBEA news delivered to your inbox.

CONNECT WITH US
Facebook-f Twitter

Copyright MBEA. Designed by Digital Fox

Login with your site account

Lost your password?