Microsoft Excel 2010 Advanced
SmartStyle
Duration: 1 Day
£250
(Exc VAT per delegate on a public scheduled course)
Detailed information
| Type: | Training |
|---|---|
| Method: | In a classroom |
| Accreditation: | N/A |
| Prepares for: | Practical work based advanced Excel skills |
| Geared towards: | Users who need to be able to exploit the full potential of Excel to build powerful spreadsheets, including a wide array of formulae and functions and who also need to use Excel modelling tools to report on results. |
| Requirements: | A thorough grounding in building multiple sheet workbooks which include functions, such as Min, Max, Average and simple Ifs. Users should also be able to create simple charts and use filter and sorting options. |
| Internship: | N/A |
| Students per class: | 10 |
Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course program
Powerful Formulae & Functions
Date & Time Functions
Math & Trig Functions (Round & Int)
Logical Functions (If, And & Or)
Statistical Functions (Countif & Sumif)
Lookup & Reference Functions
Text Functions
Financial Functions
Data Tables
Information Functions (IsBlank & IsError)
Formula Auditing
Cell Comments
Formula Error Checking
Using the Watch Window
Copy & Paste Special
What-If Analysis Tools
Creating, Editing & Deleting Scenarios
Scenario Summary Reports
Using Goal Seek
Using Solver
Using Multiple Workbooks
Arranging Workbooks
Entering Formula Across Workbooks
Linking Information Across Workbooks
Linking Information Across Applications
Advanced Lists
Advanced Filter
Database Functions
Grouping & Outlining
Data Validation
Go To Special
Introducing Pivot Tables
Creating a Pivot Table
Extracting Data from a Pivot Table
Pivot Calculations
Sorting, Grouping & Filtering Pivot Data
Pivot Chart Reports
Templates & Views
Designing & Saving Templates
Creating & Using Custom Views
More On Charts
Changing Chart Values
3-D Charts
Creating Projections with Trendlines
Creating Combination Charts
Custom Chart Templates
Automating Spreadsheets with Macros
Recording & Running Macros
Deleting a Macro
Editing Macros
Macro Virus Protection
Date & Time Functions
Math & Trig Functions (Round & Int)
Logical Functions (If, And & Or)
Statistical Functions (Countif & Sumif)
Lookup & Reference Functions
Text Functions
Financial Functions
Data Tables
Information Functions (IsBlank & IsError)
Formula Auditing
Cell Comments
Formula Error Checking
Using the Watch Window
Copy & Paste Special
What-If Analysis Tools
Creating, Editing & Deleting Scenarios
Scenario Summary Reports
Using Goal Seek
Using Solver
Using Multiple Workbooks
Arranging Workbooks
Entering Formula Across Workbooks
Linking Information Across Workbooks
Linking Information Across Applications
Advanced Lists
Advanced Filter
Database Functions
Grouping & Outlining
Data Validation
Go To Special
Introducing Pivot Tables
Creating a Pivot Table
Extracting Data from a Pivot Table
Pivot Calculations
Sorting, Grouping & Filtering Pivot Data
Pivot Chart Reports
Templates & Views
Designing & Saving Templates
Creating & Using Custom Views
More On Charts
Changing Chart Values
3-D Charts
Creating Projections with Trendlines
Creating Combination Charts
Custom Chart Templates
Automating Spreadsheets with Macros
Recording & Running Macros
Deleting a Macro
Editing Macros
Macro Virus Protection
Do you need clarification regarding the course program?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course location
- 2nd Floor Orleans House, Edmund Street - L3 9NGCity and Borough of Liverpool (England)
SmartStyle
Recognised as one of the UK’s leading providers in the field of learning and development, SmartStyle ensure that organisations get the most from their people, their technology and their investment in both.
Delivering bespoke and “off-the-shelf” IT, business skills and professional development training, SmartStyle provide organisations across all sectors, a one stop solution for their learning and development needs, from our centres in Bradford and Liverpool.
Working in partnership with our clients, we identify real needs, aligned with organisational objectives and match innovative learning interventions to those needs - getting the right skills to the right people and delivering maximum return on investment.
Delivering bespoke and “off-the-shelf” IT, business skills and professional development training, SmartStyle provide organisations across all sectors, a one stop solution for their learning and development needs, from our centres in Bradford and Liverpool.
Working in partnership with our clients, we identify real needs, aligned with organisational objectives and match innovative learning interventions to those needs - getting the right skills to the right people and delivering maximum return on investment.
