In Microsoft Office Excel 2007: Beginner, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas
ADVANCED
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.
Programme Objective
Upon successful completion of this course, students will be able to:
INTERMEDIATE
• Enhance the workbook.
• Automate workbook creation by using templates.
• Organize data using tables.
• Create and modify charts.
• Analyze data using PivotTables and PivotCharts.
• Work with graphic objects.
• Calculate with advanced formulas.
• sort and filter data.
ADVANCED • Increase productivity and improve efficiency by streamlining your workflow.
• Collaborate with others using workbooks.
• Audit worksheets.
• Analyze data.
• Work with multiple workbooks.
• Import and export data.
• Use Excel with the web.
• Structure workbooks with XML.
Course Coverage
INTERMEDIATE
ADVANCED
Lesson 1: Enhancing Workbooks
* Customize the Excel Environment
* Customize an Excel Worksheet
* Enhance Worksheets Using Themes
* Work with Comments
* Access External Resources Using Hyperlinks
* Use Web-Based Research Tools Lesson 2: Creating Workbooks Using Templates
* Create a Workbook from a Template
* Create a Custom Template Lesson 3: Organizing Data Using Tables
* Create Tables
* Modify Tables
* Format Tables Lesson 4: Presenting Data Using Charts
* Create a Chart
* Modify Charts
* Format Charts
* Create a Chart Template
* Share Excel Charts Lesson 5: Analyzing Data Using PivotTables and PivotCharts
* Create a PivotTable
* Perform Calculations Using PivotTables
* Analyze Data Using PivotCharts Lesson 6: Enhancing Visual Appeal Using Graphic Objects
* Insert Graphics
* Modify Graphic Objects
* Emphasize an Area of a Worksheet
* Illustrate Workflow Using SmartArt Graphics
* Format Graphic Objects
* Change the Order of Layered Graphic Objects
* Group Graphic Objects
* Organize Graphic Objects Lesson 7: Calculating Data with Advanced Formulas
* Refer to a Range of Cells
* Calculate Data Across Worksheets
* Perform Date and Time Calculations
* Format Text Using Formulas
* Perform Numeric Calculations
* Calculate Data with Lookup & Reference Functions
* Perform Logical Analysis
* Print Formulas Lesson 8: Sorting and Filtering Data
* Sort Data in a Spreadsheet
* Filter Data in a Spreadsheet
* Calculate Large Volumes of Data
* Add Subtotals to a Worksheet
Lesson 1: Streamlining Workflow
* Create a Macro
* Edit a Macro
* Apply Conditional Formatting
* Add Data Validation Criteria
* Update a Workbook's Properties
* Modify Excel's Default Settings Lesson 2: Collaborating with Others
* Protect Files
* Share a Workbook
* Set Revision Tracking
* Review Tracked Revisions
* Merge Workbooks
* Adjust Macro Settings
* Administer Digital Signatures
* Restrict Document Access Lesson 3: Auditing Worksheets
* Trace Cell Precedents
* Trace Cell Dependents
* Troubleshoot Errors in Formulas
* Troubleshoot Invalid Data and Formulas
* Watch and Evaluate Formulas
* Create a Data List Outline Lesson 4: Analyzing Data
* Create a Trendline
* Create Scenarios
* Perform What-If Analysis
* Perform Statistical Analysis with the Analysis ToolPak Lesson 5: Working with Multiple Workbooks
* Create a Workspace
* Consolidate Data
* Link Cells in Different Workbooks
* Edit Links Lesson 6: Importing and Exporting Data
* Export Excel Data
* Import a Word Table
* Import a Delimited Text File Lesson 7: Using Excel with the Web
* Publish a Worksheet to the Web
* Import Data from the Web
* Create a Web Query Lesson 8: Structuring Workbooks with XML
* Develop XML Maps
* Import and Export XML Data
* Manage XML Workbooks
Pre-requisite
INTERMEDIATE Students need to take the following course or have equivalent knowledge:
• Microsoft Excel 2007: Beginner
ADVANCED
Students need to take the following courses or have equivalent knowledge:
• Microsoft Excel 2007: Beginner
• Microsoft Excel 2007: Intermediate
Programme Structure and Duration
INTERMEDIATE
ADVANCED
Duration:
1 Day
1 days
Programme Delivery:
Instructor led-learning
Instructor led-learning
Award:
At the end of the course the student will be awarded with a Certificate of Attendance
Administrative Details
Administration Fees : RM200 (Non-Refundable)
Course Fees : Please contact us for more details
Contact Us
Informatics Kuala Lumpur 09-35 & 09-37, 9th Floor, West Wing,
Berjaya Times Square, 1, Jalan Imbi,
55100 Kuala Lumpur, Malaysia
