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

Excel 2013 For Dummies Video Training, Deluxe Edition

Course Summary

Learn Excel 2013 right now with this easy to follow, self-paced course! For Dummies. Making Learning Easier!

  • +

    Course Syllabus

    • Getting Started with Excel 2013
      • Launching (and Quitting) Excel
      • Going Backstage
      • Using the Excel Ribbon
      • Customizing the Quick Access Toolbar
      • Selecting Commands
      • The Formula Bar and the Status Bar
      • Navigating the Worksheet Area
      • Tips on Using the Touch Keyboard
      • Finding Help
      • Quiz
    • Creating Spreadsheets
      • Doing the Data-Entry Thing
      • Exploring Excel's Data Types
      • Fixing mistakes with AutoCorrect
      • AutoComplete, AutoFill, and Flash Fill
      • Using the Insert Function Button
      • The AutoSum and Quick Analysis Tools
      • Saving Your Workbooks
      • Document Recovery
      • Quiz
    • Editing Spreadsheets
      • Making Cell Selections
      • Using the Format as Table Gallery
      • Formatting Cells with the Mini-bar
      • Calibrating Columns
      • Futzing with the Fonts
      • Altering the Alignment
      • Working with Styles
      • Fooling Around with the Format Painter
      • Conditional Formatting
      • Opening Your Workbooks for Editing
      • Making Edits with Undo, Drag-and-Drop, Cut/Copy/Paste
      • Deleting Stuff
      • Staying in Step with Insert
      • Stamping Out Your Spelling Errors
      • Eliminating Errors with Text to Speech
      • Quiz
    • Printing
      • Previewing Pages in Page Layout View
      • Using the Backstage Print Screen
      • Printing the Current Worksheet
      • Setting Up Your Pages
      • Inserting Headers and Footers
      • Solving Page Break Problems
      • Printing the Formulas in a Worksheet
      • Quiz
    • Getting Organized
      • Zooming In and Out
      • Splitting the Worksheet into Windows
      • Fixed Headings with Freeze Panes
      • Adding, Editing, and Printing Comments
      • Naming Ranges
      • Finding and Replacing
      • Replacing Cell Entries
      • Doing Your Research
      • Controlling Recalculation
      • Protecting your Content
      • Juggling Multiple Worksheets
      • Editing Multiple Worksheets at Once
      • Adding, Deleting, and Reordering Worksheets
      • Viewing Multiple Worksheets at Once
      • Comparing Worksheets Side by Side
      • Shifting Sheets to Other Workbooks
      • Summing Stuff on Different Worksheets
      • Quiz
    • Doing Data Analysis
      • Playing What-If with Data Tables
      • Playing What-If with Goal Seeking
      • Using Scenario Manager
      • Creating Pivot Tables
      • Formatting Pivot Tables
      • Sorting and Filtering Pivot Table Data
      • Modifying Pivot Tables
      • Creating Pivot Charts
      • Quiz
    • Charts, Graphics, and Data Lists
      • Making Professional-Looking Charts
      • Moving and Resizing Embedded Charts
      • Customizing Charts and Chart Elements
      • Editing the Generic Titles in a Chart
      • Sparking Up the Data with Sparklines
      • Telling All with a Text Box
      • Working with Downloaded or Local Images
      • Editing and Formatting Inserted Images
      • Working with WordArt, SmartArt, Screenshots, and Themes
      • Reordering the Layering of Graphic Objects
      • Grouping and Hiding Graphic Objects
      • Creating Data Lists
      • Sorting and Filtering Data Lists
      • Importing External Data
      • Quiz
    • Linking, Automating, and Sharing Spreadsheets
      • Using Apps for Office
      • Using Excel Add-Ins
      • Adding hyperlinks to a Worksheet
      • Automating Commands with Macros
      • Sharing Workbooks via SkyDrive
      • Presenting and Editing Worksheets
      • Quiz
    • The Part of Tens
      • Top Ten Beginner Basics
      • Top Ten New Features in Excel 2013
    • Excel 2013 For Dummies Personal Library
      • Excel 2013 All-in-One For Dummies, Special Udemy Edition eBook
      • What's New in Excel 2013
      • Cheat Sheet from Excel 2013 For Dummies
      • Cheat Sheet from Excel 2013 All-in-One For Dummies
      • Cheat Sheet from Excel VBA Programming For Dummies
      • Excel 2013 For Dummies: Parts of Tens
      • Excel 2013 VBA Programming For Dummies: Parts of Tens
      • Excel 2013 Educational PowerPoint
    • Beyond Excel
      • Word: Adding Headers and Footers
      • Outlook: Storing and Updating Contact Information
      • Outlook: Managing Appointments
      • PowerPoint: Prepping Your Slides for Presentation
      • PowerPoint:Adding Visual Transitions
      • Access: Searching and Filtering a Database
      • Access: Sorting Data
      • General: Connecting to SkyDrive
      • Windows 8 For Dummies Cheat Sheet
      • Access 2013 For Dummies Cheat Sheet
      • PowerPoint 2013 For Dummies Cheat Sheet
      • Word 2013 For Dummies Cheat Sheet

Course Fee:
USD 169

Course Type:


Course Status:



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
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