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

Self-Study

Active