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
• 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
• 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
• Introduction to Excel 2013
• Introduction to Excel 2013
• Chart Concept
• Excel Chart Concepts
• Basic Chart
• Excel Basic Charts
• Fine Tuning of Charts
• Fine-tuning of Charts in Excel
• 04 Changing Chart Options - part 1
• Chart Options
• 04 Changing Chart Options - part 2
• Format Tab
• Column and Line Chart
• Adjustment of Specific Chart Types
• 05 Format Tab Option
• 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
• Pivot Chart
• Calculator Chart
• Map Chart
• Introduction to Excel Dashbord
• Introduction to Dashboard
• Concepts of Excel Dashboard
• Creating Basic Charts
• Area and Bar Chart
• 3D Charts
• 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 129

Self-Study

### Course Status:

Active

1 - 4 hours / week

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

Related Posts: