
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. |