Excel Pro Tips
Excel Formula to Find If Date Is Less Than Today (4 Examples)
Learn how to use Excel formulas, conditional formatting, and VBA to check if a date is less than today and display status effectively.
Read article
Author & Spreadsheet Consultant
Wasim Akram
71 Articles PublishedPublishing since
Wasim Akram holds a BSc in Industrial and Production Engineering and has around four years of hands-on Excel and Google Sheets experience. He specializes in formulas, lookups, PivotTables, dashboards, charts, data cleaning, macros, VBA, and Google Apps Script. He has created 300+ tutorials that helped over 100,000 users solve data problems. He enjoys exploring advanced formulas and building automated templates that simplify daily tasks.
Editorial Review
Articles Published by Wasim Akram
Articles by Wasim Akram are developed under the guidance of ExcelInsider’s core training program and are technically reviewed by Nehad Ulfat, lead spreadsheet consultant, to ensure accuracy and user-centric value.
Data Analysis with Excel
How to Establish Data Model Relationships in Excel
Learn how to establish data model relationships in Excel using tables, PivotTables, and relationships to analyze data efficiently.
Read article
Data Analysis with Excel
How to Solve for X in Excel (Using Goal Seek & Solver Tools)
Learn how to solve for x in Excel using Goal Seek and Solver with easy step-by-step instructions for accurate results.
Read article
Data Analysis with Excel
How to Use Solver in Excel (2 Practical Examples)
Learn how to use Solver in Excel with step-by-step examples for optimizing production and managing budgets effectively.
Read article
Data Analysis with Excel
3 Real-Life Examples with Goal Seek in Excel
Learn how to use Goal Seek in Excel with 3 real-life examples: loan calculation, profit planning, and final exam score targeting.
Read article
Data Analysis with Excel
How to Use Scenario Manager in Excel (with Simple Steps)
Learn how to use Scenario Manager in Excel to create, manage, and compare multiple budgeting scenarios with a clear summary report.
Read article
Data Analysis with Excel
How to Create Two Variable Data Table in Excel (with Quick Steps)
Learn how to create a two-variable data table in Excel with step-by-step instructions: calculate, set range, and apply the Data Table tool.
Read article
Data Analysis with Excel
How to Create a One Variable Data Table in Excel (2 Scenarios)
Learn how to create a one-variable data table in Excel with step-by-step examples and scenarios to simplify data analysis and forecasting.
Read article
Data Analysis with Excel
How to Do Sensitivity Analysis in Excel (3 Suitable Examples)
Learn how to do Sensitivity Analysis in Excel using Data Tables, Goal Seek, and Solver to evaluate decision-making scenarios effectively.
Read article
Data Analysis with Excel
How to Use What-If Analysis in Excel (3 Suitable Examples)
Learn how to use What-If Analysis in Excel with Scenario Manager, Goal Seek, and Data Tables for effective decision-making.
Read article
Data Analysis with Excel
How to Analyze Likert Scale Data in Excel (with Simple Steps)
Learn how to analyze Likert scale data in Excel with step-by-step guidance, from counting feedback to creating charts and reports.
Read article