Microsoft Excel: Advanced

$180.00

Mondays (5 sessions)
6:00 pm-8:00 pm Career Center
March 14, 2022-April 25, 2022

Description

Microsoft Excel training for business professionals shows you advanced Excel skills that apply to creating smart adaptive Excel business tools. Our advanced Excel training focuses on: Creating Excel analysis and data processing tools using advanced formulas, array formulas, logic, ActiveX controls, conditional formatting, data validation, pivot tables, pivot charts, Excel tables and relationships. Advanced aspects of these elements and how to assemble them in sophisticated ways including modeling and creating interactive dashboards will be covered. Creation of advanced logic will be reviewed, which allows these tools to operate autonomously and adapt to changing data. We will also provide an introduction to macros (VBA).

Prerequisites: Ability to use a mouse, save and retrieve files. Knowledge and experience with Excel. Students must bring their own USB drive.

Clear

You may also like…

  • Placeholder

    Microsoft Excel: Intermediate

    $200.00
    Tuesdays (6 sessions)
    6:00 pm-8:00 pm Career Center
    March 15, 2022-April 26, 2022
    This course will allow students to use more advanced features of Excel. This includes working with multiple worksheets and workbooks, advanced charts, use of advanced functions, summarizing data with Pivot Tables and Charts, linking worksheets, performing and advanced data analysis. Prerequisites: Ability to use a mouse, save and retrieve files. Knowledge and experience with Excel. ...read more
    Select options
  • Placeholder

    Microsoft Excel: Introduction

    $200.00
    Tuesdays (6 sessions)
    6:00 pm-8:00 pm Neptune Annex
    January 25, 2022-March 1, 2022
    This course covers data entry, cell techniques, formulas, using functions, font styles, drawing tools, ranges and printing techniques. Other spreadsheet topics will be explored. Students should be able to use a mouse & keyboard and be familiar with how to save and retrieve files. Students must bring their own USB drive. ...read more
    Select options