Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Oracle Database 11g: SQL Fundamentals I 
Print PageExcel 2010: Advanced
Description:
In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications. The course also looks at Pivot Tables and VLookups.
- Cost: €195.00
- Duration: 1 day
- Cork Date: 19 Apr, 28 Jun
- Limerick Date:
- Dublin Date: 25 May, 24 Jul
- This course is also available as a customised client specific course.
Prerequisites:
To ensure the successful completion of the Advanced course, the completion of the Intermediate course or equivalent knowledge is recommended.
Advanced Topics:
1.1: Setting Excel Options
• Changing Your User Name
• Changing your Default Font
• Changing Your Default File Format
• Setting Formula Options
• Changing the Appearance of Your Excel Interface
1.2: Excel and Windows
• Searching for Documents
• Using Office Diagnostics
• Checking for Updates
• Starting Excel Automatically when Windows Boots
1.3: Using the Excel Viewer
• What is the Excel Viewer?
• Downloading the Excel Viewer
• Using Excel Viewer
• Changing Your User Name
• Changing your Default Font
• Changing Your Default File Format
• Setting Formula Options
• Changing the Appearance of Your Excel Interface
1.2: Excel and Windows
• Searching for Documents
• Using Office Diagnostics
• Checking for Updates
• Starting Excel Automatically when Windows Boots
1.3: Using the Excel Viewer
• What is the Excel Viewer?
• Downloading the Excel Viewer
• Using Excel Viewer
Getting the Most From Your Data:
2.1: Getting the Most from Your Data
• Using Automatic Outlining
• Displaying and Collapsing Levels
• Grouping Data Manually
• Creating Subtotals
2.2: PivotTables
• What is a PivotTable?
• Creating a PivotTable
• Creating a PivotTable Frame
• Specifying PivotTable Data
• Rearranging PivotTable Data
2.3: More About PivotTables
• Modifying PivotTable Calculations
• Formatting a PivotTable
• Refreshing a PivotTable
• Charting a PivotTable
• Creating a PivotTable Based on External Data
• Creating a Slicer
• Using PowerPivot
2.4: Exploring Scenarios
• What is a Scenario?
• Creating a Scenario
• Creating a Scenario Summary Report
• Saving Multiple Scenarios
2.5: What If Analysis
• Using a One and Two Input Data Table
• Using Goal Seek
• Using Solver
• Using Automatic Outlining
• Displaying and Collapsing Levels
• Grouping Data Manually
• Creating Subtotals
2.2: PivotTables
• What is a PivotTable?
• Creating a PivotTable
• Creating a PivotTable Frame
• Specifying PivotTable Data
• Rearranging PivotTable Data
2.3: More About PivotTables
• Modifying PivotTable Calculations
• Formatting a PivotTable
• Refreshing a PivotTable
• Charting a PivotTable
• Creating a PivotTable Based on External Data
• Creating a Slicer
• Using PowerPivot
2.4: Exploring Scenarios
• What is a Scenario?
• Creating a Scenario
• Creating a Scenario Summary Report
• Saving Multiple Scenarios
2.5: What If Analysis
• Using a One and Two Input Data Table
• Using Goal Seek
• Using Solver
Excel and the Internet:
3.1: Excel and Hyperlinks
• What is a Hyperlink?
• Inserting Hyperlinks
• Modifying Hyperlinks
• Using Hyperlinks in Excel
3.2: Saving Workbooks as Web Pages
• HTM and MHTML Files
• Saving a Workbook as a Web Page
• Saving a Worksheet as a Web Page
• Saving a Chart as a Web Page
• Saving a Range as a Web Page
3.3: Getting Data from the Internet
• Importing from an External Data Source
• Creating a Web Query
• Saving a Web Query
• Refreshing a Web Query
3.4: Excel and Office Servers
• Publishing to a Document Server
• Saving to a Document Management Server
• Using Excel with Excel Services
• What is a Hyperlink?
• Inserting Hyperlinks
• Modifying Hyperlinks
• Using Hyperlinks in Excel
3.2: Saving Workbooks as Web Pages
• HTM and MHTML Files
• Saving a Workbook as a Web Page
• Saving a Worksheet as a Web Page
• Saving a Chart as a Web Page
• Saving a Range as a Web Page
3.3: Getting Data from the Internet
• Importing from an External Data Source
• Creating a Web Query
• Saving a Web Query
• Refreshing a Web Query
3.4: Excel and Office Servers
• Publishing to a Document Server
• Saving to a Document Management Server
• Using Excel with Excel Services
Advanced Excel Tasks:
4.1: Creating and Using Shared Workbooks
• Sharing a Workbook
• Opening and Editing a Shared Workbook
• Tracking Changes
• Resolving Conflicts in a Shared Workbook
4.2: Using Custom AutoFill Lists
• What is an AutoFill List?
• Creating a Custom AutoFill List
• Modifying a Custom AutoFill List
• Using a Custom AutoFill List
4.3: Using the VLOOKUP Function
• Using VLOOKUP to Find Data
• How to Find an Exact Match with VLOOKUP
• Finding the Closest Match with VLOOKUP
4.4: Linking, Consolidating, and Combining Workbooks
• Linking Workbooks
• Consolidating Workbooks
• Combining Worksheets
4.5: Macros in Excel
• Macros in Excel
• Recording Macros
• Playing a Macro
• Macro Security
• Assigning a Keystroke to a Macro
• Sharing a Workbook
• Opening and Editing a Shared Workbook
• Tracking Changes
• Resolving Conflicts in a Shared Workbook
4.2: Using Custom AutoFill Lists
• What is an AutoFill List?
• Creating a Custom AutoFill List
• Modifying a Custom AutoFill List
• Using a Custom AutoFill List
4.3: Using the VLOOKUP Function
• Using VLOOKUP to Find Data
• How to Find an Exact Match with VLOOKUP
• Finding the Closest Match with VLOOKUP
4.4: Linking, Consolidating, and Combining Workbooks
• Linking Workbooks
• Consolidating Workbooks
• Combining Worksheets
4.5: Macros in Excel
• Macros in Excel
• Recording Macros
• Playing a Macro
• Macro Security
• Assigning a Keystroke to a Macro