|
Provided by: 2e2 Microsoft Excel AdvancedMicrosoft Office |
 |
Objectives: After completing this course, you will know how to: Use names to assign descriptive labels to cells; use financial functions to calculate values based on conditions. Use data tables to view the effects of multiple input values on a formula. Use the Subtotal command, the Subtotal function and database functions to summarise list data; and use data forms and validation to facilitate data entry in lists; and use data tables to project values. Create and use PivotTables to analyse and compare large amounts of data. Import data from and export data to external databases. Use Goal Seek and Solver to perform what-if analysis; and use custom scenarios, advance custom views and pivot tables to manage large worksheets. Run and record macros to automate complex or repetitive tasks. Publish a worksheet as an interactive Web page. Apply financial formulas and array formulas in Data Tables to determine outcomes.
Prerequisites: This course is designed for students who have completed the Excel Intermediate or have equivalent knowledge. It is not suitable as an introduction for people who have little or no experience with this software.
Target Audience: Anyone wishing to consolidate and expand their knowledge, to include some of the more complex functionality of Excel
Prerequisites: This course is designed for students who have completed the Excel Intermediate or have equivalent knowledge. It is not suitable as an introduction for people who have little or no experience with this software.
Target Audience: Anyone wishing to consolidate and expand their knowledge, to include some of the more complex functionality of Excel
|
|
||||||||||
Training
Provided by 2e2
- J asked: Gentlemen: May I ask your assistance regarding above subject. I want to be more knowlegdeable when it comes to Microsoft Excel. I am willing to learn more. thanks a lot & GOD BLESS JC
- A asked: how long it takes me to finish this course?
- asked: Quote and dates please
- L asked: Hi, I would like to introduce myself as working in an MNC company as a Recruiter. I want to take a excel training which include all advanced functions on excel, i got to know about your institute in net .I would think you will help be in this so kindly send me the course details. Will be waiting for your response. regards, Lavanya. A
- A asked: need to learn excel completely
Microsoft Excel Advanced
Course Content:
Advanced Formulas
Using Names
Decision-Making
Financial Formulae
Financial Functions
Data Tables
Advanced List Management
Database Functions
Data Forms and Validation
Subtotal Function
Group and Outline Listed Data
Analytical Options
Goal Seek And Solver
Scenarios
Views
Reports
Exporting And Importing
Exporting & Importing Data
Querying Access Databases
Querying Web Databases
Pivot Tables
Creating A Pivot Table
Rearranging Pivot Tables
Formatting Pivot Tables
Pivot Charts
Group and Outline Pivots
Apply Table Options
Extract a Grouped Value
Macros
Recording And Running A Macro
Editing VBA Code
Function Procedures
Advanced Web Topics
Creating Interactive Web Spreadsheets
Pivot Tables On The Web
Advanced Formulas
Using Names
Decision-Making
Financial Formulae
Financial Functions
Data Tables
Advanced List Management
Database Functions
Data Forms and Validation
Subtotal Function
Group and Outline Listed Data
Analytical Options
Goal Seek And Solver
Scenarios
Views
Reports
Exporting And Importing
Exporting & Importing Data
Querying Access Databases
Querying Web Databases
Pivot Tables
Creating A Pivot Table
Rearranging Pivot Tables
Formatting Pivot Tables
Pivot Charts
Group and Outline Pivots
Apply Table Options
Extract a Grouped Value
Macros
Recording And Running A Macro
Editing VBA Code
Function Procedures
Advanced Web Topics
Creating Interactive Web Spreadsheets
Pivot Tables On The Web
About The Training Provider: 2e2
2e2 - 2e2 is a training provider focussing on the end-user, providing courses in the following areas:
Desktop Applications training (e. g. Microsoft Office)
Unified Communications training (e. g. IP Telephony)
Service Management (including ITIL)
Web Development
Training Room Hire
We deliver public courses in London, Leeds and Birmingham and...
