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 With Ease: Master Excel Spreadsheets

Course Summary

This course is a Microsoft Excel tutorial that takes your Excel skills to the next level. It is an Excel training class.

• +

Course Syllabus

• A Few Things Before We Begin
• Welcome!
• How To Learn Excel In This Course
• First Things First
• Microsfot Excel User Interface
• How To Enter Data In Excel
• How To Use Fill Series (The Fill-handle Tool)
• How To Move Around An Excel Spreadsheet And Select Cells
• Easy Direct Formatting In Excel
• Formulas - The Power Of Excel
• Easy Excel Formulas
• Easy Excel Functions Basics
• Relative And Absolute Cell References In Excel
• Using AutoSum In Excel
• Easy Text Functions
• Working With Dates
• Excel TODAY and NOW Functions
• Logical Functions
• Logical IF Function Introduction
• Excel Logical Functions: AND, OR
• Using Logical Functions IF, AND, OR Together
• Exercise Using IF AND SUM (courtesy of Björn Már Sveinbjörnsson)
• Conditional Statistical Functions
• SUMIF and SUMIFS: Conditional Sum in Excel
• AVERAGEIF and AVERAGEIFS: Conditional Average
• COUNTIF and COUNTIFS: Conditional Count
• COUNTIFS Conditional Number Counting (courtesy of Björn Már Sveinbjörnsson)
• VLOOKUP Function Tutorial
• VLOOKUP Function Introduction
• Fill Data With VLOOKUP Function
• Excel VLOOKUP With Approximate Match
• VLOOKUP With A Named Range As Table Array
• Use Excel Table In VLOOKUP
• Loan Payment Calculations With PMT (Newly Added)
• Monthly Loan Payment With PMT Function
• Goal-Seek Analysis Tool
• A Few More Important Things
• More on Formatting
• Printing in Excel
• Thank You!

Course Fee:
USD 39

Self-Study

Course Status:

Active

1 - 4 hours / week

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

Related Posts: