-
FREE 1. Introducing Excel 2010 -
FREE 2. The Ribbon -
Join 3. Customizing the Ribbon -
Join 4. Backstage View -
Join 5. Create a Worksheet from Scratch -
Join 6. Creating a Workbook from a Template -
Join 7. Saving an Excel Workbook -
Join 8. Using Help -
Join 9. Copy and Paste Complete Cell Contents -
Join 10. Copy and Paste Portions of Cell Content -
Join 11. Clear or Move Cell Contents -
Join 12. Using Autofill for Data Entry -
Join 13. Create a List for Auto Fill -
Join 14. Select Data to Modify -
Join 15. Insert Cell Rows Columns -
Join 16. Delete Cells Rows Columns -
Join 17. A Primer for Functions and Formulas -
Join 18. Entering Data into Cells -
Join 19. Adding Numbers Manually -
Join 20. Using SUM and AutoSum -
Join 21. Adding an Entire Worksheet -
Join 22. Using Basic Formulas -
Join 23. Absolute References to Reduce Errors -
Join 24. Using NOW and TODAY to Enter Date and Time -
Join 25. Using the Ribbon to Enter Formulas NOW and TODAY -
Join 26. Using the IF Function -
Join 27. Using the SUMIF and AVERAGEIF -
Join 28. Naming Cell Ranges -
Join 29. Managing Named Ranges -
Join 30. Formatting Numbers and Dates -
Join 31. Formatting Numbers and Dates -
Join 32. Adjusting Colors Borders and Fonts -
Join 33. Adjusting Rows Columns and Text -
Join 34. Conditional Formatting Data Ranges -
Join 35. Customizing Conditional Formatting -
Join 36. Inserting Pictures and Illustrations -
Join 37. Using Smart Art -
Join 38. Using Themes for Consistency -
Join 39. Applying Styles -
Join 40. Creating and Sharing Styles -
Join 41. Using Templates -
Join 42. Creating a Template -
Join 43. Printing your Worksheets -
Join 44. Inserting Headers and Footers -
Join 45. Printing PDF and XPS Documents -
Join 46. Finding Selecting Replacing Data -
Join 47. Splitting and Freezing Pane -
Join 48. Print Repeating Worksheet Title -
Join 49. Creating and Printing Multiple Custom Views -
Join 50. Hiding and Grouping Columns -
Join 51. Using Tabs to Manage Worksheets -
Join 52. Calculating Across Worksheet -
Join 53. Sharing Data b Importing Exporting -
Join 54. Permissions and Worksheet Protection -
Join 55. Entering and Printing Comments -
Join 56. Sharing Workbooks -
Join 57. Tracking and Accepting Changes -
Join 58. Sharing Files on Web SharePoint -
Join 59. Joining Multiple Data into Single Cell -
Join 60. Splitting Single Data into Multiple Cells -
Join 61. Basic and Multi Field Sort and Filtering -
Join 62. Using Tables to Sort and Find Data -
Join 63. Using Auto Sub Totals and Averages -
Join 64. Using LOOKUP Tables VLOOKUP -
Join 65. Audit Diagrams and Error Analysis -
Join 66. Evaluate Formula Tool -
Join 67. What If Analysis Using Goal Seek -
Join 68. Using Data Tables in Formulas -
Join 69. Scenario Manager for Formulas -
Join 70. Activating Analysis Tool -
Join 71. Using ToolPak -
Join 72. Intro to Pivot Tables -
Join 73. Modifying Pivot Tables -
Join 74. Creating A Pivot Table -
Join 75. Using Slicers with Pivot Tables -
Join 76. Creating and Modifying a Pivot Chart -
Join 77. Using Sparklines -
Join 78. Creating Column Charts -
Join 79. Modifying a Column Chart -
Join 80. Creating and Modifying Pie Charts -
Join 81. Sharing Charts With Other Programs -
Join 82. Preparing to Use Macros -
Join 83. Creating a Simple Macro -
Join 84. Creating a Macro Enabled Workbook



