October 27, 2020
Granite State College is proud to introduce online training focused on Microsoft Excel.
Microsoft Excel is an important tool that is used in both personal and professional settings. From changing the serving size of a favorite recipe or personal budgeting to evaluating programs, data analysis, and communications, Excel is a powerful, efficient, and accurate software that can help you do a variety of personal and professional activities. You will have a chance to bring your own project to practice with or select from ready-made projects to learn basic Excel skills.
This series includes two sessions: Excel Basics (Jan. 4 to Feb. 12, 2021) and Excel Intermediate (Feb. 15 to March 26, 2021). These 100% online workshops take place over the course of a number of weeks, with the support of an experienced instructor. As a participant, you’ll have access to:
- Free Office 365 (including Microsoft Excel) and other open educational resources
- Supportive assignment feedback
- Optional drop-in sessions with your instructor via Zoom
- A digital badge showing your successful completion of your Excel training that you can share and display on LinkedIn, resume, and other related materials
Participants who are degree-seeking students at Granite State College and successfully complete both the Excel Basics and Intermediate sessions will qualify for two undergraduate credits from Granite State College. Normal credit evaluation procedures will apply. Financial aid is not available.
Excel Basics (online course) – $99
January 4 to February 12, 2021
- Apply basic Excel terminology
- Enter, edit and format data in Excel
- Calculate totals using AutoSum feature
- Create basic formulas
- Describe relative referencing
- Use SUM, COUNT, AVERAGE, MAX, and MIN
- Apply an absolute reference and use an IF Function
- Use conditional formatting
Excel Intermediate (online course) – $99
February 15 to March 26, 2021
- Choose, construct, and format a chart type
- Describe key chart elements
- Identify the basic components of a table structure
- Plan a table
- Create a table
- Import table data (using Wizard)
- Edit a table
- Filter table data
- Use pivot tables to analyze data
- Demonstrate basics of macros in Excel
Questions? Contact Us!
Rachael French, Business Partnerships Manager