Home / Microsoft Excel Expert

Microsoft Excel Expert


MICROSOFT EXCEL EXPERT

Microsoft Excel is a commercial spreadsheet application produced and distributed by Microsoft for Microsoft Windows and Mac OS. It features the ability to perform basic calculations, use graphing tools, create pivot tables and create macros.

Excel has the same basic features as all spreadsheet applications, which use a collection of cells arranged into rows and columns to organize and manipulate data. They can also display data as charts, histograms and line graphs.

Excel permits users to arrange data so as to view various factors from different perspectives. Visual Basic is used for applications in Excel, allowing users to create a variety of complex numerical methods. Programmers are given an option to code directly using the Visual Basic Editor, including Windows for writing code, debugging and code module organization.

Advanced Excel

Topic 1- Intermediate Formula Knowledge

Formula Auditing

Learn to work with formula auditing tools including tracing precedent and dependent cells and formula evaluation.

Temporal Functions

Learn to work with the EOMONTH and EDATE functions that easily shift dates from one month or year to another.

VLOOKUP with Approximate Match

Learn to use VLOOKUP to find an approximate match and return it or the corresponding value from another column.

VLOOKUP with Exact Match

Learn to use VLOOKUP to find an exact match and return it or the corresponding value from another column.

Other Lookup Methods

Learn to work with INDEX, MATCH and HLOOKUP, as alternatives to the VLOOKUP function.

Topic 2- Optimizing Data

Naming Ranges

Learn about creating named ranges, and the benefits of doing so.

Excel Tables

Learn about creating Excel tables, and their advantages.

Recording Macros

Learn to record basic Excel macros to automate your actions (instead of doing them manually).

Topic 3- Data Analysis

Creating PivotTables

Learn to create and modify basic PivotTables (for quickly summarizing and highlighting data).

Formatting PivotTables

Learn to control formatting and other options in PivotTables.

Calculated Fields in PivotTables

Learn to create and modify basic calculated fields for PivotTables.

What-If Analysis

Learn to perform what-if analysis in Excel using the Scenario Manager and Goal-Seek.