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

Learn Microsoft Excel 2013

Course Summary

Fast moving, easy to follow Microsoft Excel 2013 tutorial from the e-learning experts!


  • +

    Course Syllabus

    • Introduction and Auxiliary Materials
      • Introductory Lecture
    • An Introduction to Excel 2013
      • Getting Started
      • Exploring the Ribbon Tabs
      • Exploring the Home Tab
      • Exploring the Insert Tab
      • Exploring the Page Layout Tab
      • Exploring the Formulas Tab
      • Exploring the Data Tab
      • Exploring the Review Tab
      • Exploring the View Tab
      • Exploring the Font Group
      • Exploring the Font Dialog Box
      • Exploring the Alignment Group
      • Exploring the Alignment Dialog Box
      • Understanding the Number Group
      • Using the Number Dialog Box
      • Hiding the Ribbon
    • Behind the Scenes with Backstage View
      • Entering & Exiting Backstage View
      • Exploring the Info Option
      • Exploring the New Option
      • Exploring the Open Option
      • Exploring the Save & Save As Options
      • Exploring the Print Option
      • Exploring the Share Option
      • Exploring the Export Option
      • Exploring the Close Option
      • Exploring the Account Option
      • Exploring the Options Option
    • Working with Workbooks and Worksheets
      • Understanding Status Bar Results
      • Understanding Worksheet Navigation
      • Adding & Deleting Worksheets
      • Renaming Worksheets
      • Hiding & Unhiding Worksheets
      • Moving Worksheets
      • Copying Worksheets
      • Coloring Worksheet Tabs
      • Using Zoom Controls
      • Working with Templates
      • Exploring Navigation Shortcuts
      • Exploring Worksheet Views
      • Splitting the Worksheet Views
      • Arranging Worksheet Views
    • Working with Data
      • Entering Data
      • Inserting Different Data Types
      • Understanding AutoFill
      • Creating Series with AutoFill
      • Working with AutoComplete
      • Adjusting Rows and Columns with Autofit
      • Adjusting Rows and Columns using the Ribbon
      • Hide Columns and Rows
      • Unhide Columns and Rows
    • Conditional Formatting
      • Conditional Formatting with Data Bars
      • Configuring Data Bar Rules
      • Conditional Formatting Using Color Scales
      • Conditional Formatting Using Icon Sets
      • Configuring Highlight Cells Rules
      • Working with Top/Bottom Rules
      • Manage Multiple Conditional Formatting Rules
      • Using Cross Sheet Conditional Formatting
      • Working with Conditional Formatting in Ranges with Errors
    • The Basics of Formulas and Functions
      • Creating Formulas
      • Understanding Functions
      • Using AutoSum
      • Using the Average Function
      • Using the Count Function
      • Using the Min Function
      • Using the Max Function
      • Exploring the Function Library
      • Using the Insert Functions Command
      • Inserting Logical Functions
      • Working with Text Functions
      • Using Date Functions
    • Working with Tables
      • Creating A Table
      • Viewing Table Headers
      • Sorting Table Data
      • Exploring Sort and Filter Commands
      • Preparing to Use Custom Sort
      • Performing a Color Custom Sort
      • Using Multiple Level Custom Sorts
      • Exploring Data Filters
      • Filtering Multiple Columns
      • Using Search Features
      • Adding Data to a Table
      • Pick an Item From A List
      • Adding Columns
      • Creating a Calculated Column
      • Adding a Total Row
      • Formatting Tables
    • Graphics, Printing and Review Features
      • Inserting Pictures and ClipArt
      • Inserting Shapes
      • Formatting Pictures
      • Formatting Shapes
      • Adding SmartArt into Worksheets
      • Adding Pictures in SmartArt
      • Customizing Print Options
      • Scaling Page Dimensions
      • Modifying Gridlines and Headlines
      • Creating Headers and Footers
      • Printing Titles
      • Using Proofing Tools
      • Working with Cell Comments
    • Conclusion
      • ClipTraining Conclusion


Course Fee:
USD 49

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

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