Microsoft Excel Advanced Training Micro Courses
Learn how to use and be proficient at using Microsoft Excel advanced skills including:
Working with Data using Microsoft Excel
- 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.
Advanced Certificate Formulas using Microsoft Excel
- 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.
Practical Financial Formulas and Case Studies in Advanced Excel Course
- 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
Sale! Original price was: $169.00.$129.00Current price is: $129.00. inc GST Add to cart -
Microsoft Excel Advanced Course 308 – Pivot tables, 3D Formulas, Advanced Formulas and Protection
$149.00 inc GST Add to cart -
Microsoft Excel Advanced Course 309 – Goal Seek, Data Consolidation, Solver and Macros
Sale! Original price was: $149.00.$99.00Current price is: $99.00. inc GST Add to cart -
Microsoft Office Excel 3 Advanced Training Course Bundle
Sale! Original price was: $349.00.$149.00Current price is: $149.00. inc GST Add to cart
Showing all 4 results