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: Functions, Formulas, and Filters

Course Summary

Part 2 of 3 in the Excel 2010 series 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 course is recomme


  • +

    Course Syllabus

    ● Introduction to Formulas
        ◦ Introduction
        ◦ Formula Rules
        ◦ Order of Operations
        ◦ Examples
        ◦ Building a Formula in Excel
        ◦ Value vs. Reference
        ◦ What We Covered
    ● Total Values Simply
        ◦ Using AutoSum
        ◦ AutoSum Selection
        ◦ Average
        ◦ Max/Min
        ◦ Count Numbers
        ◦ The Auto Calculator
        ◦ What We Covered
    ● Relative, Absolute, & Named References
        ◦ Introduction
        ◦ Relative Reference
        ◦ Absolute Reference
        ◦ 3d Reference
        ◦ Naming Ranges
        ◦ Grouping Worksheets
        ◦ What We Covered
    ● Logical Functions
        ◦ Introduction
        ◦ The IF Function
        ◦ The Nested IF Function
        ◦ Using the IF and AND Functions
        ◦ What We Covered
    ● Lookup Functions
        ◦ Introduction
        ◦ VLOOKUP Function
        ◦ HLOOKUP Function
        ◦ What We Covered
    ● Combine and Separate Text
        ◦ Introduction
        ◦ Concatenate Text
        ◦ Convert Text to Columns
        ◦ What We Covered
    ● View Separate Data Simultaneously
        ◦ Introduction
        ◦ Split Screen
        ◦ Workspaces with Multiple Workbooks
        ◦ Workspaces with Multiple Worksheets
        ◦ What We Covered
    ● Sorting
        ◦ Introduction
        ◦ Quick Sort
        ◦ Custom Sort
        ◦ Subtotals
        ◦ What We Covered
    ● Filtering
        ◦ Introduction
        ◦ Auto Filter
        ◦ Number Custom Filter
        ◦ Date/Time Custom Filter
        ◦ Text Custom Filter
        ◦ Advanced Filter
        ◦ What We Covered

     


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