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

Microsoft Excel 2013 Simplified

Course Summary

Learn Excel 2013 from Excel 2013 tutorial for beginners and advance to next level. Simple and easy to understand


  • +

    Course Syllabus

    • Starting with Excel Workbook
      • Introduction to Excel
      • What will you learn in this course?
      • Creating a New Workbook
      • Saving the File
      • Open an Existing Workbook
      • Saving File Other than in Excel (.xlsx) Format
      • Navigating around in Excel Workbook
    • Data in Excel
      • Entering Text and Numbers in Excel
      • Editing the contents of cells
      • Entering Numbers as Text
      • Copy and Paste in Excel
      • Keyboard shortcuts for selecting cells
      • Undo, Redo or Repeat Action in Excel
      • Altering Row Height and Column Width
      • Insert and Delete - Rows and Columns
      • Hide and Unhide Rows and Columns
      • Excel FILL Option
      • Searching for values in Excel
    • Working with Excel Worksheets
      • Insert and Delete Worksheets
      • Moving and Copying worksheets within and between workbooks
      • Hide and Unhide Worksheets
      • View two worksheets in SAME file side by side
      • View two worksheets in DIFFERENT file side by side
    • Formatting Excel Workbooks
      • Formatting Fonts in Excel (Part 1)
      • Formatting Fonts in Excel (Part 2)
      • Merging Cells
      • Number Formatting in Excel
      • Date and Time Formatting in Excel
      • Alignment and Orientation of Text
      • Text Indentation in Excel
      • Wrap Text in Excel
      • Applying Borders to Cells
      • Clearing Cell Contents and Formatting in Excel
      • Format Painter in Excel
      • Themes in Excel
    • Templates in Excel
      • Creating a Custom Template
      • Creating a New Workbook from a template
    • Formulas and Functions in Excel to do calculation
      • Cell Referencing and Basic Mathematical Calculation
      • Mathematical Operation and Order of Calculation
      • Excel SUM Function
      • COUNTing Function in Excel
      • AVERAGE Function in Excel
      • Finding Minimum and Maximum Values
      • Copy Formulas and Function in Excel
      • Move Relative Reference Formula in Excel
      • Show Formulas in Excel
      • Absolute Referencing in Excel
      • Mix of Absolute and Relative Referencing in Excel
      • Formulas and Functions Cell Referencing Across Worksheets
    • Advanced Formulas in Excel
      • IF Function in Excel
      • IFERROR Function in Excel
      • Logical Function in Excel
      • Logical Function in IF Conditions
      • SUMIF(s), COUNTIF(s) and AVERAGEIF(s) Function in Excel
      • Date and Time Functions in Excel
      • Text Functions in Excel Part 1 - CONCATENATE, LEN, LEFT, MID, RIGHT
      • Text Functions in Excel Part 2 - LOWER, UPPER, PROPER, TRIM
      • Text Functions in Excel Part 3 - SEARCH, FIND, SUBSTITUTE
      • RANK Function in Excel
      • Name Ranges and its use in Formulas
      • 3D Referencing Formulas in Excel
    • Conditional Formatting in Excel
      • Applying Conditional Formatting
      • Editing and Removing Rules from Conditional Formatting
      • Highlight Unique and Duplicate Values using Conditional Formatting
      • Highlight Top and Bottom values using Conditional Formatting
      • Using Color Scales in Conditional Formatting
      • Using Data Bars with Conditional Formatting
      • Applying Icon Sets in Conditional Formatting
    • Excel Page Setup and Printing
      • Print Preview in Excel
      • Inserting Header and Footer
      • Different Headers and Footers for First, Odd and Even Pages
      • Set Print Area
      • Margins in Excel
      • Repeat Rows and Columns on each printed page
      • Print Gridlines, Row Numbers and Column Headers
      • Different Workbook Views - Normal, Page Layout and Page Break
      • Change Page Orientation and Size in Excel
    • Advanced Data Handling Operations
      • Filtering Data in Excel
      • Sorting in Excel
      • Text to Columns in Excel
      • Remove Duplicate Values
      • Subtotals in Excel
      • Freezing Rows and Columns in Excel
      • Comments in Excel
    • Charts in Excel
      • Insert Charts in Excel
      • Changing Chart Types in Excel
      • Changing Chart Style and Layout
      • Add Chart Titles, Asix Titles and Data Labels in Excel
      • Adding and Removing Axis and Gridlines
      • Changing Axis Scale in Excel Chart
      • Adding a Trend Line in Excel chart
      • Move chart into separate sheet
    • Working with Windows SkyDrive
      • Sign in to Windows SkyDrive
      • Creating a New Workbook from SkyDrive
      • Accessing and Editing Files using Windows SkyDrive
      • Manage Folders in SkyDrive
      • Download and Delete Files from SkyDrive
      • Sharing Files from SkyDrive
    • Graphic Objects and SmartArt in Excel
      • Insert Shapes in Excel
      • Format Shapes in Excel
      • Insert and Format Text in Shapes
      • Arranging and Ordering Graphic Objects
      • Grouping and Regrouping of Graphic Objects
      • Insert Cell Reference and Formula Results in Graphic Objects
      • Insert an External Image
      • Insert Background Image for worksheet
      • Insert SmartArt Object in Excel
    • Security in Excel
      • Protect Worksheet
      • Unprotect the worksheet
    • Conclusion
      • Conclusion


Course Fee:
USD 49

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