« 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 (22MAR17)
Dates: Mar 22, 2017 - Mar 29, 2017 Time: 9:00 AM
Tuition: $495.00 Instructor: Greg Creech Inquire

    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
03/22/2017 9:00 AM - 4:30 PM Classroom Executive Park
03/29/2017 9:00 AM - 4:30 PM Classroom Executive Park

Additional Information

Final Enrollment:
 
Clock Hours: 13.0