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 for Business - Learn Excel Online

### Course Summary

This Online course on Microsoft Excel will make you awesome in Excel Features, Functions and Charts.

• +

### Course Syllabus

• Excel - Overview
• Excel - Overview
• Getting Started
• Excel Overview Notes
• Formatting a Spreadsheet
• Use Paste Special Effectively
• Check Boxes
• Comments
• Comments
• Group Boxes And Options Button
• Grouping Tabs
• List Boxes And Combo Boxes
• Print Setup Options
• Auditing Features
• Arrays Notes
• Scroll Bar And Spinners
• Subtotals
• Text To Column
• Getting Started
• Date & Time
• Date Functions Notes
• Day Date Datedif Networkdays PART 1
• DAYS FUNCTIONS PART 2
• Date & Time
• Text & Data
• String Functions Notes
• Text And String
• Text & Data
• Filter, Sort & Conditional Formating
• Data Filters Notes
• Auto Filter
• Sorting Notes
• Conditional Formatting
• Filter Sort & Conditional Format
• Formatting Data
• Formatting Notes
• Formatting Data
• Cell Information
• Cell Information
• Cell Information
• Validating Data
• Validating Data
• Validating Data
• Pivot Table
• Pivot Tables
• Pivot Table
• Pivot Table
• Logical
• Logical Functions Notes
• And OR IF
• Logical
• Mathematics & Statistics
• Aggregation Function Notes
• Arithmetic Function Notes
• ABS LARGE MAX MIN SMALL
• Count Countif Count A Countblank
• Forecast Function
• Mathematics & Statistics
• Database Function
• Database Functions Notes
• Database Function Part 1,2
• Database Function
• Lookup & Reference
• Choose Function Notes
• CHOOSE Function
• HLOOKUP Notes
• HLOOKUP
• Hyperlinks
• Match Notes
• MATCH And INDEX
• OFFSET Function
• Example of OFFSET Function
• Vlookup Notes
• VLOOKUP Function
• Lookup & Reference
• Basic Charting for Business analysts
• Adding an Average
• Combo Charts
• Bar To Pie Charts
• Histogram
• Delta Charts
• Invert Negative In Chart
• Dynamic Chart Labels
• Scrolling Chart
• Thermometer Chart
• Basic Charting For Business Analysts
• Quiz 1
• Quiz 2
• Advance Charting for Business analysts
• Funding Graphs Notes
• Funding Graph
• Range Charts Notes
• Area Range Charts Notes
• Range Chart
• Continuation of Range Chart
• Range Charts Version 2
• Continuation of Range Charts Version 2
• Scenario Graphs Notes
• Setting Up Scenario Graph
• Continuation of Setting Up Scenario Graph
• Two Axis Graph Notes
• Learning of Two Axis Graph
• Advance Charting For Business Analysts
• What if Analysis
• Goal Seek
• Data Tables Notes
• One Dimensional Data Tables
• Two Dimensional Data Tables
• Solver
• Watch Window
• What If Analysis
• Quiz 3
• Quiz 4
• Security & Privacy
• Protecting Worksheet
• Security & Privacy
• Concluding Lecture
• Concluding Lecture

Course Fee:
USD 99

Self-Study

Active

### Workload:

1 - 4 hours / week

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

Related Posts:

## Microsoft Excel

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