31,751 views
In the first video of the series of accounting videos using Excel, we present the most important equations in Excel for novice accountants, as we review a group of important and professional equations in Excel that every accountant uses, and every accountant must be aware of and master these equations and functions. These equations have been divided into 4 groups, which are (equations related to dates in accounting - arithmetic equations for accounting - equations that depend on logic and benefit from them in accounting - the most important and easiest equation and search function in Excel, which is the VLOOKUP function, and also how to use it with the TRIM function in Excel) ⏱Time Stamps: 00:00 Introduction 00:40 The first group - Equations for dealing with dates 12:05 The second group - Arithmetic equations 27:55 The third group - Logic equations 32:02 The fourth group - Search equations -------- Videos of interest to you ► Calculating customer debt aging in Excel: • Using data analysis Calculating aging ... ► Explanation of the EDATE function in Excel to calculate the expiration date: • Explanation of the EDATE function in Excel to calculate the expiration date ... ►6 tips for dealing with complex equations in Excel: • 6 tips for dealing with complex equations ... ►Search in more than one sheet using INDEX + MATCH: • Search in more than one sheet in Excel using ... ►5 reasons why equations do not work in Excel and how to solve them: • 5 reasons why equations do not work in Excel and ... -------- To communicate [email protected] ✅ To download the work file https://bit.ly/3EKFpZ7 ✅ Subscribe to the channel to receive all new videos https://bit.ly/3fAUJus ✅ Facebook group / excelonline1