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 Course - Online Excel Basic & Advanced

### Course Summary

Start from scratch and Gain command over Advanced and Powerful features and functions of Microsoft Excel 2013

• +

### Course Syllabus

• Overview
• Overview
• Getting Started
• Opening Excel
• Familiarity with excel interface and Ribbons
• Surfing an excel worksheet and How to use HELP in MS Excel
• Case Study
• Case Study
• XYZ Company Basic Excel Case Study
• Data Entry
• Data entry in excel
• Populating the Case Study in Excel
• Populating the Case Study in Excel
• populating case study in excel (without solution)
• populating case study in excel (with solution)
• Calculations
• Calculations
• Calculations (without solution)
• Calculations (with solution)
• Formulas
• Formulas - part 1
• Formulas - part 2
• Formulas (without solution)
• Formulas (with solution)
• Formatting
• Formatting Number formats
• Formatting - Number Formats (without solution)
• Formatting - Number Formats (with solution)
• Formatting Table formats
• Formatting Table formats
• Formatting - Table Formats (without solution)
• Formatting - Table Formats (with solution)
• Updating a Calculation
• Updating a Calculation
• updating a calculation (without solution)
• updating a calculation (with solution)
• Percentages & Absolute References
• Percentages and Absolute References
• percentage & asbsolute refernces(without solution)
• percentage & asbsolute refrences (with solution)
• Conditional Formatting
• Conditional Formatting
• Conditional formatting (without solution)
• Conditional formatting (with solution)
• IF Function
• IF Function
• if function (without solution)
• if function (with solution)
• COUNTIF
• COUNTIF
• count if (without solution)
• count if (with solution)
• SUMIF
• SUMIF
• SUMIF (without solution)
• SUMIF (with solution)
• Graphs & Charts
• Graphs and Charts Part 1
• Graphs and Charts Part 2
• Graphs and Charts Part 3
• Graphs & Charts (without solution)
• Graphs & Charts (with solution)
• Pie Chart
• Pie Chart
• Create Pie Chart (without solution)
• Create Pie Chart (with solution)
• Sorts
• Sort function
• Sort (without solution)
• Sort (with solution)
• Filter Function
• Filter Function
• Filter (without solution)
• Filter (with solution)
• Pivot table
• Pivot table Part 1
• Pivot table Part 2
• Pivot table (without solution)
• Pivot table (with solution)
• Freeze & Split
• Freeze and Split
• Freeze panes (without solution)
• Freeze panes (with solution)
• Split (without solution)
• Split (with solution)
• Presentation
• Table Formats
• Presentation table format (without solution)
• Presentation table format (with solution)
• Indents and Formatting Charts
• Indents and Formatting Charts (without solution)
• Indents and Formatting Charts (with solution)
• Print
• Printing the Worksheet
• Print Layout
• Printing the Worksheet (without solution)
• Printing the Worksheet (with solution)
• Print Layout (without solution)
• Print Layout (with solution)
• Shortcuts
• Shortcuts Part 1
• Shortcuts Part 2
• Shortcuts Part 3
• Shortcuts Part 4
• Shortcuts Part 5
• Shortcuts Part 6
• Excel Shortcuts
• Common errors
• Common errors
• 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 solution
• Aggregation Functions - COUNT, COUNTA, COUNTBLANK, COUNTIF with solution
• Cell Information Functions
• Cell Information - (Without Solution)
• Cell Information - (With Solution)
• Data Functions Dashboard Course
• Choose Function
• Vlookup
• Hlookup and Sum product
• Hlookup and Sum product Continues
• Lookups Without Solution (DOWNLOAD)
• Lookups 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
• Basics of 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
• Introduction to Excel 2013
• Introduction to Excel 2013
• Chart Concept
• Excel Chart Concepts
• Chart Concepts 2013 Without Solution (DOWNLOAD)
• Chart Concepts 2013 With Solution (DOWNLOAD)
• Basic Chart
• Excel Basic Charts
• Chart Building 2013 With Solution (DOWNLOAD)
• Chart Building 2013 Without Solution (DOWNLOAD)
• Fine Tuning of Charts
• Fine-tuning of Charts in Excel
• 04 Changing Chart Options - part 1
• Chart Options
• 04 Changing Chart Options - part 2
• Chart Options 2013 With Solution (DOWNLOAD)
• Chart Options 2013 Without Solution (DOWNLOAD)
• Format Tab
• Column and Line Chart
• Adjustment of Specific Chart Types
• 05 Format Tab Option
• Pie Diagram
• Area Chart
• Doughnut, Bubble and Radar Chart
• Specific Chart Types 2013 With 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 With Solution (DOWNLOAD)
• Chart Sources 2013 Without Solution (DOWNLOAD)
• Specialised Charts & Graphs
• Dynamic Chart with Check boxes
• Dynamic Pie Chart
• Pareto Chart
• Frequency Chart
• Chart Filter
• Gantt Chart
• Advanced dynamic chart
• Pivot Chart
• Calculator Chart
• Map Chart
• Specialized Charts & Graphs 2013 With Solution (DOWNLOAD)
• Specialized Charts & Graphs 2013 Without Solution (DOWNLOAD)
• Introduction to Excel Dashbord
• Introduction to Dashboard
• Concepts of Excel Dashboard
• Creating Basic Charts
• Area and Bar Chart
• 3D Charts
• 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 129

Self-Study

Active

### Workload:

1 - 4 hours / week

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

Related Posts:

## Power View

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