Microsoft Excel > Excel Intermediate
- 1 Day Course
Module 1
Filtering to find information
Filtering to display a set of related records
Calculating filtered sets of records
Summing a set of records without filtering
Pivot Tables
Getting external data into a workbook
Creating a dynamic summary using a Pivot Table
Modifying the data displayed in a Pivot Table
Module 2
Create macros to automate repetitive tasks
Edit macros
Add comments to your macro making it easier to understand
Create a macro button to run the Macro
Module 3
Using advanced worksheet functions
Conditional Logic If and Nested If
Financial functions =PMT, =PV and =FV
Using one input data tables
Using two input data tables
Module 4
Create Linking formula
Create links to use the same data in more than one worksheet
Auditing your work, tracing dependents
Protecting your workbook
Share your workbook and track changes
Module 5
Analysing and sharing your data
Comparing alternatives for better decisions
Using goal seek to determine the best price
Creating multiple scenarios to compare alternatives
Test different values using What-If
Working with Scenario Manager
Module 6
Printing tables and forms
Sharing data with other Applications
Embedding information between programs
Pasting a chart into a Word document
Converting a worksheet into a Microsoft Access table
<< Back to Tutoured Courses
