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

MS Excel 2013 Basic-Intermediate Certified Training

Course Summary

3 Hour+ No Fluff Crash Course. 250+ Happy Udemy Students Already. Watch Only The Function Lessons You Need.


  • +

    Course Syllabus

    • Excel 2013 Introduction & Basics
      • Excel 2013 Overview
      • Workfiles Download
      • What Are The Main Differences Between Excel 2010 And Excel 2013?
      • How Does Windows 8 Change Excel 2013
      • How Does The Course Certification Work
      • What You Need To Know About Excel 2013 File Formats
      • What Is A Worksheet
      • What Is A Workbook
      • How To Use The File Menu in Excel 2013
      • Introduction To How To Use Ribbons in Excel 2013
      • How To Use The Quick Access Toolbar in Excel 2013
      • How To Find Help Inside Excel 2013
      • How To Speed Up Excel 2013 Performance
    • How To Use The Excel 2013 Ribbons
      • How To Use The Home Ribbon
      • How To Use The Insert Ribbon
      • How To Use The Page Layout Ribbon
      • How To Use The Formulas Ribbon
      • How To Use The Data Ribbon
      • How To Use The Review Ribbon
      • How To Use The View Ribbon
      • How To Move/Customize The Quick Access Toolbar
    • How To Use Workbooks & Worksheets In Excel 2013
      • How To Use Workbooks & Worksheets
      • How To Create A New Workbook
      • How & Why To Save As
      • How & Why To Save A Workbook In Different File Formats
      • How To Find Your Way Around A Workbook
      • How To View Recent Workbooks
      • How To Work With Columns & Rows
      • How To Change Cell Properties Of An Entire Worksheet
      • How To Format A Worksheet
      • How To Name & Rename Worksheet Tabs
      • How To Move Worksheets Within A Workbook
      • How To Move Worksheets Between Workbooks
      • How To Insert (Add) Worksheets
      • How To Delete Worksheets
      • How To View Multiple Workbooks
      • How & Why To Hide/Unhide Worksheets
    • How To Enter & Select Data
      • How To Enter Text In A Workbook Cell
      • How To Enter Numbers In A Workbook Cell
      • How To Enter Dates & Times In A Workbook Cell
      • How To Edit A Cell In A Workbook
      • How To Cut, Copy & Paste In A Workbook
      • How To Use The Fill Handle
      • How & Why To Use Undo & Redo
      • How To Use Zoom
      • How To Insert & Delete Columns
      • How To Insert & Delete Rows
      • How To Insert & Delete Cells
      • How To Wrap Text In Cells
      • How & Why To Change Column Widths
      • How & Why To Change Row Heights
      • How & Why To Hide/Unhide A Column
      • How & Why To Hide/Unhide A Row
      • How To Use The Go To Commands
      • How To Use Spellcheck
      • How To Use The Replace Command
      • How To Use The Find Command
      • How & Why To Use The Format Painter
    • How To Print With Excel 2013
      • How To Preview Printing
      • How To Choose The Correct Printer
      • How To Print
      • How & Why To Adjust Your Page Margins
      • How & Why To Change Your Page Orientation
      • How To Add Headers & Footers
      • How To Use The Page Break View
      • How To Use Print Titles For Large Worksheets
      • How To Print With Gridlines
      • How To Use The New Page Layout View
    • How To Format Your Workbooks & Worksheets
      • How To Edit More Than One Worksheet At A Time
      • How To Merge Cells
      • How To Change Fonts, Font Sizes, Font Colors, Bold, Italics & Underlining
      • How To Apply Different Number Formats
      • How To Align Aligning Cell Contents
      • How To Change The Direction Of Text In A Cell
      • How To Add Borders To Cells/Cell Ranges
      • How To Apply A Date Format To A Cell/Cell Ranges
      • How To Clear Cell Contents
      • How & Why To Use Themes In Your Worksheets
      • How To Use The Comments Function
      • How To Create An Auto Fill List
      • How To Turn Data Into A Table
      • How To Get Data From A Website
      • What Is Conditional Formatting
      • How To Change/Delete Conditional Formatting Rules
      • How To Highlight Duplicate Values With Conditional Formatting
      • How To Identify The Top Or Bottom Percentage Of Ranges
      • How To Use Data Bars
      • How To Use Colour Scales
      • How To Apply An Icon Set
    • How To Calculate With Excel 2013
      • Why Use Excel Calculations
      • How To Use Basic Math Formula Addition
      • How To Use Basic Math Formula Subtraction
      • How To Use Basic Math Formula Multiplication
      • How To Use Basic Math Formula Division
      • How To Use Basic Math Formula Exponent
      • How To Use Operations with BODMAS
      • How To Use Excel Formulas SUM
      • How To Copy Formulas & Functions
      • How To Display Formulae
      • How To Use Counting Functions
      • How To Use Averaging Functions
      • How To Use Highest & Lowest Functions
      • How To Use Absolute Referencing Requirements
      • How To Use Formulas Across Worksheets
      • How To Use Functions Across Worksheets
      • How To Use the SUMIF Function
      • How To Use Named Cells & Ranges
      • How To Use Pivot Tables
      • How To Calculate Depreciation
    • Making Your Workbooks/Worksheets Secure
      • Why Data Security Matters
      • How To Protect A Worksheet
      • How To Protect Part Of A Worksheet
      • How To Control Access To Cell Ranges
      • How To Add Password Protection To A Workbook
      • Securing Your Data With Cloud Backups
    • How & Why To Use Excel Templates
      • What Are Excel Templates & Why Use Them
      • How To Use A Template To Create A Workbook
      • How To Create A Custom Template
      • Where To Find More Excel Templates
    • How & Why To Use Graphics Objects
      • What Are Graphics Objects
      • How To Use Clipart
      • How To Use Smart Art Graphics
      • How To Insert Drawing Shapes
      • How To Insert A Picture
      • How To Use Background Images
      • How To Format Graphic Objects
      • How To Change Stacking Orders & Graphic Objects
      • How To Group Graphic Objects
      • How To Use Formula Results In A Callout
      • How To Insert A Screenshot
    • How & Why To Use Excel 2013 As A Database
      • What Is A Database & Why Use Excel For It
      • How To Fix Rows & Columns On Your Screen
      • How To Fix Rows & Columns For Printing
      • How To Sort Data In A Worksheet
      • How To Filter Data In A Worksheet
      • How To Delete Duplicate Entries In An Excel Database
      • How To Use Subtotals In An Excel Database
      • How To Separate A Data Column Into Multiple Columns
      • How To Split Screens On The Same Worksheet
      • How To Group Or Ungroup Data
    • How & Why To Create Charts In Excel 2013
      • What Are Excel Charts
      • How To Create An Excel Chart
      • How To Change A Chart From Sheet Object To Sheet
      • How To Change Your Chart Type
      • How To Manipulate Chart Layout & Style
      • How To Use Trend Lines
      • How To Use Pie Charts In Excel 2013
      • How To Create A Chart Template
    • How & Why To Use Skydrive Cloud Service
      • What Is Skydrive
      • How To Create A New Skydrive Account
      • How To Upload An Excel Workbook To Skydrive
      • How To Download An Excel Workbook From Skydrive
      • How To Edit An Excel Workbook In Skydrive
      • How To Share Your Excel File/s In Skydrive With Others
      • How To Directly Backup (Save) Your Excel Workbook To Skydrive
      • How To Create Folders In Skydrive
      • How To Delete Files From SkyDrive
      • Using Skydrive's Excel In A Web Browser
    • Conclusion: What's Next?
      • Conclusion: Recap, Advanced Excel 2013 Details & Course Completion Certificate


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

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