Financial Modelling using Excel - Day 2
Sponsored links
You need Intermediate to Advanced Excel knowledge.
This course teaches Excel skills not normally taught in a typical Excel course. It takes the features to a new level, and shows you how you can manipulate Excel to display data in a way that is easy to read and easy to update.
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
Adding comments
Excel Tools for Doing Quick Financial Analysis
• Dynamic Charts
Logical functions
Dates
• Dealing with US Dates
• Grouping Dates
• Years
• Months as a number
• Month by name
• Days of the week
• Week of the year
• Week starting
• Date Functions
• Useful Date Hotkeys
Advanced Filters
• Using Advanced Filters
• Removing all Advanced Filters
• Apply an Advanced Filter
• Working with Filtered Data
• Manipulating Filtered Data
• Totalling fields within a filtered database list
• Creating Subtotals
• Removing Subtotals
Pivot Tables
• Understanding Pivot Tables
• Creating Pivot tables
• Dropping data into Pivot Tables
• Modifying data and refreshing Pivot Tables
• Grouping data within Pivot Tables
Financial Functions in Excel
• FV
• PV
• PMT
• Rate
• NPer
• Financial Function Exercises
• Loan Calculator
Depreciation
Protecting your work
Print Areas
Ratio Analysis
Using Gridlines
• Changing the colour of the Gridlines
• Turning off the onscreen Gridlines
• Printing Gridlines
Hiding and Displaying Cells
• Hiding Columns
• Hiding Rows
• Using the mouse to hide Columns
• Using the mouse to hide Rows
• Displaying hidden Columns
• Displaying hidden Rows
• Using the mouse to display hidden Columns
• Using the mouse to display hidden Rows
This Training Course is taught in classrooms in the following locations:
London SE
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
