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 Course Beginners/ Intermediate Training

Course Summary

Learn to Invoke the Power of Microsoft Excel in easy to follow stages


  • +

    Course Syllabus

    • Getting Started
      • Working Files - Download These First
      • 0101 Overview Of Excel 2010
      • How to obtain your Certificate of Completion for this Infinite Skills course.
      • 0102 The New File Menu In Excel 2010
      • 0103 Exploring The Excel Workbook
      • 0104 What Will I Be Able To Do At The End Of This Course
      • 0105 Customizing The Quick Access Toolbar
      • 0106 Working With The Ribbons
      • 0107 Using The Files Included With This Course
    • Working With An Excel Worksheet
      • 0201 Creating A New Workbook
      • 0202 Saving A Workbook
      • 0203 Saving In Other Formats
      • 0204 Open A Existing Workbook
      • 0205 Navigating An Excel Workbook
    • Selecting and Entering Data
      • 0301 Entering Text And Numbers
      • 0302 Entering Numbers As Text
      • 0303 Inputting Dates And Times
      • 0304 Editing The Contents Of A Cell
      • 0305 Using Copy And Paste
      • 0306 The FILL Handle
      • 0307 Using Undo And Redo
      • 0308 Shortcuts For Selecting Cells
      • 0309 Inserting Cells , Columns And Rows
      • 0310 Deleting Cells , Columns And Rows
      • 0311 Changing Column Widths And Row Heights
      • 0312 Hiding And Unhiding A Column Or Row
      • 0313 Searching For Values In A Worksheet
    • Developing A Workbook
      • 0401 Formatting And Naming Of Worksheet Tabs
      • 0402 Moving Worksheets Within And Between Workbooks
      • 0403 Copying Worksheets Within Workbooks
      • 0404 Inserting And Deleting Worksheets
      • 0405 Viewing More Than One Workbook
      • 0406 Hiding And Unhiding Worksheets
    • Printing and Page Setup
      • 0501 Using The Print Area Command To Control What Excel Prints
      • 0502 Setting Page Margins And Page Orientation
      • 0503 Creating A Header And Footer
      • 0504 Using Page Break View
      • 0505 Setting Print Titles For Large Worksheets
      • 0506 Printing Gridlines Column Row Headings And Other Related Options
      • 0507 Enabling The New Page Layout View
      • 0508 Running The Spell Checker
      • 0509 Print Preview And Printing The Whole Or Part Of The Worksheet
    • Workbook Formatting
      • 0601 Modifying Typeface , Font Size And Colors
      • 0602 Merging Cells
      • 0603 Applying Number Formats
      • 0604 Aligning Cell Contents
      • 0605 Changing The Text Direction In A Cell
      • 0606 Adding Borders To Cells And Ranges
      • 0607 Applying A Date Format To A Cell Or Range
      • 0608 Use Of The Format Painter
      • 0609 Clearing Cell Contents And : Or Formatting
    • Carrying Out Calculations
      • 0701 Getting Started With Basic Math Formula Addition
      • 0702 Getting Started With Basic Math Formula Subtraction
      • 0703 Getting Started With Basic Math Formula Multiplication
      • 0704 Getting Started With Basic Math Formula Division
      • 0705 Getting Started With Basic Math Formula Operand
      • 0706 Order Of Operations With BODMAS
      • 0707 Introduction To Excel Formulas SUM
      • 0708 Copying Formulas And Functions
      • 0709 Displaying Formulae On A Worksheet
      • 0710 Some Useful Functions For Counting
      • 0711 Some Useful Functions For Averages
      • 0712 Some Useful Functions For Highest And Lowest
      • 0713 Absolute Referencing Requirements
      • 0714 Formulas Across Worksheets
      • 0715 Functions Across Worksheets
      • 0716 3D Referencing
      • 0717 Making Use Of Named Cells And Ranges
    • Advanced Formatting
      • 0801 Enhancing Worksheets Using Themes
      • 0802 Working With Comments
      • 0803 Creating Your Own Auto Fill List
      • 0804 Turning Your Data Into A Table For Formatting
    • Security
      • 0901 Using Protection On A Worksheet
      • 0902 Protecting Part Of A Worksheet To Facilitate Data Entry
      • 0903 Controlling Access To Cell Ranges By Password And Or User Accounts
      • 0904 Saving A Workbook With Password Protection
    • Using Templates
      • 1001 Creating A Workbook From A Template
      • 1002 Creating Your Own Custom Template
    • Graphics Objects
      • 1101 Inserting And Modifying Clipart
      • 1102 Using Smart Art Graphics
      • 1103 Adding Drawn Shapes To A Worksheet
      • 1104 Inserting An External Picture
      • 1105 Adding A Background Image To A Worksheet
      • 1106 Formatting Graphic Objects
      • 1107 Controlling Stacking Order And Alignment Of Multiple Graphics Objects
      • 1108 Grouping Graphic Objects
      • 1109 Accessing Formula Results In A Callout Bubble
    • Using Excel As A Database
      • 1201 Fixing Rows And Columns On Screen
      • 1202 Fixing Rows And Columns For Print
      • 1203 Sorting Data In A Worksheet
      • 1204 Filtering Data In A Worksheet
      • 1205 Removing Duplicates In An Excel Database
      • 1206 Adding And Using Subtotals In An Excel Database
      • 1207 Splitting One Column Of Data Into More Columns
      • 1208 Splitting The Screen To View Different Parts Of The Same Worksheet
      • 1209 Linking To Data On A Webpage
    • Using Charts in Excel
      • 1301 Creating A Chart The Long Way
      • 1302 Creating A Chart The Quick Way
      • 1303 Changing A Chart From A Sheet Object To A Sheet
      • 1304 Modifying Your Chart Type
      • 1305 Controlling Chart Style And Layout
      • 1306 Adding A Trend Line To A Chart
      • 1307 Pie Charts In More Detail
    • More Advanced Formula
      • 1401 Adding An IF Function For Cell Comparisons
      • 1402 Using The IF Function To Suppress Excel Error Messages
      • 1403 Text Manipulation With Formulae Part 1
      • 1404 Text Manipulation With Formulae Part 2
      • 1405 Date Formula In Excel
      • 1406 DATEDIF A Hidden But Useful Formula
      • 1407 SUMIF COUNTIF And AVERAGEIF
      • 1408 Use Of A Formula To Rank Scores
    • Conditional Formatting
      • 1501 Changing Cell Appearance Based On Its Value
      • 1502 Editing Conditional Formatting Rules On A Worksheet
      • 1503 Removing Conditional Formatting Rules
      • 1504 Highlighting Duplicate Values Using Conditional Formatting
      • 1505 Identifying The Top Or Bottom Percentage Of A Range
      • 1506 Use Of Data Bars Within Conditional Formatting
      • 1507 Use Of Colour Scales Within Conditional Formatting
      • 1508 Applying An Icon Set To Conditional Formatting Rules
    • Office Web Apps and Excel
      • 1601 What Is Office Web Apps
      • 1602 Sign In To Or Sign Up For Your Own Sky Drive
      • 1603 Saving An Excel Workbook Into Sky Drive
      • 1604 Accessing And Editing An Excel Workbook Through Sky Drive
      • 1605 Telling Others Where Your Public Documents Are
      • 1606 Direct Linking Or Embedding Of Sky Drive Documents
      • Creating A Folder Structure Within SkyDrive
      • Deleting Files From SkyDrive


Course Fee:
USD 99

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