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 - Level 2 - Essentials

Course Summary

This course builds on the foundations to teach you how to use the essential tools in Excel.


  • +

    Course Syllabus

    • Sharing workbooks with others
      • Introduction
      • Save and Send options
      • Using Comments In Excel
      • Using Hyperlinks
    • Protecting and maintaining a workbook
      • Introduction
      • Customising advanced properties
      • Saving as a template
      • Importing and Exporting XML data
      • Protecting a worksheet and workbook
    • Track changes
      • Introduction
      • Turning on track changes
      • Accept and Reject changes
      • Sharing workbooks
      • Restricting Access to a shared workbook
    • Naming Cells
      • Introduction
      • Naming a cell or a range of cells
      • Moving to named cells
      • To delete or edit a named cell
    • Data lists
      • Introduction
      • Adding cutsom lists
      • Advanced sort options
      • Applying conditional Formatting
      • Applying Filters
      • Applying custom filters
      • Subtotalling a list
      • Grouping and outlining data
      • Data validation
      • Drop down menus using validation lists
      • Creating a table to manage lists
    • Advanced Formulae
      • Introduction
      • V and H lookup Functions
      • SUMIF Function
      • COUNTIF Function
      • Arrays
      • Database Functions
    • Advanced Charts and Graphs
      • Introduction
      • Trendlines
      • Dual Axes
      • Saving a Chart Template
      • Sparklines
      • Advanced Sparklines options


Course Fee:
USD 25

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

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

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