Advance Excel

Service Image

Description

In this course, you will learn how to: Duration: 3 Month

  • Create outlines in Excel
  • Create your own templates
  • Work with sparklines
  • Create and manage scenarios
  • Use Goal Seek and Solver
  • Create, manage, and format pivot tables and pivot charts
  • Use the Excel mathematical functions
  • Create and write complex formulas
  • Perform data lookups
  • Create and use IF statements
  • Use Excel's data functions
  • Create and use data validation rules
  • Apply custom and prebuilt conditional formatting
  • Work with functions to manipulate strings of text and data
  • Create and use macros
  • Troubleshoot and audit formulas
  • Create pivot tables and pivot charts
  • Use queries to import external data
  • Import and clean data
  • Link and consolidate worksheets and workbooks
  • Troubleshoot errors
  • And more

Checkout

Name Advance Excel

Enquiry Now