Microsoft Excel – MS Excel Formulas & Functions in just 3hrs

سرفصل های دوره

All important Microsoft Excel formulas and functions covered within 3 hours | Must-know MS Excel formulas and functions

01 - Introduction

001 Introduction

002 Course Resources.html

002 Microsoft-Excel-MS-Excel-Formulas-Functions-in-just-3hrs.zip

02 - Basic Formula Operations and Mathematical Functions

001 Basic Formula Operations

002 This is a milestone!

003 Mathematical Functions Part 1

004 Mathematical Functions Part 2

005 Exercise - Mathematical Functions.html

005 Session1-Exercise.xlsx

005 Session1-Solution.xlsx

03 - Textual Functions

001 Textual Functions Part 1

002 Textual Functions Part 2

003 Exercise - Textual Functions.html

003 Session2-Exercise.xlsx

003 Session2-Solution.xlsx

04 - Logical Functions

001 Logical Functions

002 Exercise - Logical Functions.html

002 Session3-Exercise.xlsx

002 Session3-Solution.xlsx

05 - Date-time Functions

001 Date-time Functions

002 Exercise - Date-time Functions.html

002 Session4-Exercise.xlsx

002 Session4-Solution.xlsx

06 - Lookup Functions (V Lookup, Hlookup, Index-Match)

001 Lookup Functions (V Lookup, Hlookup, Index-Match)

002 Exercise - Lookup Functions.html

002 Session5-Exercise.xlsx

002 Session5-Solution.xlsx

07 - New! XLookup - only Excel 2021 and Office 365

001 Lecture-XLookup-Solved.xlsx

001 Lecture-XLookup-unsolved.xlsx

001 XLookup as a replacement of Vlookup

002 Handling #NA and Approximates match in Xlookup

003 Wildcard matching in XLookup

004 Search modes in XLookup

08 - Data Tools

001 Data-Tools.xlsx

001 Sorting, Filtering and Data Validation

002 Text-to-columns and remove duplicates

003 Advanced filter option

003 Advanced-Filters.xlsx

003 Advanced-Filters-solved.xlsx

09 - Indirect Function

001 Named Ranges

002 Indirect Function

10 - Financial Functions

001 Loan Repayment concepts

002 Excel Calculating Payments

003 Excel Calculating Rate or Term

004 Depreciation Methods and Straight Line Method

005 Double Declining Balance Depreciation

006 Sum of Years Digits Method

007 Excel Calculating Depreciation

11 - Pivot Tables

001 Pivot Tables

12 - Bonus Section

001 Popular Excel charts.html

002 The final milestone!

003 Bonus Lecture.html

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy