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 2010 Training Course - Online/Offline Access

Course Summary

Top Universities Require Our Microsoft Excel Training Course for their Business Students.Learn Excel 2010 from Experts.


  • +

    Course Syllabus

    • Introduction
      • Introduction to ExcelNow!
    • Changes in Excel 2007 and 2010
      • Changes in Excel 2007 and 2010 Intro
      • Tabs and Ribbons
      • Modifying Ribbons in 2010
      • File and Office Buttons
      • Quick Access Toolbar
      • Excel Options
      • Developer Ribbon
      • File Extentions
      • Opening Recent Files in 2010
      • Selected Range Coloring in 2010
      • New Functions in 2010
      • Add-Ins Buttons in 2010
      • Slicer in 2010
      • Sparklines in 2010
      • New Solver in 2010
    • Intro to Basics
      • Intro to Excel Basics
    • Moving and Selecting
      • Intro to Moving and Selecting
      • Going Home to Cell A1
      • Splitting the Screen
      • Selecting a Range with Keys
      • Selecting a Range by Pointing
      • Selecting Multiple Ranges
      • Go to Options
    • Copying, Cutting, Pasting
      • Intro to Copying, Cutting & Pasting
      • Copying and Pasting
      • Cutting and Pasting
      • Paste Special Options
      • Transposing a Range
      • Office Clipboard
    • Other Basic Tools
      • Intro to Other Basic Tools
      • Undoing Actions
      • Right-Clicking
      • Shortcut Keys
      • Number Formats
      • Cell Borders
      • Manipulating Rows & Columns
      • Manipulating Worksheets
      • Filling a Series
      • Sorting and Custom Lists
      • Adding Hyperlinks
      • Printing
      • Templates
    • Formulas
      • Intro to Formulas
      • Relative, Absolute Addresses
      • R1C1 Notation
      • Range Names
      • Calculation Options
      • AutoSum Button
      • Auditing Formulas
      • Evaluating a Formula
      • External Formula References
      • Error Codes & IS Functions
      • Array Formulas
    • Charts
      • Intro to Charts
      • Creating a Chart
      • Modifying a Chart
      • Locating a Chart
    • Intro to Functions
      • Intro to Functions
      • Function Help
    • Two Essential Functions
      • Intro to Two Essential Functions
      • IF Function
      • VLOOKUP Function
    • Basic Summarizing Function
      • Basic Summarizing Functions
      • SUM, AVERAGE, PRODUCT
      • COUNT, COUNTA, COUNTBLANK
      • COUNTIF, SUMIF, AVERAGEIF
      • COUNTIFS, SUMIFS, AVERAGEIFS
      • SUMPRODUCT
    • Math Functions
      • Intro to Math Functions
      • INT, ROUND, CEILING, FLOOR
      • ABS, SQRT, SUMSQ
      • LN, EXP
      • RAND, RANDBETWEEN
    • Text Functions
      • Intro to Text Functions
      • LOWER, UPPER, PROPER
      • TRIM, VALUE
      • Concatenating
      • Parsing with Text to Columns
      • Parsing with Text Functions
    • Date and Time Functions
      • Intro to Date and Time Functions
      • Y2K
      • TODAY, NOW
      • YEAR, MONTH, DAY, WEEKDAY
      • DATEDIF
      • DATE, DATEVALUE
      • NETWORKDAYS, WORKDAY
    • Statistical Functions
      • Intro to Statistical Functions
      • MIN, MAX
      • MEDIAN, QUARTILE, PERCENTILE
      • STDEV, VAR
      • CORREL, COVAR
      • RANK, LARGE, SMALL
    • Financial Functions
      • Intro Financial Functions
      • PMT
      • NPV, XNPV
      • IRR
    • Reference Functions
      • Intro to Reference Functions
      • Index
      • MATCH
      • OFFSET
      • INDIRECT
    • Data Analysis Tools
      • Intro to Data Analysis Tools
      • Tables
      • Pivot Tables
      • Consolidating
      • Subtotals
      • Data Tables
      • Goal Seek
      • Solver
    • Importing External Data
      • Intro to Importing External Data
      • From a Text File
      • From a database
      • From Built-In Connections
      • From Built-In Connections
      • From the Web
    • Making Professional Applications
      • Intro to Making Professional Apps
      • Documenting Your Work
      • Themes
      • Styles
      • Conditional Formatting
      • Custom Views
      • Scenarios
      • Outlining
      • Data Validation
      • Protecting
      • Using Form Controls
      • Recording a Macro
    • Final Thoughts


    Course Fee:
    USD 99

    Course Type:

    Self-Study

    Course Status:

    Active

    Workload:

    1 - 4 hours / week

    Related Posts:

    Microsoft Excel

     

    Security, Trust and Assurance Registry (STAR)

     

    Data Analysis

     

    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