« Back to Class Listing

Microsoft Excel Level 2: Excelling at Excel

Description


Learn the five Fs of Excel—formatting, fills, functions, formulas, and filters—tools that help you create effective and clear spreadsheets. Understand formatting and basic formulas as you begin building budget and expense spreadsheets. We go on to explore filters, fills, complex formulas, macros, charts and conditional formatting. These tools help you to create fully functional monthly and annual budget tracking spreadsheets.

Section: MS-EXCEL-LVL2 (09JUN17)
Dates: Jun 09, 2017 - Jun 15, 2017 Time: 9:00 AM
Tuition: $495.00 Instructor: Greg Creech Register

This class is taught using Microsoft Excel 2010 on our lab PCs, but the content applies to Excel 2007, 2010, 2013, and 2016 for Windows. Material learned in this course may not apply to Excel for Mac.

    Day 1
  • Lesson 1: Introduction to the Excel environment
  • Lesson 2: F1 - Formatting
  • Lesson 3: F2 – AutoFill and Filling Series
  • Lesson 4: F3 - Formulas
  • Lesson 5: F4 - Functions
  • Lesson 6: F5 - Filters and Sorts
  • Lesson 7: Worksheet Organization, Excel Options, and Summary Worksheet (3D Reference)
  • Lesson 8: Page Set-up, Viewing, and Printing in Excel
  • Lesson 9: Charts – Part 1

    Day 2
  • Lesson 1: Enhancing the Excel Database and Tracking systems in Excel
  • Lesson 2: Creating a Financial Database and using the Name Manager
  • Lesson 3: Analyzing data with Scenario Manager
  • Lesson 4: Analyzing Data through PivotTables
  • Lesson 5: More Functionality using VLOOKUP and CONCATENATE
  • Lesson 6: Macros and Custom Command Buttons

Class Schedule

Date Times Meeting Type Location
06/09/2017 9:00 AM - 4:30 PM Classroom Executive Park
06/15/2017 9:00 AM - 4:30 PM Classroom Executive Park

Additional Information

Final Enrollment:
 
Clock Hours: 13.0