Welcome to Excel Maven Program – EMP

Welcome! You are now part of the Excel Mavens Program!

As a Maven, you have exclusive access to resources that are available only on this page. In time, you will receive value packed rewards delivered directly in your inbox. Don’t forget to whitelist [email protected] or mark as safe or Not Spam in your inbox.

Let’s Excel!

Free Excel Resources

Free Excel Core Book

If you are just starting and need one guide to go beyond beginners then this is it! Covering the basics and moving you straight to the core of Microsoft Excel skillset!

With Excel tips and tutorials, this companion guide is your chance to ace Excel!

Download Free Excel Core Book

Download Practice Workbooks

Practice WorkbookTutorial Post/Video
0033 Running Totals in Excel.xlsxRunning totals and Running balance in Excel – How to
0034 Calculating Depreciation in Excel.xlsxCalculating Depreciation of assets in Excel – How to
0035 Payroll Simple.xlsxPayroll calculation in Excel – Straight Piecework Wage System – How To
0037 Payroll Guaranteed Wage.xlsxPayroll calculation in Excel – Piecework with Guaranteed wage – How To
0038 Payroll Simple Differential.xlsxPayroll calculation in Excel – Simple Differential Piecework – How To
0039 Payroll Differential Piecework.xlsxPayroll Calculation in Excel – Differential Piecework with Multiple Scales – How To
0040 Data Entry using Data Validation.xlsxAutomating Data Entry using Data Validation in Excel
0044 Excel Table Tricks.xlsx20+ Excel Table tricks to turbo charge your data
0045 Excel SUMPRODUCT Function.xlsxConditional SUM with Excel SUMPRODUCT function – Intro + Examples
0047 SUM Top N Values.xlsx10+ ways to SUM Top N values in Excel data range – Ready to be Ben 10 of Excel?
0052 Pivot Tables.xlsxExcel Pivot Table tutorial for Absolute Beginners: Creating your First Pivot Report [2 of 2]
0055 Slicers.xlsxExcel Pivot Table Slicers: Old Filters got Overhauled!
0057 Running Totals in Pivot Tables.xlsxRunning Totals and Running Balance with Excel Pivot Tables – How To
0058 Group by Date and Time.xlsxExcel Pivot Tables – Grouping Data by Date and Time
0059 Group Dates Pivot Tables.xlsxExcel Pivot Tables – Grouping Dates by Week Within Months, Quarters or Years – Workaround
0060 Fill Blank Cells with value.xlsxQuickly fill Blank cells with the Value in the Cell Above
0061 Excel VLOOKUP.xlsxHow Excel VLOOKUP Works: How to use it – Explanation with Example
0062 Remove Leading Apostrophe.xlsxRemove leading Apostrophe (‘) in Excel Data from Numbers and Text – How To
0064 Building Worksheet Reference.xlsxBuilding a reference to specific Worksheet based on Cell value using Formula
0065 Dynamic Data Validation Lists.xlsxExcel Drop Down List using Data Validation and Excel Tables that updates dynamically – How To
0066 Simple Dial Chart.xlsxCreate Simple Dial Charts in Excel – How To
0067 Conditional Charts.xlsxConditional Charts in Excel – Workaround + How To
0072 Conditional Count.xlsxConditional COUNT in Excel: Count cells meeting multiple criteria + Data Cleanup Tip
0074 Aging Analysis Reports.xlsxMaking Aging Analysis Reports Using Excel – How To
0077 Adding Prefix.xlsxAdding specific Prefix to All cells or Specific cells in Excel – 3 Methods Explained
0078 Highlight Duplicates.xlsxComparing two columns to highlight Duplicates in the same row – Excel Conditional Formatting
0085 Multiple lookup ranges.xlsxExcel Conditional VLOOKUP – Switching Between Multiple Lookup Ranges
0094 variance chart.xlsxVariance Analysis in Excel – Making better Budget Vs Actual charts
0097 Project Timeline Chart.xlsxCreate Project Timeline Charts in Excel – [How To] + Free Template
0111 Data Validation Lists from Unsorted data.xlsxCreate Data Validation lists from Unsorted data with duplicates in Excel [How To]
0113 LOOKUP using Conditional Formatting.xlsxHow to LOOKUP using ONLY Conditional Formatting in Excel
0114 ABC Analysis.xlsxABC Analysis using Conditional Formatting in Excel
0117 Invoice Template.xlsxFREE Excel Invoice Template V1.0 with Customer and Product list – Unlocked + Download ready!
0118 ABC Analysis Chart.xlsxABC Inventory Analysis using Excel Charts
0123 Sales Dashboard in Excel.xlsxMaking Sales Dashboard using Excel Slicers – How To
0124 Excel SUMIFS.xlsxExcel SUMIFS function – Summing up Invoices based on multiple criteria
0125 Broken line Chart.xlsxExcel Actual Vs Target – Multi type charts with Subcategory axis and Broken line graph
0126 Top Bottom N Chart.xlsxExcel chart of Top / Bottom “N” values using RANK() function and Form controls
0127 Conditional Charts.xlsxConditionally Format Chart’s Background in Excel – How To
0128 Highlight Chart Instances.xlsxHighlight instances in Excel charts in different colors with shaded bars in background
0131 Restructure Data using Power QueryPrepare (Normalize) the data for Pivot Tables using Power Query
0132 Restructure Data using Pivot Tables.xlsxRestructuring (Normalizing) data for Pivot tables using Pivot tables – How To
0133 Append Tables.xlsxCombine or Append data in one table from multiple sources using Power Query in Excel
0134 Making Profit and Loss using Pivot TablesMaking Profit and Loss Statements in Excel using Pivot tables
0135 Profit and Loss Analysis using Pivot TablesBudget Vs Actual – Analyzing Profit and Loss Statements in Excel using Pivot tables
0136 CapEx.xlsxPreparing Fixed Asset (CapEx) forecast model in Excel – Depreciation & NBV Calculations
0138 Highlight Data Points.xlsxDynamically Highlight data points in Excel charts using Form Controls
0139 Cash Flow Summary.xlsxMaking Cash flow summary in Excel using Pivot tables with data on multiple worksheets
0140 Budget with Limits.xlsxMake Budgets in Excel with Expenditure Limit – Budget Ceiling using Data Validation [How To]
0142 In-cell variance chart.xlsxBudget vs Actual Variance Reports with “In the Cell Charts” in Excel
0145 Waterfall Chart.xlsxCreate Waterfall Charts in Excel – Visualize Income Statements!
0147 Waffle Chart.xlsxMake Waffle Charts in Excel using Conditional Formatting – How To
0153 FIFO.xlsxFIFO Inventory Valuation in Excel using Data Tables – How To
0154 Moving Average in Excel.xlsxCalculate Moving Average in Excel – How To
0157 Aging Analysis with Pivot Tables.xlsxMaking Aging Analysis Reports using Excel Pivot Tables – How To
0158 Sensitivity Analysis using Data Tables.xlsxMaking Financial Decisions with Excel – Sensitivity analysis using data tables
0159 Breakeven Analysis using Goal Seek.xlsxBreak-even + Target profit analysis with Excel Goal Seek – How To
0161 Currency Bill Calculator.xlsxDetermine number of currency bills or notes for any amount – Currency bill Calculator [How To]
0162 Stock Aging.xlsxStock Ageing Analysis Reports using Excel – How To
0165 Advanced VLOOKUP.xlsx5 Advanced Excel VLOOKUP tricks you MUST know!
0166 Excel DSUM.xlsxExcel DSUM Function – “The” Sum function you MUST know
0167 BCG Matrix.xlsxMaking BCG Matrix in Excel – How To
0168 Pivot with Power Query.xlsxPivot data using Power Query to show text values – Data Restructuring using Excel – How To
0171 Split Numbers.xlsxSplit numbers into integer and decimal parts in Excel – Quick Tip
0172 Slope or Bump Chart.xlsxMaking a Slope Chart or Bump Chart in Excel – How To
0173 Excel Data Labels ON OFF.xlsxEnable or Disable Excel Data Labels at the click of a button – How To
0179 Multi Column Data Validation.xlsxMultiple Column Data Validation Lists in Excel – How To
0182 Convert Dates to Quarters.xlsxConverting Dates to Quarters for Usual or Custom Fiscal Year using Excel Power Query
0183 LIFO in Excel.xlsxLIFO Inventory Valuation in Excel using Data Tables – How To
0184 Gantt Chart Template.xlsxGantt Chart in Excel – How To + Free Template + Online Gantt Chart Creator
0185 Gantt Chart Template.xlsxAdd a vertical line to Gantt Chart or Stacked Bar Chart in Excel – How To
0186 Vertical Actual vs Target Chart.xlsxVertical Actual vs Target Charts in Excel – Top to Bottom Variance Analysis using Bar Charts
0187 Variance Chart with Floating Bars.xlsxActual vs Target Variance Charts in Excel with floating bars
0188 Variance Chart Dummy data.xlsxExcel Variance Charts: Making Awesome Actual vs Target Or Budget Graphs – How To
0189 Dot Plot Chart.xlsxMaking Horizontal Dot Plot or Dumbbell Charts in Excel – How To
0190 Dependent Drop-down List.xlsxMaking Dependent Drop-down Lists in Excel – How To
0191 Add Secondary Axis in Excel charts.xlsxAdding a Secondary Axis in Excel Chart – Making Double or Dual Axis Charts – How To
0195 Excel DGET Function.xlsxExcel DGET Function – How to use guide with Examples
0196 Left lookup with XLOOKUP.xlsxExcel Left LOOKUP with XLOOKUP
0197 Get Month Names from Dates.xlsxGet Month Name from Date in Excel – 5 Ways
0198 Highlight Weekend Dates.xlsxHighlight Weekend Dates in Excel – How To
0200 Get Day Names from Dates.xlsxGet Day Name from Date in Excel
0201 Excel COUNTIFS Function.xlsxCOUNTIFS Function in Excel
0202 Excel FILTER Function.xlsxHow to use Excel Filter Function with Formula Examples
0206 List All dates between dates.xlsxHow to List All dates, Workdays or Weekends only dates between two dates using Formula
0207 Remove Blank Rows using Formula.xlsxRemove Blank Rows in Excel using Formula
0208 Hi Low in different color in Charts.xlsxConditional Formatting in Excel Charts – Max and Min Values in different Colors in Excel Charts
0209 Dot Plot Chart.xlsxHow to make Dot Plot Chart or Dumbbell chart or DNA chart in Excel – Actual vs Target Chart in Excel
0210 Top five chart.xlsxExcel Pro Trick: Make Top 5 Ranking Chart in Excel Show Top N values with position number in Excel
0211 Count or Sum based on Multi Criteria.xlsxHow to Count or Sum based on Multiple Criteria in Excel: Conditional SUM / Conditional COUNT Formula
0212 Aging Analysis with Pivot Tables.xlsxCreate Aging Analysis Reports in Excel with Pivot Table, VLOOKUP & IF Functions: Free Excel Template
0213 XLOOKUP with SUMIFS.xlsxXLOOKUP + SUMIFS: How to Lookup and Sum All Matching Values Based on Multiple Criteria in Excel
0214 FILTER Function.xlsxExcel Pro Trick: Filter Data Dynamically with Excel FILTER Function – How to Tutorial
0215 Actual vs Target.xlsxActual vs Target Charts in Excel: How to make variance charts in Excel with floating markers or bars
0216 Running Totals in Excel Pivot Tables.xlsxExcel Pro Trick: Calculate Running Total in Excel Pivot Tables in seconds: No Formula Method: How To
0217 Filter based on month.xlsxExcel Pro Tricks: Dynamically Filter Data based on Month with FILTER function in Excel Formula
0218 Banded Chart in Excel.xlsxExcel Pro Trick: Make #Excel Charts with Threshold / Target Range / Bands in the Background – How To
0219 Dynamic Monthly Calendar.xlsxCalendar in Excel: Make Dynamic, Interactive Calendar in Excel with Formula + Conditional Formatting
0220 VLOOKUP with SUM.xlsxVLOOKUP + SUM: How to use Excel VLOOKUP and SUM all the matches results in multiple columns in Excel
0221 IF with Multiple Conditions.xlsxExcel Pro Trick: How to use IF Function with Multiple Conditions in Excel: IF Formula Tutorial
0222 SUM Comma Separated values TEXTSPLIT LAMBDA.xlsxExcel Pro Trick: Sum Comma Separated Values in Excel with Formula using TEXTSPLIT + LAMBDA Function
0223 Combine Multiple Columns TOCOL.xlsxExcel Pro Trick: Combine Merge Multiple Columns into One Column with #Excel TOCOL Function Quickly
0224 Multi Column Sort.xlsxExcel Pro Trick: Dynamic Multi Column / Multi Level Sort in Excel with SORT Function in Formula
0225 Number Formatting with Color and Symbol.xlsxHow to Use Excel Custom Number Formatting to show Positive / Negative Numbers in Colors with Symbols
0226 VLOOKUP with Multiple Criteria.xlsxHow to VLOOKUP with Multiple criteria in Excel – Use Excel VLOOKUP with Criteria in Multiple Columns
0227 Pass Fail without Formula.xlsxExcel Pro Trick: How to Grade Pass/Fail in Excel with Custom Number Formatting – No Formula Method
0228 Attendance Sheet in Excel.xlsxMake Attendance Sheet in Excel: Count Workdays using Excel formula with Overtime Half-day and Leaves
0229 XLOOKUP Return Multiple Columns.xlsxExcel Pro Tricks: XLOOKUP to return Multiple Columns and Rows in Excel formula with XLOOKUP Function
0230 Correct Date Format.xlsxExcel Pro Trick: Format numbers in Correct Date Format in Excel with TEXT function in Excel formula
0231 LOOKUP and Return Multiple Columns.xlsxExcel Pro Tricks: Lookup and Return Multiple Specific Non-Adjacent Columns in Excel – INDEX & XMATCH
0232 Highlight Active Cell Row Column.xlsxExcel Pro Trick: Highlight Active Cell, Active Row and Active Column in Excel Based on Selected Cell
0233 Gradesheet with Lookup.xlsx#Excel Pro Trick: Make Grade Sheet for Students, Calculate Grades using Excel formula
0234 Top N Bottom N.xlsxExcel Pro Trick: Find Top N and Bottom N Values in Excel using FILTER Function in Excel Formula
0235 Excel DSUM Function.xlsxDSUM: How to use DSUM Function in Excel Formula to Sum Values Based on Multiple Criteria – Example
0236 Count Comma Separated Values.xlsxCount Comma Separated Values in Excel using Formula – Two Methods
0236 Count CSV.xlsxHow to Count Comma Separated Values in #Excel using Formula – Count CSV Formula #exceltips
0237 Aging Analysis in Excel.xlsxCreate Aging Analysis Report in Excel