【實用教育app】Learn Now with Excel 2010 Basic Tutorial Training Videos by K Alliance|最夯免費app-綠色工廠好玩App

Video Instructor: Sheri TingleDuration: 2 hours 44 minutesThis 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-SummaryModule 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-SummaryModule 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-SummaryModule 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-SummaryModule 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-SummaryModule 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-SummaryModule 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