Microsoft Excel 2016

About this course

Microsoft Office Excel 2016 provides powerful tools that enable users to organize, analyze, manage, and share information easily.

Course Outline

Course Outline

1: Getting Started With Microsoft Office Excel 2016
  • Topic A: Navigate the Excel User Interface
  • Topic B: Use Excel Commands
  • Topic C: Create and Save a Basic Workbook
  • Topic D: Enter Cell Data
  • Topic E: Use Excel Help
2: Performing Calculations
  • Topic A: Create Worksheet Formulas
  • Topic B: Insert Functions
  • Topic C: Reuse Formulas and Functions
3: Modifying a Worksheet
  • Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
  • Topic B: Search for and Replace Data
  • Topic C: Use Proofing and Research Tools
4: Formatting a Worksheet
  • Topic A: Apply Text Formats
  • Topic B: Apply Number Formats
  • Topic C: Align Cell Contents
  • Topic D: Apply Styles and Themes
  • Topic E: Apply Basic Conditional Formatting
  • Topic F: Create and Use Templates
5: Printing Workbooks
  • Topic A: Preview and Print a Workbook
  • Topic B: Set Up the Page Layout
  • Topic C: Configure Headers and Footers
6: Managing Workbooks
  • Topic A: Manage Worksheets
  • Topic B: Manage Workbook and Worksheet Views
  • Topic C: Manage Workbook Properties

Course Outline

1: Working With Functions
  • Topic A: Work with Ranges
  • Topic B: Use Specialized Functions
  • Topic C: Work with Logical Functions
  • Topic D: Work with Date and Time Functions
  • Topic E: Work with Text Functions
2: Working With Lists
  • Topic A: Sort Data
  • Topic B: Filter Data
  • Topic C: Query Data with Database Functions
  • Topic D: Outline and Subtotal Data
3: Analyzing Data
  • Topic A: Create and Modify Tables
  • Topic B: Apply Intermediate Conditional Formatting
  • Topic C: Apply Advanced Conditional Formatting
4: Visualizing Data With Charts
  • Topic A: Create Charts
  • Topic B: Modify and Format Charts
  • Topic C: Use Advanced Chart Features
5: Analyzing Data With PivotTables and PivotCharts
  • Topic A: Create a PivotTable
  • Topic B: Analyze PivotTable Data
  • Topic C: Present Data with PivotCharts
  • Topic D: Filter Data by Using Timelines and Slicers

Course Outline

1: Working With Multiple Worksheets and Workbooks
  • Topic A: Use Links and External References
  • Topic B: Use 3-D References
  • Topic C: Consolidate Data
2: Using Lookup Formulas and Formula Auditing
  • Topic A: Use Lookup Functions
  • Topic B: Trace Cells
  • Topic C: Watch and Evaluate Formulas

3: Sharing and Protecting Workbooks

  • Topic A: Collaborate on a Workbook
  • Topic B: Protect Worksheets and Workbooks
4: Automating Workbook Functionality
  • Topic A: Apply Data Validation
  • Topic B: Search for Invalid Data and Formulas with Errors
  • Topic C: Work with Macros
5: Creating Sparklines and Mapping Data
  • Topic A: Create Sparkline
  • Topic B: Map Data
6: Forecasting Data
  • Topic A: Determine Potential Outcomes Using Data Tables
  • Topic B: Determine Potential Outcomes Using Scenarios
  • Topic C: Use the Goal Seek Feature
  • Topic D: Forecasting Data Trends

Lagos Center

  • Funmi Aluko

    (+234) 8020559168
    funmialuko@newhorizonsnigeria.com

Abuja Center

  • Dave Abolagba

    (+234) 8020559166
    davidabolagba@newhorizonsnigeria.com

  • Olawale Ogedemgbe

    (+234) 8122690463
    olawaleogedengbe @newhorizonsnigeria.com

Ibadan Center

  • Peter Ilesanmi

    (+234) 8122690455
    peterilesanmi@newhorizonsnigeria.com

Port Harcourt Center

  • Amoo Wasiu

    (+234) 8122690427
    amoo.wasiu@newhorizonsnigeria.com