K Alliance Tutorial Videos For Microsoft Excel 2010 Basic

Video Instructor: Sheri Tingle
Duration: 2 hours 44 minutes

This self-paced video training course, featuring Sheri Tingle covers the basics of Microsoft Excel 2010. Watch the demos and listen to Sheri’s step-by-step explanations and soon you will be ready to start using Excel 2010 on your own. This video tutorial course is part of a 3 level series. The next levels are intermediate and advanced.

Table of Contents:

•Module 1: Basic Excel Elements
◦Starting Excel
◦The Ribbon and the New Backstage
◦Opening an Existing Workbook
◦Opening a Recently Used Workbook
◦Creating a New Workbook
◦Saving Your Workbook
◦Closing a Workbook
◦Exiting Excel
◦Basic Excel Elements Lab
◦Summary
◦
•Module 2: Basic Excel Details
◦Introduction
◦Scrolling With and Without Scroll Bars
◦Moving Around the Worksheet
◦Left Click vs. Right Click
◦Worksheet Tabs
◦Where are the Dialog Boxes?
◦Setting up the Page Layout
◦Previewing and Printing a Workbook
◦Basic Excel Details Lab
◦Summary
◦
•Module 3: Selecting and Editing Techniques
◦Introduction
◦Selecting an Entire Worksheet
◦Selecting a Range of Cells
◦Selecting Nonadjacent Cells and Ranges
◦Selecting Columns and Rows
◦Changing Column Width or Cell Height
◦Hiding and Unhidden Rows and Columns
◦Moving and Copying Data
◦Using Drag and Drop
◦Editing Information in Cells
◦Using Undo and Redo
◦Selecting and Editing Techniques Lab
◦Summary
•
•Module 4: Data Entry Techniques
◦Introduction
◦Entering Information into Single Cells
◦Entering Information into Multiple Cells at Once
◦Deleting Information
◦Typing Text vs. Numbers
◦Learning AutoFill Basics
◦Using AutoFill Tricks
◦Data Entry Techniques Lab
◦Summary
•
•Module 5: Performing Calculations
◦Introduction
◦Understanding Formula Operators and Order of Operations
◦Using Real Numbers to Do Math
◦Using Cell References to Do Math
◦Letting the Sum Button do the Math for You
◦Creating Simple Formulas
◦Using Common Functions
◦Using the Insert Functions Dialog Box
◦Using AutoFill to Copy Formulas
◦Editing Formulas and Functions
◦Creating a Simple Formula Lab
◦Using Common Functions Lab
◦Summary
•
•Module 6: Formatting with Fonts and Alignments
◦Introduction
◦Changing the Actual Font and Font Size
◦Embellishing Fonts
◦Aligning Text Within a Cell
◦Displaying Text Vertically or at an Angle
◦Using the Text Wrap Feature or Wrapping Text Manually
◦Using the Merge and Center Tool
◦Formatting with Fonts and Alignments Lab
◦Summary
•
•Module 7: Formatting Cells
◦Introduction
◦Putting Color into the Cell Background
◦Bordering Cells
◦Creating the Proper Number Format with a Click of a Button
◦Applying Number formats Using the Drop-down Tool
◦Copying Formats with the Format Painter
◦Using Built-In Styles
◦Applying Conditional Formatting
◦Using Built-in Style and Conditional Formatting Lab
◦Applying Borders and Shading Lab
◦Summary
•
•Module 8: Working with the Excel Data
◦Introduction
◦Finding and Replacing information
◦Sorting Data
◦Copying or Moving Sheet Between Workbooks
◦Inserting and/or Deleting Columns and Rows
◦Naming Ranges
◦Using Various Excel Views for Working Efficiently
◦Checking Spelling
◦Inserting Page Breaks
◦Using Excel Editing Tools Lab
◦Finalizing the Worksheet Lab
◦Summary