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

Course Summary

Learn Excel 2013 and Gain command over new Powerful and advanced features and functions of Microsoft Excel 2013


  • +

    Course Syllabus

    • Introduction to Useful Excel 2013 Functions
      • Paste Special
      • Paste Special Base File
      • Logical fucnitons IF and OR
      • Logical functions - IF AND OR
      • Logical Functions Quiz - without solutions
      • Logical Functions Quiz - with solutions
      • Arithmetic Functions
      • Arithmetic functions MAX MIN ABS etc
      • Quiz Arithmetic functions - without solution
      • Quiz Arithmetic functions - with solution
      • Aggregation Functions
      • COUNT COUNTIF COUNTA COUNTBLANK
      • Aggregation Functions - COUNT, COUNTA, COUNTBLANK, COUNTIF without solu
      • Aggregation Functions - COUNT, COUNTA, COUNTBLANK, COUNTIF with solu
      • Cell Information Functions
      • Cell Information - (Without Solution)
      • Cell Information - (With Solution)
    • Data Functions
      • Choose Function
      • Vlookup
      • Hlookup and Sum product
      • Hlookup and Sum product Continues
      • Lookup Without Solution (DOWNLOAD)
      • Lookup With Solution (DOWNLOAD)
      • Match Index
      • Match & Index
      • Database Functions
      • Database function - without solution
      • Database function - with solution
      • Forecasting Function
      • Forecast function - Without Solution
      • Forecast function - With Solution
    • What If Analysis
      • One Dimensional Data Table
      • One Dimensional Data Tables
      • One Dimesional Data Tables - without solution
      • One Dimesional Data Tables - with solution
      • Two Dimensional Data Tables
      • Two Dimensional Data Tables -without solution
      • Two Dimensional Data Tables -with solution
      • Solver
      • Solver -without solution
      • Solver -with solution
      • Goal Seek
      • Goal Seek
      • Goal Seek - without solution
      • Goal Seek - with solution
    • Arrays
      • Arrays Introduction Part 1
      • Arrays Introduction Part 2
      • Array Function -Without Solution
      • Array Function -With Solution
      • Arrays Rows and Coloumns
      • Array Function - Rows & Coloumns Without Solution
      • Array Function - Rows & Coloumns With Solution
      • Arrays Transpose
      • Array Function - Transpose Without Solution
      • Array Function - Transpose With Solution
      • Arrays Frequency
      • Array Function - Frequency Without Solution
      • Array Function - Frequency With Solution
    • Functions for Working with Text
      • Text and String Functions Part 1
      • Text and String Function-Part 1 - Without Solution
      • Text and String Function-Part 1 - With Solution
      • Text and String Functions Part 2
      • Text and String Function-Part 2 - Without Solution
      • Text and String Function-Part 2 - With Solution
    • Excel 2013 - Pivot Table
      • Data Formatting
      • Creating Pivot Table
      • Recommended Data Table
      • Pivoting Pivot Table
      • External Data
      • Consolidation Sheets
      • Managing Pivot Table
      • Basics of Pivot Table Without Solution
      • Basics of Pivot Table With Solution
    • Summarizing Data Using Pivot Table
      • Totals Display
      • Summary Display
      • Multiple Data Field
      • Data Grouping
      • Drill Down Data
      • Calculated Field
      • Summarizing Data Using Pivot Table Without Solution
      • Summarizing Data Using Pivot Table With Solution
    • Data Filtering
      • Pivot Data Sorting
      • Customised Sorting
      • Limited Data Display
      • Rule Based Sorting
      • Data Slicer
      • Slicer Formatting
      • Filter Area
      • Removing Filters
      • Data Filtering Without Solution
      • Data Filtering With Solution
    • Basics Pivot Table Formatting
      • Formatting Pivot Table
      • Layouts In Pivot Table
      • Basics Pivot Table Formatting Without Solution
      • Basics Pivot Table Formatting With Solution
    • Advanced Pivot Table Formatting
      • Rule Based Conditional Formatting
      • Top Bottom Rule Based
      • Data Bars
      • Adding Color Scales
      • Icon Indicators
      • Conditional Formatting
    • Introduction of Pivot Chart
      • Basic Pivot Chart
      • Pivoting Pivot Chart
      • Filter Pivot Chart Data
      • Formatting Pivot Chart
      • Different Chart Types
      • Pivot Chart without Solution
      • Pivot Chart with Solution
    • How to Print the Pivot Table
      • Print Table Part 1
      • Print Table Part 2
      • Print Separate
      • Print Headers
      • Printing Table With Headers
      • Print Table
    • Using Macros In Pivot Tables
      • First Macro
      • Executingthe Macro
      • Using Macros In Pivot Tables Without Solution
      • Using Macros In Pivot Tables With Solution
    • Introduction of Power Pivot
      • Starting With Power Pivot
      • Why Use Power Pivot
      • Adding Table To Power Pivot
      • Creating Relationships Between Tables
      • Pivot TableIn Power Pivot
      • Get External DataIn Power Pivot
      • Introduction of Power Pivot Without solution
      • Introduction of Power Pivot With solution
    • DAX in Power Pivot
      • Introduction To DAX
      • Reference To Dax Functions
      • Adding Calculated Column
      • Adding Calculated Field
      • ​Power Pivot Calculated Field Without Solution
      • ​Power Pivot Calculated Field With Solution
      • Power Pivot Calculated Column with solution
    • Introduction of Power View
      • Introduction To Power View
      • Displaying Data Using Different Controls Part 1
      • Displaying Data Using Different Controls Part 2
      • Formatting Of Controls
      • Filters In Power View
      • Data Display Using Charts In Power View
      • Data Display Using Maps
      • Introduction of Power View Without Solution
      • Introduction of Power View With Solution
    • Names and Dynamic Range
      • Naming a Cell and a Range
      • Naming a Cell and a Range - Without Solution
      • Naming a Cell and a Range - With Solution
      • Naming Dynamic Ranges
      • Naming Dynamic Ranges - Without Solution
      • Naming Dynamic Ranges - With Solution
    • Auditing and Trouble Shooting Formulas
      • Auditing Toolbars
      • Auditing Toolbar Base file
      • Watch Window
      • Watch window base file
    • Important Excel Tools
      • Text to Columns
      • Text Columns - without solution
      • Text to Columns - with solution
      • Grouping Tabs
      • Grouping Tabs - Without Solution
      • Grouping Tabs - With Solution
      • Subtotal Function
      • Subtotal function- Without Solution
      • Subtotal function- With Solution
      • Hyperlinks
      • Hyperlinks Base File
      • Data Validation Part 1
      • Data Validation Part 2
      • Data Validation - Without Soulution
      • Data Validation - With Soulution
      • Random Numbers
      • Random Numbers- Without Solution
      • Random Numbers- With Solution
      • Custom View
      • Custom View - Without Solution
      • Custom View - With Solution
      • Protecting Worksheet and Workbook
      • Protecting - Worksheet and workbook - Without Solution
      • Protecting - Worksheet and workbook - With Solution
    • Excel 2013 - Charts & Graphs
      • Introduction to Excel 2013 Charts and Graphs
    • Chart Concept
      • Excel Chart Concepts
      • ​Chart Concepts 2013 Without Solution
      • Chart Concepts 2013 With Solution (DOWNLOAD)
    • Basic Chart
      • Excel Basic Charts
      • Chart Building 2013 Without Solution
      • Chart Building 2013 With Solution (DOWNLOAD)
    • Fine Tuning of Charts
      • Fine-tuning of Charts in Excel
    • Chart Options
      • Changing Chart Options - part 1
      • Changing Chart Options - part 2
      • Chart Options 2013 Without Solution (DOWNLOAD)
      • Chart Options 2013 With Solution (DOWNLOAD)
    • Format Tab
      • Format Tab Option
    • Adjustment of Specific Chart Types
      • Column and Line Chart
      • Pie Diagram
      • Area Chart
      • Doughnut, Bubble and Radar Chart
      • Specific Chart Types 2013 Without Solution (DOWNLOAD)
      • Specific Chart Types 2013 With Solution (DOWNLOAD)
    • Changing Chart Sources
      • Paste Chart Data
      • Multiple Source Data and Table Chart
      • Basic Dynamic Chart
      • Chart Sources 2013 Without Solution (DOWNLOAD)
      • Chart Sources 2013 With Solution (DOWNLOAD)
    • Specialised Charts & Graphs
      • Dynamic Chart with Check boxes
      • Dynamic Pie Chart
      • Pareto Chart
      • Frequency Chart
      • Chart Filter
      • Gantt Chart
      • Advanced Dynamic Chart
      • Calculator Chart
      • Pivot Chart
      • Map Chart
      • Specialized Charts & Graphs 2013 Without Solution (DOWNLOAD)
      • Specialized Charts & Graphs 2013 With Solution (DOWNLOAD)
    • Excel 2013 - Excel Dashboard
      • Introduction to Dashboard
      • Concepts of Excel Dashboard
    • Creating Basic Charts
      • 3D Charts
      • Area and Bar Chart
      • Combination Charts
      • Different Typs
      • Types of Charts Without Solution (DOWNLOAD)
      • Types of Charts With Solution (DOWNLOAD)
    • Learning Pivot Table, Pivot Chart and Slicer
      • Pivot Table
      • Pivot Chart and Slicer
      • Pivot Charts and Slicer New Without Solution (DOWNLOAD)
      • Pivot Charts and Slicer New With Solution (DOWNLOAD)
    • Using Form Controls
      • Checkbox
      • Check and Scroll 1
      • Scroll Chart
      • Check and Scroll Without Solution (DOWNLOAD)
      • Check and Scroll With Solution (DOWNLOAD)
    • Basic Macros
      • Basic Macro Part 1
      • Macro Example Without Solution (DOWNLOAD)
      • Macro Example With Solution (DOWNLOAD)
    • Assigning Macros to Buttons to Navigate and Dashboard
      • Basic Macro Part 2
      • Macro Navigation
      • Dashboard End
      • Macro chart Example and Navigation Without Solution (DOWNLOAD)
      • Macro Chart Example With solution (DOWNLOAD)
      • Macro Navigation With Solution (DOWNLOAD)
    • Financial functions using Excel
      • Introduction
    • Future Value, SI, CI, PV, NPER, RATE
      • DOWNLOAD Course Materials
      • Understanding Future Value
      • Future Value Continues
      • Calculating Simple and compound Interest
      • SI and CI Continues
      • Understanding PV
      • Calculate NPER and RATE
      • Lender and Borrower FV


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

Related Posts:

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