Excel 101 and 101 LIVE Microsoft Training at NHTI

Excel 101 & 102 will be running in March - live, instructor led with Microsoft Certified Trainer, Tom Fragale - Registration information can be found at nhti.edu/btc --- get grounded with #Excel because Power BI is coming soon!  

Excel 101:  Thursdays, March 4th & 11th 2021, 1:00 pm - 4:30 pm

Professionals working with data and numbers need working knowledge of spreadsheet applications.  If your organization uses Microsoft Excel a hands-on course that teaches how to set up and work with fully formatted worksheets is a must. 

Topic 1:  Introduction to Excel – the basics

Delegates will get a working understanding of the Excel interface to learn the essentials of creating and setting up workbooks, worksheets and working with data.  Topics covered include:

  • Terminology – Workbook, worksheets, cells, ribbon
  • Tour of Excel screen
  • Moving around the Excel interface
  • Entering Data
  • Select ALL
  • Changing Column Widths
  • Speed Fill / Auto Fill
  • Fill down and fill across
  • Inserting rows and columns
  • Performing basic calculations
  • Creating hyperlinks to the web, files, cells, 

Topic 2:  Working with Numbers  

In this session, delegates will practice working with formulas to unleash the power of how Excel spreadsheets.  Topics covered include:

  • More Basic calculations
  • Speed fill with a formula
  • Auto Sum
  • Auto Average
  • MIN
  • MAX
  • Basic Formulas
  • Speed fill with a formula
  • Relative Formulas
  • Absolute formulas

Topic 3:  Formatting Sheets    

Representing data visually is an important element of working with Excel.  In this session participants will learn about options for formatting, sorting and filter and creating visual representations of data.  Topics include:

  • Managing Sheets
  • Using Comments
  • Printing and page setup options
  • Sorting basics
  • Filtering basics
  • Subtotals
  • Charts
  • Formatting the spreadsheet
  • Conditional Formatting
  • Formatting cells for number, calendar, currency, decimal

Topic 4 Managing Sheets   

A workbook can contain many sheets.  Leveraging the use of multiple sheets in a single workbook can increase productivity and overall impact of spreadsheets.    Topics include:

  • Adding Sheets
  • Deleting Sheets
  • Changing a Sheets name
  • Changing a Sheets color
  • Moving Sheets
  • Copying Sheets
  • Navigating Sheets
  • Linking Formulas from 1 sheet to another

Excel 102 -  The Productivity Bootcamp

Thursdays, March 18th & 25th 2021, 1:00 pm - 4:30 pm

Microsoft Excel has become the main program to handle large amounts of data, charts, financial models, math formulas, reports, and just about everything else pertaining to business.  But using it can still be a mystery.

This training will show you everything you need to know about using Excel and getting more productive and efficient with it.  The topics include:

  • Sorts
  • Filters
  • Advanced Filters
  • Subtotals
  • Formatted Tables
  • The Total Row in Formatted Tables
  • Using Slicers in Formatted Tables
  • The Sumif, Countif, and Averageif Formulas
  • The Vlookup Formulas
  • If Formulas
  • Date Formulas
  • Subtotals
  • Charts
  • Pivot Tables
  • Dashboards in Pivot Tables
  • Power Pivot and PowerQuery
  • Automating tasks with Macros



Comments

Post a Comment

Popular posts from this blog

Learning Online: How to Succeed in An Online Course

If you’re considering online courses, that’s great! Learning online is the perfect way to gain new skills on your own time, wherever you may find yourself. Of course, online doesn't mean easier or less rigorous. It does mean that you have location on your side, so you can learn new subjects or master a new skill set entirely from your home. That said, there are some considerations for making the most out of your online course. If this is your first time taking an online course, check out these great tips for success. 1. Connect with your instructor and other learners It's rare to attend an on-campus class and not interact with other students or the instructor. You can (and should) also do this in an online learning environment. Reach out to your instructor early on in the course to let them know what you hope to get out of the material. Better yet, let them know what your professional goals are or how you plan to apply what you learn.  If your course comes with a di...
Read more

Help Yourself & Others by Communicating Mindfully

Mental health is a big struggle for millions of Americans. Depression, anxiety, and other mental health disorders impact 1 in 5 adults each year, according to the National Alliance on Mental Illness, Suicide is the 2nd leading cause of death in people ages 10-34 and the 4th leading cause of death in children between 10 and 14.* As a society, and especially during the COVID19 pandemic, we can help ourselves and each other by learning to practice mindfulness and mindful communication in our everyday lives. NHTI Business & Training Center is excited to announce that professor Dan Huston, author of Communicating Mindfully, Mindfulness-Based Communication and Emotional Intelligence will be leading an online interactive workshop, Introduction to Mindful Communication on June 2, 2020, 3pm - 5pm. Mindfulness can help young and old at home and at work/school to improve communication skills and increase emotional intelligence while reducing stress and anxiety. This 2-hour workshop is...
Read more

NHTI's Business & Training Center - Concord's Treasure Trove of Learning Opportunities!

Image
Beyond degree and certificate programs, NHTI, Concord's Community College hosts a treasure trove of learning opportunities for everyone.  This hidden gem, the Workforce Development Center (an often overlooked entity) is committed to working with businesses, schools and organizations to help their most valuable resource, their employees, enhance current skills or acquire new ones to help cultivate a strong workforce. Perhaps you are someone who needs to brush up on skills to get a job, attain a promotion or broaden your knowledge, NHTI offers numerous ways in which to do so. Through a robust training schedule the Business Training Center offers non-credit workshops and seminars in computer applications including Microsoft and Google, workplace communications, industry and manufacturing, leadership and supervisory skills, and employee development and business skills. NHTI helps job seekers and career builders improve their skills and ready themselves for entering the workforce or f...
Read more