Advanced Spreadsheets – baceu2040 (0 credits)

Using Excel® software's advanced spreadsheet functions, users are able to improve their efficiency and effectiveness, by using powerful tools. Users can extract and organize data using tools and formulas, sort and filter data, create PivotTables and PivotCharts, and customize workbooks. In this course, advanced formulas and various tools to analyze data will be presented. Students will learn to organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects. This course provides 0.8 continuing education units, over two - 4 hour workshops.

This non-credit course is 2 weeks. To enroll, speak with an Enrollment Representative.

Ranges and Functions

  • Identify how to create and modify tables
  • Examine how to sort or filter worksheet and table data
  • Identify functions to calculate data
  • Apply range names
  • Use specialized functions
  • Identify questions and testing to write formulas
  • Utilize logical and lookup functions to find answers to questions

Charts and Graphics

  • Identify how to create, modify, and format charts
  • Examine how to create a trendline and advanced charts
  • Identify how to create a PivotTable
  • Examine how to filter data by using slicers
  • Analyze data by using PivotCharts
  • Identify how to insert, modify, layer, and group graphics
  • Determine how to incorporate SmartArt graphics
  • Examine how to customize workbooks, manage themes, create and use templates, and protect files

Start your journey now

Continue
or call us at866.766.0766

Contact us