Skip to main content

Microsoft Excel 2016: Level 1 (Best for Beginners)

ID : 6071   
« back to classes page
Microsoft Excel 2016: Level 1
This class introduces the essential features and functionality of Microsoft Excel. Discover different shortcuts, customizing your toolbar buttons, Ribbon navigation, modifying cells, formatting cells, using basic functions, and writing basic formulas.  Students will also build links, create templates, and charting & graphing data.  Please bring a USB drive to save your work and practice take-home exercises.
Class Outline
  • Review the commands on the Ribbon
  • Adding Commands to the Quick Access Toolbar
  • Tell Me (Help) Feature
  • What are rows, columns, how to hide, group, and delete rows and columns
  • How to Merge Cells, expanding rows and columns, adding underlines vs adding borders
  • Coloring Cells, Coloring Font, changing font sizes, changing font type, formatting cells, etc
  • Practice copy, Paste options, Cut, and Format Painter, creating hyperlinks
  • Use basic formulas while understanding Order of Operations, and using most commonly used functions (Sum, Average, Min, Max, Count)
  • New Flash Fill feature in Excel
  • Students will be creating their own timesheet template
  • Inserting and working with Tables, Shapes, working with SmartArt, creating Charts
  • Adding Header & Footer and best Print Layout Option
  • Sorting and filtering data
  • Using Conditional Formatting
  • Creating a List (drop-down menu)
  • Adding Charts and Graphs
  • Absolute References
  • Protecting your worksheet and workbook

Class Details

4 Sessions
Weekly - Sat

Los Angeles Harbor College

Mario Diaz 



Please read:  No class meeting 02/16/19



Registration Closes On
Saturday, February 2, 2019 @ 12:00 AM

Schedule Information

Skip dates: (No class on 02/16/2019, 02/16/2019)

Date(s) Class Days Times Location Instructor(s)
2/2/2019 - 3/2/2019 Weekly - Sat 9:00 AM - 12:00 PM Wilmington, Los Angeles Harbor College  Map Mario Diaz 

You may also be interested in these classes