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
• 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
• Rule Based Conditional Formatting
• Top Bottom Rule Based
• Data Bars
• 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 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
• ​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
• 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
• Basic Chart
• Excel Basic Charts
• Chart Building 2013 Without Solution
• Fine Tuning of Charts
• Fine-tuning of Charts in Excel
• Chart Options
• Changing Chart Options - part 1
• Changing Chart Options - part 2
• Format Tab
• Format Tab Option
• Adjustment of Specific Chart Types
• Column and Line Chart
• Pie Diagram
• Area Chart
• Doughnut, Bubble and Radar Chart
• Changing Chart Sources
• Paste Chart Data
• Multiple Source Data and Table Chart
• Basic Dynamic Chart
• Specialised Charts & Graphs
• Dynamic Chart with Check boxes
• Dynamic Pie Chart
• Pareto Chart
• Frequency Chart
• Chart Filter
• Gantt Chart
• Calculator Chart
• Pivot Chart
• Map Chart
• Excel 2013 - Excel Dashboard
• Introduction to Dashboard
• Concepts of Excel Dashboard
• Creating Basic Charts
• 3D Charts
• Area and Bar Chart
• Combination Charts
• Different Typs
• Learning Pivot Table, Pivot Chart and Slicer
• Pivot Table
• Pivot Chart and Slicer
• Using Form Controls
• Checkbox
• Check and Scroll 1
• Scroll Chart
• Basic Macros
• Basic Macro Part 1
• Assigning Macros to Buttons to Navigate and Dashboard
• Basic Macro Part 2
• Dashboard End
• Financial functions using Excel
• Introduction
• Future Value, SI, CI, PV, NPER, RATE
• 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

Self-Study

### Course Status:

Active

1 - 4 hours / week

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

Related Posts: