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.
Topic 1- Intermediate Formula Knowledge
Learn to work with formula auditing tools including tracing precedent and dependent cells and formula evaluation.
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
Learn about creating named ranges, and the benefits of doing so.
Learn about creating Excel tables, and their advantages.
Learn to record basic Excel macros to automate your actions (instead of doing them manually).
Topic 3- Data Analysis
Learn to create and modify basic PivotTables (for quickly summarizing and highlighting data).
Learn to control formatting and other options in PivotTables.
Calculated Fields in PivotTables
Learn to create and modify basic calculated fields for PivotTables.
Learn to perform what-if analysis in Excel using the Scenario Manager and Goal-Seek.