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
      • Working Files - Download These First
      • How Advanced Does The Advanced Get?
      • 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
      • Managing Your Slices
      • Formatting Your Slices
      • 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
      • Create Your Own Ribbon
      • 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

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

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

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