Microsoft Excel Advanced Self Paced Online Course

Regular price $199.00

Please allow 24 hours to process the payment.

Topics

Getting Started with Microsoft Office Excel 2016; Performing Calculations; Modifying a Worksheet; Formatting a Worksheet; Printing Workbooks; Managing Workbooks; Working with Functions; Working with Lists; Analyzing Data; Visualizing Data with Charts; Using PivotTables and PivotCharts; Working with Multiple Worksheets and Workbooks; Using Lookup Functions and Formula Auditing; Sharing and Protecting Workbooks; Automating Workbook Functionality; Creating Sparklines and Mapping Data; Forecasting Data.

Prerequisite

  • Microsoft Excel Intermediate course or equivalent.

Learning Objectives

By the end of the course, you should be able to:

  • Use SUMIF, SUMIFS, COUNTIF, and COUNTIFS functions
  • Use VLookup and Hlookup functions
  • Look for an exact match or closer match.
  • Create a drop-down list for a set of cells to pick the right set of data.
  • For a particular set of cells, set the rules to insert values
  • Create and view multiple scenarios
  • Summarize scenario results in a separate worksheet
  • Filter, Show, and Hide PivotTable Data
  • Create, Edit & Format PivotTables
  • Analyze Data Dynamically Using PivotTables
  • Filter a PivotTable by using multiple methods
  • Create a formula that references PivotTable data
  • Use PivotTables to analyze data dynamically.
  • Creating & Using PivotChart
  • Create Dynamic Charts Using PivotCharts
  • Create, update, modify, and filter a PivotChart
  • Use PivotCharts to create dynamic charts.
  • Use Goal Seek to get the desired result.
  • Use Solver to find the optimal solution.
  • Apply conditional formatting to the table
  • Analyze Data Using Descriptive Statistics
  • Create charts & customize the appearance of the chart.
  • Ability to find trends in data.
  • Use sparklines to summarize data
  • Enable, Create and Modify Macros
  • Examine, step through, and run a macro
  • Run Macros When a Button is Clicked 
  • Add macro buttons to the Quick Access Toolbar
  • Create hyperlinks.
  • Share workbooks.
  • Manage comments.
  • Track and manage colleagues’ changes.
  • Save workbooks for the Web.
  • Save a workbook as a PDF
  • Add, display, review, and delete comments
  • Password-protect a workbook and a worksheet

    Assumptions

    • The student has access to Microsoft Excel software for hands-on exercises. 
    • The student is familiar with writing formula and function in Excel
    • The student has at least 1 year of experience using Microsoft Excel or attended Excel Intermediate class.

      Who should take this Course?

      • The student has at least 1 year of experience using Microsoft Excel or attended Excel Intermediate class.

      What do you need?

      • At least 1 year of experience using Microsoft Excel or attended Excel Intermediate class.
      • Excel 2016 installed on your computer.