
Master the most important 20 Excel functions with an introductory overview of how functions work in Excel.
Master the sum function in Excel with part 1 of our essential guide, unlocking quick total calculations and foundational skills for the 20 most important Excel functions.
Master the Excel sum function (part two) by applying the sum to ranges and data in practical, error-free calculations to boost spreadsheet accuracy.
Master the essential Excel functions such as average, count, max, and min. Learn to apply these to analyze data accurately and efficiently in spreadsheets.
Master the large function in Excel to extract ranking values from data, a key skill among the course's 20 essential Excel functions.
Master the sumifs function in Excel, applying criteria to perform conditional sums and enhance data analysis with essential Excel functions.
Learn to apply Excel's conditional sum with the SUMIFs function in part two of the course on the top 20 Excel functions, advancing your data handling skills.
Master the conditional average with the averageifs function in Excel. Learn to handle the average range to compute precise averages across datasets.
Master countifs in Excel to perform conditional counting across datasets, applying multiple criteria to analyze and compare data efficiently.
Master how to use drop-down menus inside conditional statistical functions in Excel's top 20 functions, enabling dynamic data analysis and precise decision making.
Master essential Excel functions while learning how to adjust date settings in Windows, enabling precise data handling and streamlined workflow across desktop environments.
Master the days function in Excel as part of the top 20 functions course, and apply it within practical spreadsheet workflows.
Master the days and weekday functions in Excel, using the days function to count elapsed days and the weekday function to extract the day’s order for robust data analysis.
Learn how to use the datedif function to calculate the difference between two dates in Excel, enabling precise date calculations within your workflows.
Master the trim function to clean and normalize text in Excel, a core skill in the course on the 20 most important Excel functions.
Master the Excel text function to convert dates into text, enabling flexible formatting and data presentation across the most essential 20 functions.
هذا هو الجزء الثاني من دورة المساق التأسيسي من سلسلة إكسل لكل العرب، وسنتعرف في هذا القسم على كيفية العمل بشكلٍ احترافي على أهم 20 دالة رياضية في برنامج إكسل، حيث سنتكلم عن الدالات الإحصائية - الدالات النصية - دالات التاريخ - دالات البحث وغيرهم من الدالات الرئيسية، مع العديد من الأمثلة لكل دالة من هذه الدالات