MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Excel 2010: Charts and PivotTables

Course Summary

Part 3 of 3 in the Excel 2010 series. This course will help you learn all the features in Excel 2010. You'll learn how to take advantage of the ribbon interface, utilize formulas, make references and functions, and create charts and PivotTables. This cour


  • +

    Course Syllabus

    ● Define Data as a Table
        ◦ Introduction
        ◦ Defining Data as a Table
        ◦ Adding a Total Row
        ◦ Expanding a Table
        ◦ Formatting a Table
        ◦ Convert a Table to a Range
        ◦ What We Covered
    ● Introduction to Charts
        ◦ Introduction
        ◦ What is a Chart?
        ◦ Chart Components
        ◦ Chart Types
        ◦ What We Covered
    ● Create a Column Chart
        ◦ Insert a Chart
        ◦ Change Range of Data
        ◦ Chart Design Options
        ◦ Chart Layout Options
        ◦ Chart Formatting Options
        ◦ What We Covered
    ● Create a Line Chart
        ◦ Insert a Line Chart
        ◦ Change the Data Range
        ◦ Chart Design Options
        ◦ Chart Layout Options
        ◦ Chart Formatting Options
        ◦ What We Covered
    ● Create a Pie Chart
        ◦ Insert a Pie Chart
        ◦ Choose the Chart Type
        ◦ Chart Design Options
        ◦ Chart Layout Options
        ◦ Chart Formatting Options
        ◦ What We Covered
    ● Using Sparklines
        ◦ Introduction
        ◦ Line Chart
        ◦ Sparkline Options
        ◦ Column Chart
        ◦ Win/Loss Chart
        ◦ Formatting
        ◦ What We Covered
    ● Introduction to PivotTables
        ◦ Introduction
        ◦ PivotTable Example
        ◦ What We Covered
    ● Creating a PivotTable
        ◦ Introduction
        ◦ Report Filter
        ◦ Values
        ◦ Row and Column Labels
        ◦ Styles
        ◦ Style Options
        ◦ What We Covered
    ● More Fun With PivotTables
        ◦ Introduction
        ◦ PivotTable Options
        ◦ Sorting a PivotTable
        ◦ Calculated Fields
        ◦ Show Values As
        ◦ Slicer
        ◦ What We Covered
    ● Create a PivotChart
        ◦ Introduction
        ◦ Insert a PivotChart
        ◦ Manipulate the Fields
        ◦ Field Buttons
        ◦ PivotChart Tools
        ◦ Slicer
        ◦ Create a PivotChart from a PivotTable
        ◦ What We Covered
    ● Next Steps
        ◦ Next Steps

     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top