Advanced Excel 2010

Course Duration for Microsoft Excel 2010 Training : 2 days

SDF Funding is available to Singapore Companies (For company sponsored candidates). Call 6296-2995 for Details.

 Excel 2010 Course Objectives

-    Participants will learn to use advanced functions of Excel® 2010 to improve productivity, enhance spreadsheets with templates, charts, graphics, and formulas and streamline their operational work.

 -    They will apply visual elements and advanced formulas to a worksheet to display data in various formats.

 -    Students will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s advanced functionality to simplify and streamline their day-to-day work.

 Who Should Attend?

 -    This program is best suited for people who use Microsoft Excel in their day-to-day work, and know the basics fairly well, but would like to extend their knowledge of the more advanced functions of Excel to become more productive and make the most of Excel 2010.

 -    The course is designed for students would want to learn how sort and filter data, import and export data sets, and analyze data using the rich features provided in Excel. It will impart the necessary skills to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

 -    In addition, the course is also for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft® Office Excel® 2010, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

 After Course Completion:

 -    After the successful completion of the Intermediate to Advanced Excel 2010 Training program, students will be able to: - calculate with advanced formulas. - organize worksheet and table data using multiple techniques. - create and modify charts & graphs. - analyze data using PivotTables and PivotCharts. - insert graphic objects. - customize and enhance workbooks and the Microsoft® Office Excel® environment.

 They will know learn to deploy advanced Excel techniques to increase productivity and improve efficiency by streamlining the workflow. - collaborate with others using workbooks. - audit worksheets. - analyze data. - Work with multiple workbooks. - Import and export data

 Course Outline for Advanced Excel 2010

 Lesson 1: Working with Custom and Conditional Formats in Excel 2010
              1.1 Creating a Custom Format
                  Create a custom number format 

             1.2 Conditional Formatting
                 Creating Conditional Formatting
                Editing Conditional Formatting
                Adding Conditional Formatting
                Deleting Conditional Formatting from the Selected Range

 Lesson 2: Using Formulas and Functions in Microsoft Excel 2010
              2.1 Relative Cell Reference
              2.2 Absolute Cell Reference
              2.3 Using Text Functions
                    Left Function
                    Upper Function
                   Concatenating the text values
             2.4 Date Functions         
                  Using Today Function
                  Calculating using Date Function
             2.5 Using Sum Functions
             2.6 Using CountA Functions

 Lesson 3: Working with Range Names in MS Excel 2010
            3.1 Using Range Names
            3.2 Creating Range Names
            3.3 Using Range Names in Formulas
            3.4 Creating Range Names from Headings
            3.5 Deleting Range Names
            3.5 Creating 3-D Range Names 

Lesson 4: Using Advanced Functions in Excel 2010    
            4.1 Using If Functions
            4.2 Using Nested If Functions
            4.3 Using Sum If Functions
            4.4 Using Count If Functions
            4.5 Using Vlookup Functions
            4.6 Using HLOOKUP Functions 

Lesson 5: Managing Tables using Microsoft Excel 2010
            5.1 Creating Tables
            5.2 Naming the Table
            5.3 Changing the Table Style
            5.4 Creating a Total Row
            5.5 Creating a calculated column
            5.6 Using Filtering in Table
            5.7 Removing the Duplicate Record 

Lesson 6: Using Auto Filter in Excel 2010   
            6.1 Sorting Data   
            6.2 Using AutoFilter
            6.3 Creating a Custom AutoFilter
            6.4 Using Advanced Filter
            6.5 Using Database Functions     

Lesson 7: Getting Most from your Data using Microsoft Excel 2010
            7.1 Creating Subtotal
            7.2 Using Automatic Outline
           7.3 Grouping Data Manually
           7.4 Using Data Validation 

Lesson 8: Working with Charts in Excel
          8.1 Creating a Chart
          8.2 Formatting the Chart
          8.3 Adding Labels
          8.4 Changing the Chart Type
          8.5 Changing the Data Source
          8.6 Changing the Chart Location 

Lesson 9: Creating/Revising Pivot Tables in Excel 2010
           9.1 Creating a PivotTable Report
           9.2 Selecting a Report Filter Field Item
           9.3 Refreshing a PivotTable Report
           9.4 Changing the Summary Function
           9.5 Adding New Fields to a PivotTable Report
           9.6 Moving PivotTable Report Fields
           9.7 Using Expand and Collapse Buttons
           9.8 Hiding/Unhiding PivotTable Report Items
           9.9 Inserting Slicers
           9.10 Using Slicers to Filter Data
           9.11 Deleting PivotTable Report Fields
           9.12 Creating Report Filter Pages
           9.13 Formatting a PivotTable Report
           9.14 Creating a PivotChart Report
           9.15 Exercise - Creating/Revising PivotTables

 Lesson 10: Creating and Using Shared Workbooks using Excel 2010
            10.1 Sharing a Workbook
            10.2 Opening and Editing a Shared Workbook
            10.3 Tracking Changes
            10.4 Resolving Conflicts in a Shared Workbook

Lesson 11: Working with Worksheet Protection
            11.1 Protecting your Worksheets
            11.2 Protecting range with password
            11.3 Protecting your Workbook
            11.4 Protecting your Excel Files

Lesson 12: Working with Multiple Workbooks in Excel 2010
            12.1 Linking Workbooks
            12.2 Editing the Link
            12.3 Consolidating Workbook 

Lesson 13: Working with Macros in Excel 2010
            13.1 Display the Developers Tab
            13.2 Changing Macro Security Setting  
            13.3 Running a Macro
            13.4 Recording a Macro    
            13.5 Deleting a Macro

To Register for Microsoft Excel 2010 Training, Simply Register Online, and book your seat today. Or send an online enquiry if you have any questions. You can call Kamini at 6296-2995.

Call Kamini at 9066-9991 or email to training@intellisoft.com.sg for any questions, or to register for the upcoming class.