Microsoft Excel Advanced Training Micro Courses
Learn how to use and be proficient at using Microsoft Excel advanced skills including:
Error checking rules, customising the ribbon, quick access toolbar. databases, field and record delimiters, headers, records, fields, flat file vs relational data, Filtering and sorting data, data formats, Comma Separated Values (CSV), TXT, Tab separated values, open data in Office software programs, Naming Ranges, using Named Ranges in formulas & functions, Data validation and drop down lists and mastering find and replace.
Understand 3D formulas between worksheets, Clean up data using advanced filter,
Create a pivot table and change the value field settings, Create a pivot chart for data analysis to show stats and trends, advanced functions, CHOOSE, VLOOKUP, HLOOKUP, MATCH and INDEX, advanced functions within functions (Nested Functions) and How to protect the worksheet and workbooks.
Find out how much you can afford to pay for a house using goal seek and financial functions, Consolidate information from several sheets, grouping data, use Excel solver to explore possible outcomes depending on input variables, forecast future income, IRR (Internal rate of return), NPV (Net present value) and other financial functions
Showing all 4 results
-
Microsoft Excel Advanced Course 307 – Databases, Filter/Sort, Named Ranges
$49.00 inc GST Add to cart -
Microsoft Excel Advanced Course 308 – Pivot tables, 3D Formulas, Advanced Formulas and Protection
$69.00 inc GST Add to cart -
Microsoft Excel Advanced Course 309 – Goal Seek, Data Consolidation, Solver and Macros
$39.00 inc GST Add to cart -
Microsoft Excel Advanced Training Course Bundle
Sale! $149.00 inc GST Add to cart
Showing all 4 results