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 2013 Advanced. Online Excel Training Course

Course Summary

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


  • +

    Course Syllabus

    • Getting Started
      • Working Files - Download These First
      • 0101 Will I Be Able To Keep Up?
      • 0102 Using The Included Files
      • 0103 New For 2013: Its All In The Cloud
      • 0104 The Very Clever Flash Fill
    • Using Mathematical Functions
      • 0201 The Basic SUM, COUNT, MIN, And MAX
      • 0202 AVERAGE, MODE, MEAN, And MEDIAN
      • 0203 SUMIF For Selective Adding Up
      • 0204 COUNTIF For Selective Counting
      • 0205 AVERAGEIF For The Mean Of Selected Cells
      • 0206 Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF
      • 0207 Area And Volume Calculations
    • IF Functionality
      • 0301 IF Syntax And Uses
      • 0302 Nesting The IF Statement
      • 0303 Use Of The AND Operator Within An IF
      • 0304 Use Of The OR Operator Within An IF
      • 0305 The NOT Operator Within AND And OR Statements
      • 0306 Display Cell Formulas In Another Cell
    • Performing Data Lookups
      • 0401 VLOOKUP: Syntax And Usage
      • 0402 VLOOKUP In Live Action
      • 0403 HLOOKUP: Variation On A Theme
      • 0404 Using A Near Match In The Lookup
      • 0405 Dealing With Missing Data In A Lookup
      • 0406 Managing The Lookup Table
      • 0407 Lookups Nested Within Lookups
    • Sparklines
      • 0501 Creating A Sparkline
      • 0502 Altering The Design Of Sparklines
      • 0503 Dealing With Empty Cells
      • 0504 Comparing Sparklines Within A Sparkline Group
      • 0505 Removing Sparklines From A Worksheet
    • Further Mathematical Functions
      • 0601 Working With Time In Excel
      • 0602 Calculations Using Time
      • 0603 Useful Time And Date Functions
      • 0604 Rounding Decimal Places
      • 0605 MOD And INT Functions And Uses
      • 0606 Generate And Use A Random Number
      • 0607 Loan And Investment Calculations
      • 0608 Loan Calculation Elements And Functions
    • Outlining
      • 0701 Create An Outline Automatically
      • 0702 Adding An Outline Manually
      • 0703 Editing And Removing Outlining
    • Scenarios
      • 0801 Setting Up A Set Of Scenarios
      • 0802 Displaying And Editing The Different Scenarios
      • 0803 How To Work Out Which Scenario You Are Displaying
      • 0804 Merging And Deleting Scenarios
      • 0805 Producing A Summary Of Scenarios
    • Custom Views
      • 0901 Custom Views Explained
      • 0902 Use Of Outlining To Help Setup Custom Views
      • 0903 Editing And Deleting Custom Views
      • 0904 Add Quick Access To Custom Views
    • Functions For Manipulating Text
      • 1001 LEFT And RIGHT: Text Manipulation
      • 1002 LEN And TRIM: String Extractions
      • 1003 FIND And MID: Text Functions Working Together
      • 1004 CONCATENATE: Building Strings From Multiple Cells
      • 1005 Changing Case Functions
      • 1006 REPLACE And SUBSTITUTE: Two More String Manipulation Functions
      • 1007 Use Of CHAR Function For More Obscure Characters
      • 1008 Formatting Numeric And Date Values Using TEXT
      • 1009 Keeping The Values Created By String Manipulation
    • Arrays
      • 1101 Arrays And Creating A New Array Formula
      • 1102 Array Formulas With IF Statements
      • 1103 Conditional Evaluation With No IFs
      • 1104 The Array-Only TRANSPOSE Function
    • Useful Data Functions
      • 1201 Using The MATCH Function
      • 1202 How The INDEX Function Works
      • 1203 Handling Out Of Range Index Requests
      • 1204 The CHOOSE Lookup Function
      • 1205 MATCH And INDEX Functions Working Together
    • Some Other Useful Functions
      • 1301 Introducing IS Functions
      • 1302 Error Checking Using ISERR, ISERROR, And IFERROR
      • 1303 OFFSET Function Syntax
      • 1304 OFFSET Function: Creating A Dynamic Named Range
      • 1305 INDIRECT Function To Build Dynamic Formulas
      • 1306 Dealing With INDIRECT Errors
      • 1307 The CELL Function And Determining File Or Sheet Names
    • Auditing And Troubleshooting Formulas
      • 1401 What Are Tracer Arrows
      • 1402 Adding And Removing Tracer Arrows
      • 1403 Auditing Tools: Error Checking And Tracing
      • 1404 Step-By-Step Formula Processing
      • 1405 Using The Watch Window In Troubleshooting
    • PivotTables
      • 1501 What Is A PivotTable?
      • 1502 The New Recommended PivotTable Route
      • 1503 Creating Your Own PivotTables
      • 1504 Changing The Formatting And Formulas In PivotTable Summaries
      • 1505 Creating Multiple PivotTables On The Same Dataset
      • 1506 Moving And Deleting PivotTables
      • 1507 Making Use Of The Report Filter Options
      • 1508 Sorting The PivotTable Columns
      • 1509 Refreshing A PivotTable
      • 1510 Drilling Down Behind The Pivot Numbers
      • 1511 Multiple Fields In Row, Column, Or Data Sections
      • 1512 Controlling Grand Totals And Subtotals
      • 1513 Dealing With Empty Cells And Other Additional Options
      • 1514 PivotTable Styles
      • 1515 Creating Your Own PivotTable Styles
      • 1516 Creating And Using Calculated Fields
      • 1517 Using The New Timeline Filter Option
      • 1518 Adding And Using The Data Slicer
      • 1519 Using Data From An SQL Server In A PivotTable
      • 1520 Managing The External Connection To SQL Server
    • PivotCharts
      • 1601 Creating A PivotChart
      • 1602 Changing The Fields Used In A PivotChart
      • 1603 Formatting The PivotChart
      • 1604 Changing The PivotChart Type
      • 1605 Filtering A PivotChart
      • 1606 Hiding The PivotChart Buttons
      • 1607 Moving And Deleting PivotCharts
    • Goal Seek And Solver
      • 1701 What-If Analysis Using Goal Seek
      • 1702 Activating The Solver Add-In
      • 1703 Using Solver To Complete A What-If
      • 1704 Adding Constraints To Solver
    • Macros
      • 1801 What Is A Macro
      • 1802 Creating And Running Your First Macro
      • 1803 Saving Workbooks With Macros
      • 1804 Macro Security Settings For Workbooks With Macros
      • 1805 The Personal Macro Workbook
      • 1806 Deleting Macros
      • 1807 Use Of Relative Or Absolute Referencing
      • 1808 Trigger A Macro With A Keyboard Shortcut
      • 1809 Formatting With A Macro
      • 1810 Switch Scenarios And Views With Macros
      • 1811 Use Of Worksheet Buttons To Trigger Macros
      • 1812 Customizing Form Buttons And Other Shape Triggers
      • 1813 Assigning Macros To Ribbon Icons
      • 1814 Create Your Own Ribbon
      • 1815 View And Edit Macro Code
      • 1816 Add An Are You Sure Box To Macros
    • Summary And Credits
      • 1901 Course Summary: What Have We Learned In This Course


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