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
• 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
• 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
• 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
• Conclusion
• Conclusion

Course Fee:
USD 59

Self-Study

### Course Status:

Active

1 - 4 hours / week

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

Related Posts: