100+ Excel Functions (explained with Examples and Videos) Here you will find a detailed tutorial on 100+ Excel Functions & VBA Functions. Each Excel function is covered in detail with Examples and Videos. .7This Tutorial Covers:Excel Functions – Date and Times Excel Functions – LogicalExcel Functions – Lookup & ReferenceExcel Functions – MathExcel Functions – StatisticsExcel Functions – Text FunctionsExcel Functions – InfoVBA FunctionsExcel Tools Excel Functions - Date and Times EXCEL FUNCTION – DATEEXCEL FUNCTION – DATEVALUEEXCEL FUNCTION – DAY, MONTH, YEAREXCEL FUNCTION – WEEKDAYEXCEL FUNCTION – NOWEXCEL FUNCTION – TODAYEXCEL FUNCTION – NETWORKDAYSExcel Function – WORKDAY.INTLExcel Function – WORKDAY Excel Functions – Logical EXCEL FUNCTION – AND, OR, NOT EXCEL FUNCTION – IFEXCEL FUNCTION – ISERROREXCEL FUNCTION – ISBLANKEXCEL FUNCTION – COUNTIFEXCEL FUNCTION – IFSEXCEL FUNCTION – COUNTIFS Excel Functions – Lookup & Reference EXCEL FUNCTION – COLUMNEXCEL FUNCTION – COLUMNSWhat is VLOOKUP in Excel?EXCEL FUNCTION – INDEXEXCEL FUNCTION – MATCHEXCEL FUNCTION – INDIRECTCreate Dynamic Data Validation List – Offset Function MethodEXCEL FUNCTION – ROWEXCEL FUNCTION – ROWSFind Duplicate Files In Excel Using VBA Excel Functions – Math EXCEL FUNCTION – INTEXCEL FUNCTION – MODEXCEL FUNCTION – RANDHow to Use RAND and RANDBETWEEN Functions in ExcelEXCEL FUNCTION – ROUNDExcel Function – SumEXCEL FUNCTION – SUMIFEXCEL FUNCTION – SUMIFSEXCEL FUNCTION – SUMPRODUCT Excel Functions – Statistics EXCEL FUNCTION – RANKEXCEL FUNCTION – AVERAGEEXCEL FUNCTION – AVERAGEIFEXCEL FUNCTION – AVERAGEIFSEXCEL FUNCTION – COUNTEXCEL FUNCTION – COUNTIFEXCEL FUNCTION – COUNTIFSEXCEL FUNCTION – COUNTBLANKEXCL FUNCTION – COUNTAEXCEL LARGE FUNCTIONEXCEL FUNCTION – SMALLEXCEL FUNCTION – MAXEXCEL FUNCTION – MIN Excel Functions – Text Functions EXCEL FUNCTION – CONCATENATEEXCEL FUNCTION – FINDEXCEL FUNCTION- LEFTEXCEL FUNCTION – LENEXCEL FUNCTION – MIDEXCEL FUNCTION – LOWEREXCEL FUNCTION – PROPERExcel Function ReplaceEXCEL FUNCTION – REPTEXCEL FUNCTION – RIGHTEXCEL FUNCTION – SEARCHEXCEL FUNCTION – SUBSTITUTEEXCEL TEXT FUNCTIONEXCEL FUNCTION – TRIMEXCEL FUNCTION – UPPER Excel Functions – Info EXCEL FUNCTION – ISBLANKEXCEL FUNCTION – ISERROR VBA Functions Excel VBA Tool to Create FoldersVBA Code to Re-link MS Access Link TablesVBA Code to List Files in FolderVBA Code to Check if File Exist in FolderVBA Code to Add New Sheet at Beginning or End of Excel FileVBA Code to Get User NameVBA Code to Delete All Shapes On A Excel SheetVBA Code to Convert Excel Range into HTML TableHow to Add Outlook Reference in Excel VBAVBA Code to Hide Menu Ribbon in MS AccessVBA Code to Export Access Recordset to ExcelVBA Code to Send Outlook EmailsVBA Code to Draft Outlook EmailsVBA Code to Read Outlook EmailsVBA Code to Browse a FolderVBA to Browse Outlook FolderVBA Code to Count Color Cells with Conditional FormattingVBA to Open Workbook in ExcelColorIndex in Excel VBAVBA Code to Check if Folder ExistVBA Code to Remove Duplicate RowsVBA Code to Count Cells by ColorVBA Code to Sum Cells by ColorVBA Code to Delete FileVBA Code to Add Border to Excel RangeVBA Code to Protect Excel Sheet for Manual Input but Allow Programming InputsVBA Code to Add Items in ListBox Control in UserformFind Duplicate Files In Excel Using VBAVBA Code to Find Last Column or Row of a SheetVBA to Read Excel Data using Connection StringExcel VBA Tool to Rename FilesVBA Code to Change Sheet ColorVBA Code to Sort DataVBA Code to Filter Data in ExcelVBA Tool to Merge Excel Files from a FolderVBA Code to Change Cell ColorVBA Code to Convert MM.DD.YYYY to DD-MMM-YYYY In ExcelFew Simple Excel Tips – Excel Learner Should KnowExcel VBA Tool to Get File PropertiesHow to Hide Sheet in Excel with or without VBA?Excel VBA Tips you Must Know – Part 1 Excel Tools Merge Cells in Excel (Step by Step Guide)Duplicate Data Identifier ToolFile Manager ToolFile Properties ToolDuplicate Files Finder ToolDummy Data Generator ToolExcel Files and Sheets Data ConsolidationOutlook Bulk Email ToolRandom Rows Selector Tool – Unprotected VersionOutlook Email Management ToolTime and Motion TrackerTime and Motion Professional TrackerIntroduction to Power QueryHow to Create Pie Chart in Excel (Complete Tutorial)How Histogram Works in Excel? (Definitive Guide)Time Management Tools and TrackersQR Code Generator Tool in ExcelColorIndex in Excel VBAHOW TO COMPARE TWO COLUMNS IN EXCELDummy Data Generator ToolEmployee Database ToolSimplest Way to Create Excel Add-inCalculations with Date in ExcelPivot Table For Beginners – Part 1Few Simple Excel Tips – Excel Learner Should KnowImpress your Clients by Hiding these Simple FeaturesProtect Sheets, Share Workbook, Protect Workbook