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

# Microsoft Excel 2010: Advanced Training

### Course Summary

Master Advanced Excel 2010 Features. Become A Expert And Learn To Use Excel Like A Pro With This Advanced Excel Training

• +

### Course Syllabus

• Getting Started With This Excel Course
• Using The Included Excel Files
• How to obtain your Certificate of Completion.
• New In Excel 2010 - The Sparkline
• The Excel IF Function
• The Syntax Of IF
• Nesting The IF Statement In Excel
• Use The AND Operator To Reduce Quantity Of Nested IFs
• Use The OR Operator To Reduce Quantity Of Nested IFs
• The NOT Operator Within AND And OR Statements
• SUMIF For Selective Adding Up
• COUNTIF For Selective Counting
• AVERAGEIF For The Mean Of Cells That Meet Our Criteria
• Multiple Criteria Within The Same SUM AVERAGE And COUNT Functions
• Performing Lookup in Excel
• VLOOKUP Explained
• Applied Examples for VLOOKUP
• HLOOKUP Explained
• HLOOKUP In Action
• Looking For A Near Match In A Lookup
• Checking For Missing Data In A Lookup
• Extending The Size Of A Lookup Table
• Nested LOOKUPs In Excel
• Excel Data Functions
• The MATCH Function Explained
• The INDEX Function Syntax
• How To Stop Nonexistent Row Or Column Lookups In INDEX
• The CHOOSE Lookup Function
• Excel Math Functions
• Working With TIME
• Rounding To Fractional Values
• MOD For Working Out Remainders
• Generating A Random Number
• Pick A List Item At Random
• Calculating Loan Repayments Using PMT
• Excel - Investment Calculations Using PMT
• Working Out Depreciation
• Working Out Different Parts Of A Loan Calculation
• Arrays In Excel
• What Is An Array And An Array Formula
• Creating And Using An Array Formula
• Conditional Evaluation In An Array Formula
• The Very Clever TRANSPOSE Array Function
• Excel Functions For Working With Text
• LEN And TRIM Two Very Useful Text Functions
• Using LEFT And RIGHT For String Extraction
• FIND And MID Working Together To Extract Parts Of Strings
• Build Strings From Multiple Cells
• Excel - Changing The Case Of Text In Cells
• REPLACE And SUBSTITUTE In Action
• Formatting Numeric Values With A Text String Using TEXT
• Extracting The Values From The Text Functions We Have Used
• Other Useful Excel Functions
• Welcome To IS Functions
• Error Checking With ISERR ISERROR ISNA And IFERROR
• The OFFSET Formula Explained
• Dynamic Named Ranges Using The OFFSET Function
• Use The INDIRECT Function To Build Dynamic Formulas
• Dealing With INDIRECT Errors
• Use Formulas To Determine An Excel Filename And Or Sheet Name
• Sparklines
• Creating A Sparkline In Excel
• Change The Design Of Sparklines
• Dealing with Empty Cells
• Comparing One Sparkline To Another by Altering Vertical Scale
• Removing Sparklines From A Sheet
• Outlining
• Outlining Explained
• Creating An Outline Automatically
• Creating An Outline Manually
• Manually Removing Data From An Outline
• Removing The Outlining From A Worksheet
• Adjusting A Grouping Created By Automatic Outlining
• Custom Views In Excel
• Creating A Custom View Of A Worksheet
• Changing From One Custom View To Another
• Editing A Custom View
• How To Delete A Custom View
• Scenario
• Setting Up A Scenario And Entering Values
• Display The Scenario Values
• Editing The Values Of A Scenario
• Deleting A Scenario
• Merge Scenarios From Different Sheets
• Getting A Summary Of All Scenarios
• Auditing And Troubleshooting Formulas
• Description Of Tracer Arrows
• Tracing Precedents And Dependents
• Remove Tracer Arrows
• Error Checking Using Auditing Tools
• Step By Step Processing Of Formula To Help With Troubleshooting
• Excel - Utilizing The Watch Window
• Pivot Tables In Excel
• What Is A Pivot Table
• Steps To Create A Pivot Table In Excel
• Rearranging Fields In A Pivot Table
• Changing The Math Of The Data Summary
• Number Format Control Of The Summary Area
• Creating A Second (Or More) Pivot Table On The Same Data
• Moving A Pivot Table
• Removing A Pivot Table
• Making Use Of The Report Filter Option
• Sorting A Pivot Tables Columns
• Displaying Values As A Percentage
• Refreshing A Pivot Table Manually Or Semi-Automatically
• Drilling Down Behind The Pivot Table Summaries
• Applying Pivot Table Styles
• Creating Your Own Custom Pivot Table Style
• Copying A Pivot Table Style Between Workbooks
• Using More Than One Field In Row And Column Headings
• Disabling And Enabling Grand And Sub Totals
• Filtering Columns And Rows Within A Pivot Table
• Dealing With Empty (NULL) Cells
• Exploring The Additional Pivot Table Options
• Introducing The Slicer Tool
• Connecting A Pivot Table To SQL Server
• External Connection Refresh Rate And Password Saving
• Excel Pivot Charts
• Creating A Pivot Chart
• Altering Chart Types Formats And Layouts
• Advanced Layout Control Of A Pivot Chart
• Filtering A Pivot Chart
• Hiding Pivot Chart Elements
• Moving A Pivot Chart Between Sheets
• Deleting A Pivot Chart (With Care)
• Goal Seek And Solver
• Using Goal Seek To Carry Out What If Analysis
• Using SOLVER To Carry Out What if Analysis
• Excel - Activating The SOLVER Add In
• Add Constraints Into A SOLVER Problem
• Alberts Cafe Solver Solution
• Macros In Excel
• What Is A Macro
• Creating Storing And Running Your First Macro
• Using Relative Or Absolute Referencing During Recording
• Saving Workbooks With Macros Issues
• Opening Files Containing Macros
• The PERSONAL Workbook
• How To Delete Macros
• Use A Macro For Formatting
• Trigger A Macro With A Keyboard Shortcut
• Using Form Buttons To Trigger Macros
• Customizing The Form Buttons In Excel
• Assigning Macros To Ribbon Icons
• Remove Options From Ribbons
• View And Edit Macro Code
• Add A Confirmation Dialog Box To Macros
• How To Get The Excel Working Files

Course Fee:
USD 99

Self-Study

### Course Status:

Active

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts: