|
Provided by: NobleProg - IT training courses Excel 2007 Advanced Training CourseExcel |
 |
Training
Provided by NobleProg - IT training courses
By the end of this course you will have a complete understanding of the higher functions of Excel. You will be able to perform very advanced calculations and functions, manipulate data using pivot tables and 'advanced' analysis, record macros and integrate with other office applications.
|
|
||||||||||||||||||||
Excel 2007 Advanced Training Course
What is New?
-
Old Menu/ New Location
-
New spreadsheet Dimensions
-
Cell & Table Styles
-
Enhanced Conditional Formatting
-
Enhanced Cell/ Font Colour
-
Enhanced Chart Features
-
Page Layout View
-
Old Feature, New Location
Logical functions
Name ranges
Create named ranges
Use named ranges in formulas
Using the IF function (recap)
Creating nested IF functions
AND and OR functions
Combining logical functions
Lookups
VLOOKUP function
HLOOKUP function
List management
Data validation
Entry of text, values and dates
Creating a dropdown list
Use database functions
Setting up criteria
-
DSUM
-
DAVERAGE
-
DCOUNT
PivotTables and PivotCharts
PivotTable Wizard
Arranging PivotTables
PivotTable toolbar
Create PivotCharts
Analytical options
Goal Seek
Solver add-in
Scenarios
Macros
Create macros
Macro recorder
Macro VBA code
About The Training Provider: NobleProg - IT training courses
NobleProg - IT training courses - NobleProg specializes in bespoke computer and management training courses.
NobleProg provides computer training courses in the following areas:
* Drupal
* Java
* Linux
* MySQL
* OpenOffice
* Oracle
* PHP
* Project Management
* SVN and CVS
* UML
* Web Application Testing
* CSS
* VBA
* BPM
* SOA
* LPI (We are...
