Open / Close contact form

Advanced Excel

Course Overview

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and IOS. It features calculation, graphing tools, pivot tables. It has been a very widely applied spreadsheet for these platforms. Excel has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.

Learning Outcomes

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letternamed columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs.

Manage Workbook Options And Settings

Manage Workbooks

  • Save a workbook as a template
  • Copy macros between workbooks
  • Mange Document Versions
  • Reference data in another workbook
  • Reference data by using structured references
  • Enable macros in a workbook
  • Display hidden ribbon tabs

Manage Workbook Review

  • Restrict editing
  • Protect a worksheet
  • Configure formula calculation options
  • Protect workbook structure
  • Mange workbook versions
  • Encrypt workbooks with a password

Apply Custom Data Formats And Layouts

Apply Custom Data Formats And Validation

  • Create custom number formats
  •  Populate cells by using advanced Fill Series options
  • Configure data validation

Apply Advanced Conditional Formatting And Filtering

  • Create custom conditional formatting rules
  • Create conditional formatting rules that use formulas
  • Manage conditional formatting rules

Create And Modify Custom Workbook Elements

  • Create custom color formats
  • Modify fonts
  • Insert Form Controls
  • Create and modify cell types
  • Create and modify custom themes
  •  Create and modify simply macros
  • Configure form controls

Prepare A Workbook For Internationalization

  • Display data in multiple international formats
  • Apply international currency formats
  •  Manage multiple options for +Body and +Heading fonts

Create Advanced Formulas

Apply Functions In Formulas

  • Perform logical operations by using AND, OR, and NOT functions
  •  Perform logical operations by using nested functions
  • Perform statistical operations by using SUMIFS, AVERAGEIFS, AND COUNTIFS functions

Look Up Data Using Functions

  • Look up data by using the VLOOKUP
  •  Look up data by using the HLOOKUP function
  • Look up data by using the MATCH function
  • Look up data by using the INDEX function

Apply Advanced Date And Time Functions

  • Reference the date and time by using the NOW and TODAY functions
  • Serialize numbers by using date and time functions

Perform Data Analysis And Business Intelligence

  • Import, transform, combine, display, and connect to data
  • Consolidate data
  • Perform what-if analysis by using Goal Seek and Scenario Manager
  • Use cube functions to get data out of the Excel data model
  • Calculate data by using financial functions

Troubleshoot Formulas

  • Trace precedence and dependence
  • Monitor cells and formulas by using the Watch Window
  • Validate formulas by using error checking values
  • Evaluate formulas
  • Calculate data by using financial functions

Format And Modify Text By Using Functions

  • Format text by using RIGHT, LEFT, and MID functions
  • Format text by using UPPER, LOWER, and PROPER functions

Define Named Ranges And Objects

  • Name cells
  • Name data ranges
  • Name tables
  • Mange named ranges and objects

Create Advanced Charts And Tables

Create Advanced Charts

  • Add trend lines to charts
  • Create dual axis charts
  • Save a chart as a template

Create And Manage Pivot Tables

  • Create PivotTables
  • Modify field selections and options
  • Create slicers
  • Group PivotTable data
  • Reference data in a PivotTable by suing the GETPRIVOTDATA function
  • Add calculated fields
  • Format data

Create And Manage Pivotcharts

  • Create Pivot Charts
  • Manipulate options in existing Pivot Charts
  • Apply styles to Pivot Charts
  • Apply Styles to Pivot Charts
  • Manipulate options in existing Pivot Charts
  • Apply styles to pivot Charts
  • Drill down into PivotChart details

Enquire Now

Learn Adobe Photoshop
Your name:
Email address:
Phone number:
Message:

Our google reviews

Other related courses