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

Mastering Excel 2010

Course Summary

Learn Everything You'd Want To Know About Microsoft Excel


  • +

    Course Syllabus

    • Excel 2010: The Basics
      • What Is Excel?
      • Adding/Changing Workbooks
      • Basic Text and Number Entry
      • The Interface: Ribbon and Quick Access Toolbar
      • The Interface: Status Bar and View Options
      • Keyboard Shortcuts
      • File Types
      • Open, Save, and AutoSave
      • Templates
      • AutoCorrect
      • Undo and Redo
    • Text and Formatting
      • Text Formatting - Part 1: Font Style, Size, Color
      • Text Formatting - Part 2: Alignment, Numbers
      • Adding Hyperlinks
      • Scientific Equations
      • The Windows Clipboard (Paste Options)
      • The Office Clipboard (Advanced Cut and Paste)
      • Find and Replace
      • Spellcheck and Reference
    • Shapes and Graphics
      • Shapes, Part 1: Inserting and Formatting
      • Shapes, Part 2: Arranging and re-Shaping
      • Pictures
      • Pictures: Advanced Effects
      • Clip Art and SmartArt
      • Text Boxes
      • Navigating and Highlighting in a Spreadsheet
      • Insert, Delete, Hide, Unhide
    • Data, Formulas, and Functions
      • Entering Data in Series
      • Formulas - Order of Operations, Absolute vs Relative
      • Intro to Functions
      • Financial Functions
      • Time and Date Functions
      • Formulas Tab: Text Functions
      • Logical, Math, and Statistical Functions
      • vLookup and More Functions
      • Formatting Cells and Ranges
      • Number Formatting
    • Working with Tables
      • Tables
      • Sorting and Filtering
      • Subtotals
      • Creating Pivot Tables
      • Customizing Pivot Tables
      • Importing Data
    • Visualizing Information with Charts
      • Intro To Charts
      • Chart Design and Styles
      • Optimizing Chart Data
      • Advanced Chart Formatting
      • Pivot Charts
      • Sparklines
    • Advanced Features
      • Customizing Your Worksheet View, Part 1
      • Customizing Your Worksheet View, Part 2
      • Advanced Worksheet Formatting
      • Advanced Data Copy Techniques
      • Transforming Data With The Clipboard
      • Manipulating Text With Functions
      • Printing
      • Print Area
      • Using Data Validation
      • Analyzing Data: What-If Analysis / Scenario Manager
      • Analyzing Data: What-If Analysis / Data Tables
      • Analyzing Data: What-If Analysis / Goal Seek
      • Text To Columns
      • Consolidating Data
      • Creating Macros
      • Advanced Macros
      • Creating Random Numbers and Custom Series
      • Calculating Functions Across Multiple Workbooks
      • Customizing The Ribbon and Quick Access Toolbar


Course Fee:
USD 15

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