Excel: Introduction

Excel: Introduction

from 145.00

Learn iT! offers training in: Citrix, SQL Server, Business Intelligence, Microsoft SharePoint, Windows Server, Microsoft Office, Adobe CS4, Project Management, Leadership, and much more!

Date:
Delivery Method:
Module:
Quantity:
Purchase Now

GSA Checkout → GSA

Course ID: A1200a

Duration: 1 Day | 2 Modules (9:00 am - 4:00 pm PST)

Location: In-Person (San Francisco) or Live Online | Click here to schedule private course.

Overview:

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists.

+ Who Should Attend

Anyone who would like a foundational understanding of how to create, edit, and present spreadsheets, data sets and formulas.

+ Course Outline

Module 1: Excel Essentials & Intro to Formulas and Functions 

  • Introduction to The Excel Interface  
  • Tell Me 
  • Zooming In And Out Of A Worksheet 
  • Navigating And Selecting Cells 
  • Keyboard Shortcuts 
  • Entering And Editing Data 
  • Smart Lookup 
  • Deleting/Replacing Cell Data 
  • Performing Simple Calculations 
  • Saving The Workbook File 
  • Checking Compatibility With Older Versions Of Excel 
  • Overview Of The Formulas Ribbon 
  • Building Basic Formulas 
  • Using Simple Functions 
  • Copying Formulas/Functions With The Autofill Command 
  • Using Relative And Absolute Cell References In Calculations 

Module 2: Formatting, Spreadsheet Design, Page Setup & Printing 

  • Inserting Rows & Columns 
  • Moving, Copying And Pasting Data 
  • Using Autofill To Complete A Series Of Values 
  • Introduction To Worksheet Themes 
  • Formatting Worksheet Data/Using Cell Styles 
  • Using Excel Templates/Creating Custom Templates 
  • Managing Worksheets: Inserting, Deleting, Renaming, Move/Copy 
  • Grouping Worksheets 
  • Freezing Or Splitting Panes 
  • Grouping And Hiding Rows/Columns 
  • Creating Custom Views 
  • Spell Checking Your Worksheets 
  • Setting Print Options Through Page Setup 
  • Using The Page Layout View 
  • Using The Full Screen View 
  • Printing Your Worksheet 

+ Prerequisites

There are no prerequisites for this course.

+ Certifications

N/A

+ More Excel Courses