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 - Excel Course (Basic and Advanced)

Course Summary

This excel training covers both basic excel and advanced excel tutorial


  • +

    Course Syllabus

    • INTRODUCTION
      • Introduction
    • EXCEL 2010: GETTING STARTED
      • All Working Files Basic Excel - Download These First
      • All Working Files Advanced Excel - Download These First
      • Getting Started - Ribbons & Quick Access Toolbar
      • Getting Started - Ribbons & Quick Access Toolbar
      • Getting Started - Surfing Excel & HELP Function
      • Getting Started - Surfing Excel & HELP Function
    • CASE STUDY
      • XYZ Company Basic Excel Case Study
      • Excel Case Study
      • Excel Case Study
      • Data Entry in Excel
      • Data Entry in Excel
      • Populating the Case Study in Excel
      • Populating the Case Study in Excel
    • CALCULATIONS
      • Calculations - Addition Subtract Multiply Division
      • Calculations - Addition Subtract Multiply Division
    • FORMULAS
      • Formulas - SUM MAX MIN AVERAGE
      • Formulas - SUM MAX MIN AVERAGE
    • FORMATTING
      • Formatting - Number Formats
      • Formatting - Number Formats
      • Formatting - Table Formats
      • Formatting - Table Formats
    • UPDATING A CALCULATION
      • Updating a Calculation
      • Updating a Calculation
    • PERCENTAGES & ABSOLUTE REFERENCES
      • Percentages and Absolute References
      • Percentages and Absolute References
    • CONDITIONAL FORMATTING
      • Conditional Formatting
      • Conditional Formatting
    • IF FUNCTION
      • IF Function
      • IF Function
    • COUNTIF AND SUMIF
      • COUNTIF Function
      • COUNTIF Function
      • SUMIF Function
      • SUMIF Function
    • CHARTS AND GRAPHS
      • Creating Charts and Graphs
      • Creating Charts and Graphs
      • Create Pie Charts
      • Create Pie Charts
    • SORTS AND FILTERS
      • Sorts
      • Sorts
      • Filter
      • Filter
    • FREEZE AND SPLIT
      • Freeze and Split
    • PRESENTATION
      • Presentation - Table Formats
      • Presentation - Table Formats
      • Presentation - Indents and Formatting Charts
      • Presentation - Indents and Formatting Charts
    • PRINT
      • Printing the Worksheet
      • Printing the Worksheet
      • Printing - Headers and Titles
      • Printing - Headers and Titles
    • SHORTCUTS
      • Shortcuts - Formatting and Navigation
      • Shortcuts - Formatting and Navigation
      • Shortcuts - Selection, Data and Formula
      • Shortcuts - Selection, Data and Formula
    • COMMON ERRORS
      • Common Errors
      • Common Errors
    • KEY DIFFERENCE MS EXCEL 2007 VS 2010
      • Office Button and Paste Function
      • Office Button and Paste Function
      • Sparklines, Custom Ribbons and Screenshots
      • Sparklines, Custom Ribbons and Screenshots
      • Conditional Formatting and Equation Editor
      • Conditional Formatting and Equation Editor
    • USEFUL EXCEL FUNCTIONS
      • Paste Special
      • Paste Special
      • Logical functions IF AND OR
      • Logical functions IF AND OR
      • Logical Functions Quiz - without solutions
      • Logical Functions Quiz - with solutions
      • Logical functions IF AND OR
      • Arithmetic functions MAX MIN ABS etc
      • Arithmetic functions MAX MIN ABS etc
      • Arithmetic functions MAX MIN ABS etc
      • COUNT COUNTIF COUNTA COUNTBLANK
      • COUNT COUNTIF COUNTA COUNTBLANK
      • COUNT COUNTIF COUNTA COUNTBLANK
      • Cell Information ISERROR ISBLANK etc
      • Cell Information ISERROR ISBLANK etc
    • DATA FUNCTIONS
      • CHOOSE Function
      • CHOOSE Function
      • CHOOSE Function
      • VLOOKUP Function
      • VLOOKUP Function
      • VLOOKUP Function
      • HLOOKUP Function
      • HLOOKUP Function
      • HLOOKUP Function
      • MATCH INDEX
      • MATCH INDEX
      • MATCH INDEX
      • Database functions DSUM DAVERAGE DCOUNT
      • Database functions DSUM DAVERAGE DCOUNT
      • Database functions DSUM DAVERAGE DCOUNT
      • OFFSET Function- Understanding basics
      • OFFSET Function - Dynamic nature
      • FORECAST Function
      • FORECAST Function
    • WHATIF ANALYSIS
      • One Dimensional Data Tables
      • One Dimensional Data Tables
      • One Dimensional Data Tables
      • Two dimensional Data Tables
      • Two dimensional Data Tables
      • Solver
      • Solver
      • Goal Seek
      • Goal Seek
      • Goal Seek
    • ARRAYS
      • Array Function Introduction
      • Array Function Introduction
      • Array Function Row and Columns
      • Array Function Row and Columns
      • Array Function TRANSPOSE
      • Array Function TRANSPOSE
      • Array Function FREQUENCY
      • Array Function FREQUENCY
    • FUNCTIONS FOR WORKING WITH TEXT
      • PROPER UPPER LOWER LEFT RIGHT MID
      • PROPER UPPER LOWER LEFT RIGHT MID
      • FIND CLEAN REPT CONCATENATE
      • FIND CLEAN REPT CONCATENATE
    • PIVOT TABLES IN DEPTH
      • Pivot Tables
      • Pivot Tables
      • Pivot Table Filter Slicer
      • Pivot Table Filter Slicer
      • Pivot Charts
      • Pivot Charts
      • Naming Dynamic Ranges
      • Naming Dynamic Ranges
      • Naming a Cell and a Range
      • Naming a Cell and a Range
    • AUDITING AND TROUBLE SHOOTING FORMULAS
      • Auditing Toolbar
      • Auditing Toolbar
      • Watch Window
      • Watch Window
    • FORM CONTROLS
      • Group Boxes and Options Button
      • Group Boxes and Options Button
      • Check Boxes
      • Check Boxes
      • List Boxes and Combo Boxes
      • List Boxes and Combo Boxes
      • Scroll Bar and Spinners
      • Scroll Bar and Spinners
    • IMPORTANT EXCEL TOOLS
      • Text to Columns
      • Text to Columns
      • Grouping Tabs
      • Grouping Tabs
      • SUBTOTAL Function
      • SUBTOTAL Function
      • Hyperlinks
      • Hyperlinks
      • Data Validation
      • Data Validation
      • Random Numbers
      • Random Numbers
      • Custom View
      • Custom View
      • Protecting Worksheet and Workbook
      • Protecting Worksheet and Workbook
    • ADVANCED CHARTS
      • Excel 2010 Sparklines
      • Excel 2010 Sparklines
      • Range Charts
      • Range Charts Type 1
      • Range Charts Type 1
      • Range Charts Type 1- Continued
      • Range Charts Type 1- Continued
      • Range Charts Area
      • Range Charts Area Type 2
      • Range Charts Area Type 2
      • Range Charts Area Type 2- Continued
      • Range Charts Area Type 2- Continued
      • Funding Graph
      • Funding Graph
      • Funding Graph
      • Two Axis Graphs
      • Two Axis Graphs
      • Two Axis Graphs
      • Scenario Graphs
      • Scenario Graphs
      • Scenario Graphs Continued
      • Scenario Graphs Continued
      • Average Line
      • Average Line
      • Bar to Pie chart
      • Bar to Pie chart
      • Combo Charts
      • Combo Charts
      • Creating Histogram
      • Creating Histogram
      • Invert Negatives
      • Invert Negatives
      • Scrolling Chart
      • Scrolling Chart
      • Scrolling Chart Continued
      • Scrolling Chart Continued
    • CONCLUSION
      • Conclusion


Course Fee:
USD 119

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