IN PERSON NMJC - Microsoft Excel - Level 1 6/7/2022

Register for class here.

Length/CPE Hours

CPE 7 hours

Class Time

8:30 a.m. – 4:30 p.m. Mountain Time

Course Description

This class is designed for the beginner who wants to learn how to build a spreadsheet from scratch using basic formulas.  Have you been using a spreadsheet that someone else designed but you don’t know how they created the formulas?  In the class you will learn how to:

 
Excel Basics

• Navigate the Excel Environment 
• Enter and Edit data
• Learn shortcuts for basic tasks

Creating A Spreadsheet

• Create Basic Formulas that add, subtract, multiple or divide
• Learn to Work with Functions such as =sum() and =average()
• Move and Copy Data
• Insert rows and columns
• Move and Copy Data – Understand the Clipboards
• Use Fill Series
• Adjust Column Width and Row Height

 
Formatting Techniques

• Use the Ribbon to format cells
• Work with the Dialog Launcher and Dialog Boxes
• Use Number and Text Alignment
• Learn the various number formats
• Learn to Copy or Repeat Formats
• Work with Format Painter

 
Printing Solutions

• Learn Tips and Tricks for Printing
• Understand the Page Setup options
• Create and Set Print Areas