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

Course Summary

A complete guide to learn the essential as well as the advanced features in Microsoft Excel 2010.


  • +

    Course Syllabus

    • Introduction to Excel 2010
      • Introduction to excel
      • Exercise files
    • Data Entry
      • Layout of excel
      • Entering data into cell
      • Understanding the backstage view
      • Alignment of entered data
      • Formatting the entered data
      • Autofill in depth
    • Shapes & data selection
      • Inserting and editing shapes
      • Cut Copy and paste
      • Selection of data
      • Inserting rows and columns
    • Formula's and Function's
      • Formulas
      • Functions
      • Creating range names
      • Using range names
      • Basic functions
      • References
      • If function
      • Sumif and average if
      • General math functions
      • Dates
      • More about dates
      • Using formula across sheets
      • Formula Auditing
    • Conditional Formatting & Cipart
      • Conditional formatting
      • More on conditional formatting
      • Calculating your age
      • Pictures and clipart
      • Smartart
      • Inserting tables
    • Themes & Printing
      • Worksheet theme
      • Applying theme
      • Creating your own template
      • printing
      • More on printing
      • Headers and footers
      • Inserting watermarks
      • Creating PDF
      • Freezing panes
    • Charts
      • Introduction to charts
      • Inserting column bars
      • Customizing chart
      • Pie charts
      • Sparkline
      • Editing the data series
    • Managing Rows and columns
      • Hiding rows and columns
      • Outlines
      • Working with sheets
      • Inserting hyperlink
      • Find select and sort filter
      • Comments
    • Data Tools
      • Compound interest rate
      • Loan calculations
      • Present value, period and rate
      • Creating loan schedule
      • Using data tables
      • Using two way data tables
      • Goal seek
      • Scenario manager
    • Data Validation
      • Joining cells
      • Splitting the cell data
      • Uppercase and lowercase
      • Vlookup function
      • Hlookup function
      • Data validation
    • Pivot tables & charts
      • Pivot tables
      • More on pivot tables
      • Formatting pivot tables
      • Pivot charts
      • From web
    • Miscellaneous
      • Sumif and sumifs function
      • Countif and countifs function
      • Opening a file in Excel 2007
      • Linking workbooks
      • Opening a file that contains links
      • Consolidating data
    • Conclusion
      • Conclusion


Course Fee:
USD 10

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