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

Mr. Spreadsheet’s Favorite Excel 2010 Tips & Tricks

Course Summary

Video Training Course, Deluxe Edition


  • +

    Course Syllabus

    • Basic Excel Usage
      • Maximizing Ribbon Efficiency
      • Understanding Protected View
      • Selecting Cells Efficiently
      • Customizing Your Quick Access Toolbar
      • Customizing The Ribbon
      • Using Document Themes
      • Hiding User Interface Elements
      • Hiding Columns Or Rows
      • Taking Pictures Of Ranges
    • Data Entry
      • Understanding The Types Of Data
      • Keeping Titles in View by Freezing Panes
      • Proofing Your Data With Audio
      • Controlling Automatic Hyperlinks
      • Creating A Drop Down List In A Cell
    • Formatting
      • Using Custom Date and Time Formatting
      • Understanding the New Conditional Formatting Features
      • Merging Cells
      • Formatting Individual Characters in a Cell
      • Wrapping Text In A Cell
      • Using Named Styles
    • Basic Formulas and Functions
      • When To Use Absolute References
      • When To Use Mixed References
      • Converting Formulas To Values
      • Transforming Data without Using Formulas
      • Transforming Data by Using Formulas
      • Deleting Values While Keeping Formulas
      • Avoiding Error Displays In Formulas
      • Understanding the Secret about Names
      • Using Named Constants
      • Working With Pre 1900 Dates
    • Useful Formula Examples
      • Using The DATEDIF Function
      • Using a Pivot Table Instead of Formulas
      • Displaying A Calendar In A Range
      • Returning the Last Nonblank Cell in a Column or Row
      • Looking Up An Exact Value
      • Performing A Two Way Lookup
    • Conversions and Mathematical Calculations
      • Converting Between Measurement Systems
    • Charts and Graphics
      • Selecting Elements In A Chart
      • Using Pictures In Charts
      • Saving A Chart As A Graphics File
      • Saving A Range As A Graphic Image
      • Freezing A Chart
      • Creating Picture Effects With A Chart
      • Creating Sparkine Graphics
      • Selecting Objects On A Worksheet
    • Data Analysis and Lists
      • Using The Table Feature
      • Creating a Quick Frequency Tabulation
    • Working with Files
      • Importing a Text File into a Worksheet Range
      • Getting Data From A Web Page
    • Printing
      • Displaying Repeating Rows or Columns on a Printout
    • Mr. Spreadsheet Bookshelf Personal Library
      • John Walkenbach's Favorite Excel 2010 Tips & Tricks, Part 1
      • John Walkenbach's Favorite Excel 2010 Tips & Tricks, Part 2


Course Fee:
USD 39

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations 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