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

Core Excel - Microsoft Excel Training

Course Summary

Learn the core features of Excel in less time


  • +

    Course Syllabus

    • Introduction
      • Welcome
      • How to use the practice files included with this course
    • A tour of Excel
      • What is Excel?
      • A tour of the Excel interface
      • A tour of the Excel Ribbon
      • A tour of the File tab - going backstage
    • Getting started
      • How to create a new workbook
      • How to save a workbook
      • How to save a workbook in a different format
      • How to navigate a workbook
      • How to find and open recent workbooks
      • How to undo and redo changes
      • How to use the Quick Access Toolbar
    • The worksheet
      • How to select cells
      • How to select rows and columns
      • Shortcuts for selecting cells
      • How to insert and delete columns
      • How to insert and delete rows
      • How to insert and delete cells
      • How to change the column widths
      • How to change row heights
      • How to hide or unhide columns or rows
    • Entering Data
      • How to enter data
      • How to edit data
      • How to delete data
      • How to enter dates
      • How to enter historical dates
      • How to enter times
      • Shortcuts to enter the current date and time
      • How to enter numbers as text
      • Shortcut for entering data in more than one cell
      • How to enter data with the fill handle
      • How to enter custom patterns with the fill handle
      • How to move data
      • How to duplicate data
      • How to use drag and drop
    • Building a Workbook
      • How to insert and delete worksheets
      • How to name and format worksheet tabs
      • How to move and copy worksheets
      • How to move and copy worksheets to other workbooks
      • How to hide and unhide worksheets
    • Find and Replace
      • How to find a value
      • How to search in formulas and values
      • How to find a formatted value
      • How to find all matches at once
      • How to find and replace a value
      • How to find and replace formatted values
    • Formula Basics
      • Introducing the cell reference
      • Introducing the formula
      • Introducing the function
      • How to enter a formula that uses cell references
      • How to edit a formula
      • How to use addition in a formula
      • How to use subtraction in a formula
      • How to use multiplication in a formula
      • How to use division in a formula
      • How to use exponents in a formula
      • The order of operations in Excel
    • Cell References
      • What is a relative reference?
      • How to use relative references - example 1
      • How to use relative references - example 2
      • What is an absolute reference?
      • How to use absolute references - example 1
      • How to use absolute references - example 2
      • Named ranges as absolute references
    • Formatting numbers
      • What is a number format?
      • How to use general formatting
      • How to use number formatting
      • How to use currency formatting
      • How to use accounting formatting
      • How to use percentage formatting
      • How to use fraction formatting
      • How to use scientific formatting
      • How to use text formatting
      • How to use special formatting
      • How to create a custom number format
    • Formatting dates and times
      • How does Excel store dates and times?
      • How to use date formatting
      • How to use time formatting
      • How to create a custom date format
      • How to create a custom time format
    • Alignment
      • How to wrap text in cells
      • How to apply horizontal alignment
      • How to use justify, fill, and distributed
      • How to align text vertically
      • How to indent cell content
      • How to align text across cells with merge
      • How to use Center Across Selection
      • How to use shrink to fit
      • How to use text orientation
    • Font Formatting
      • How to format font and font size
      • How to apply bold, italic, underlining styles
      • How to change the font color
      • Using format cells to set font styles
      • How to apply different underline options
      • How to apply subscript and superscript formatting
      • How to insert symbols and special characters
      • How to format individual characters and words
    • Borders and Fills
      • How to apply a border to cells
      • How to apply a fill to cells
      • How to draw borders and border grids
      • How to apply a border using ribbon presets
      • How to use borders and fills together
      • How to remove existing borders and fills
    • Conditional Formatting
      • What is conditional formatting?
      • How to create a conditional formatting rule
      • How to revise a conditional formatting rule
      • How to add additional conditional formatting rules
      • How to add a conditional formatting key
      • How to delete conditional formatting rules
      • How to highlight top and bottom values
      • How to highlight above and below average values
      • How to use data bars with conditional formatting
      • How to use color scales with conditional formatting
      • How to use Icon sets with conditional formatting
      • How to highlight text values with conditional formatting
      • How to show duplicate values with conditional formatting
      • How to use a formula with conditional formatting
    • Working with data and lists
      • How to freeze columns or rows in a list
      • how to quick sort using one column
      • How to sort using more than one column
      • How to filter a list
      • How to filter with multiple criteria
      • How to highlight duplicates in a list
    • Charting
      • Anatomy of an Excel chart
      • How to create a basic chart
      • How to move and re-size a chart
      • How to create a standalone chart
      • How to edit and add to chart data
      • How to add a title and legend to a chart
    • Conclusion
      • Conclusion


Course Fee:
USD 119

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

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