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

Excel A 2 Z - An In depth Tutorial with Simplest logics

Course Summary

Learn Excel in just few hours...


  • +

    Course Syllabus

    • An Introduction
      • An Intro
      • Introduce yourself to Excel 2007/2010/2013
    • File Conversion
      • Converting Older version file to a New version
      • Converting Newer Version file to an Older Version
    • Using Sum Functions
      • How to write a Formula in Excel
      • How to Use Sumif
      • Using Sumifs for Multiple Conditions
    • Using Count Functions
      • Count text entries using COUNTA
      • Count number of blank entries using CountBlank
      • Count with a condition using COUNTIF
      • Count with multiple conditions using COUNTIFS
    • Using Text functions
      • An Introduction to Basic Text Functions
      • Some more Text Functions
      • Text to Column - A Complex Function
    • Using Logical functions
      • If Function
      • If with And
      • If with Or
      • Nested If
    • Understanding Lookup functionality
      • 4 Types of References
      • Vlookup with False
      • Vlookup with True
      • Vlookup with Mixed References
      • Vlookup with IF Function - a nested function
      • Hlookup - lookup in horizontal way
      • Lookup - no "V" no "H" only lookup
      • Index & Match - the power of two
    • Date & Time Functions
      • The Basics of Date & Time Functions
      • Understanding how Excel records and stores dates
      • Understanding how Excel records and stores time
      • Looking at standard date time entry options and acceptable alternatives
      • Using instant date time entry
      • Using TODAY and NOW functions for dynamic date time entry
      • Using Auto Fill to enter date and time series
      • Exploring keystroke shortcuts
      • Formatting time for hours over 24
      • Creating custom date formatting
    • Using Financial Functions
      • Calculate an Installment of a loan using PMT Function
      • Calculate Interest per period using IPMT
      • Calculate Principal per period using PPMT
      • Calculate Rate of Interest if not known
      • Calculate the term of loan using NPER Function
      • Calculate the Present value using PV
      • Create a Loan Table
      • Calculate Depreciation in Excel
      • Misc. Functions
    • Sort & Filter Functions
      • Sort Data as per your requirement (Custom Sort)
      • Sort data by Column or Row (with different levels)
      • Filter Data
      • Filter Data with Conditions
      • Filter Data with Complex conditions (ADVANCED FILTER)
    • Excel Charts - In depth
      • First thing First - How to Creat a Chart
      • Play with Design & Layout of Chart
      • Link a Chart Title
      • How to Show Axis Titles
      • How to show Data lables
      • Show data with chart in Data Table
      • Column Chart
      • Bar Chart
      • Line Chart 1
      • Line Chart 2
      • Line Chart with Log Scale
      • Area Chart
      • Pie Chart
      • Pie of Pie or Bar of Pie
      • Bubble Chart
      • Selecting Chart elements
      • Use of Format Dialog box
      • Modifying Chart & Plot area
      • Modifying Data Series
      • How to handle missing Data
      • Modifying 3-D Charts
      • Creating Combination of Charts
      • Creating Chart Templates
      • Creating Picture Charts
    • Consolidate Data from different Workbooks/Worksheets
      • Data Consolidation Function
    • Data Validation & Protection
      • Data Validation
      • Protect Worksheet
    • Pivot Table
      • Understanding Pivot Table
      • Pivot Table Query 1
      • Pivot Table Query 2
      • Pivot Table Query 3
      • Pivot Table Query 4
    • What If Analysis & Solver Add-In
      • Goal Seek
      • One Way Data Table
      • Two way Data Table
      • Scenario Manager
      • Solver Add-in
    • Array Formula
      • How to apply an Array Formula
      • Array with Numbers
      • Array with Text
      • Average with Array
    • Macro & VBA Intro
      • What is a Macro
      • Show developer Tab
      • 3Ways to record a macro
      • Record your first Macro
      • Use Relative Reference
      • Monthly Report Macro
      • Assign a Macro to a Shape
      • How to edit or delete a Macro
      • Security Settings of Macro
    • Macro Controls & Buttons
      • Text Box Control
      • Scroll Bar
      • Combo Box
      • Option Button
      • Check Box
      • Lable control
      • Command Button Control
      • Image Control
      • Calendar Control
    • visual basic for applications (VBA) Introduction
      • Introduction to VBE
      • How to read coding
    • Conclusion
      • Conclusion


Course Fee:
USD 59

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