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

Course Summary

Excel: Intermediate Excel 2013 Features. Gain Knowledge And Learn To Use Excel With This Intermediate Training.

  • +

    Course Syllabus

    • Introduction
      • Going over the Ribbons and their Functions
      • Going over the Ribbons and their Functions
      • Working files
    • Excel workbooks and worksheets
      • How to plug in a formula within an excel spreadsheet
      • How to add and remove worksheets, and How to rename, copy, and move worksheets
      • How to navigate an excel workbook
      • Working files
    • How to enter and edit data in the cell
      • How to enter text, numbers, and dates in an excel workbook. How to enter numbers
      • How to edit the contents of a cell, and also how to undo and redo actions
      • How to cut, copy, and paste in a workbook, and How how to drag and drop cells
      • How to use the fill handle of Microsoft excel
      • How to insert, and delete cells, columns, and rows
      • How to change column widths and row heights
      • How to hide and unhide columns and rows and How to search for values in a workbo
      • Working files
    • Basic mathematical operations and functions
      • Basic Math Formulas
      • Order of Operations with BODMAS and Intro to Basic Formulas
      • Coying and Pasting Formulas and Functions
      • Displaying Formulas on a Worksheet
      • Working files
    • Worksheet formatting and editing
      • Selecting Cells For Formatting and Modifying Typeface Font, Size, And Color
      • Merging And Wrapping Cell Contents
      • Using Number Formats
      • Cell Content Alignment, Orientation, Adding And Removing Borders From A Section
      • Applying a date
      • Finding And Replacing Formats
      • Clearing Cell Contents Vs Clearing Cell Formatting
      • Working files
    • Managing workbooks and worksheets
      • Worksheet Navigation And Coloured Worksheet Tabs and Moving Or Copying Worksheet
      • Viewing And Scrolling Multiple Workbooks At The Same Time and Hiding And Un-Hidi
      • Modifying More Than One Worksheet At A Time
      • Working files
    • Setting up the page formatting for printing
      • Using Print Titles And Print Areas
      • Paper Size, Orientation, Margins, And Scaling Options
      • Creating Headers and Footers
      • Using The Page Break And The Page Layout Views
      • Printing A Range Of Cells and Running the Spell Checker
      • Controlling Most Print Settings In One Place
      • Working files
    • Formulas and functions
      • The Sum Function
      • Copying Formulas And Functions
      • Useful Count Functions
      • Absolute Referencing Explained
      • Formulas Across Worksheets
      • 3D Referencing
      • Making Use Of Named Cells And Ranges
      • Working files
    • More complicated formatting
      • Creating Your Own Autofill List
      • Converting Data To A Table For Formatting
      • Enhancing Worksheets Using Themes and Adding, Editing, And Deleting Comments
      • Working files
    • Protection and security
      • Activating And Deactivating Worksheet Protection
      • Protecting Part Of A Worksheet To Aid Data Entry
      • Password Protecting The Whole Workbook
      • Ready to use templates
      • Working files
    • Graphical figures and objects
      • Obtaining And Inserting Online Images
      • Using Graphical Objects And Mathematical Formulas
      • Inserting Shapes And Screenshots
      • Formatting Graphical Objects
      • The Stacking Order
      • Grouping Multiple Objects Together
      • Using Graphical Objects And Mathematical Formulas
      • Working files
    • Charts and how to use them
      • The New Recommended Charts Option
      • Create A Chart Using The Long Or The Short Method and Formatting A Chart With Th
      • Modifying The Chart Type and Formatting Chart Elements
      • Adding A Trendline
      • The Pie Chart In Detail
      • Mini Graphs Sparklines
      • Working files
    • Excel and how to use it as a database
      • Fixing On Screen Rows And Columns
      • Fixing Print Rows And Columns and Sorting Data In Excel
      • Filtering Data To Reduce Dataset Size
      • Removing Duplicate Entries In The Data and Adding Subtotals To A Worksheet
      • Using Text To Columns Effectively
      • Linking To Data On A Webpage
      • Working files
    • Advanced and a bit complicated formulas
      • Using An If Formula
      • Use Of The If Function To Hide Excel Error Messages
      • Datedif A Useful But Hidden Formula
      • Text Manipulation Using Functions
      • Use The Text Function To Format Numbers and Date Manipulation Functions
      • Introducing Sumif, Countif, And Averageif
      • Use Of Rank To Calculate Placings
      • Flash Fill
      • Working files
    • More formatting
      • Altering Cell Appearance Based On The Cell Value
      • Displaying Data Bars, Color Scales, Or Icon Sets and Using Top
      • Creating A Formatting Rule From Scratch
      • Managing The Conditional Formatting Rules
      • Working files

Course Fee:

Course Type:


Course Status:



1 - 4 hours / week

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