Welcome to the Excel blog section! Stay up-to-date with the latest trends and tricks to elevate your spreadsheet skills.
Latest posts on our blog
Are you just getting started with Excel or looking for advanced ways to master it? Find all the latest tips, tricks, and insights right here, from Excel basics to deep dives into advanced techniques and ultimate how-to guides.
Dashboards
- Dynamic Color Cards for Dashboards
- How to create a Dashboard in Excel
- Free Excel Map Templates
- Product Metrics Dashboard Template
- Traffic Light Dashboard Template
- Sales Tracking Templates
- Profit and Loss Dashboard Template
- HR KPI Dashboard Template
- Financial Dashboard Template
- Free Dashboard Widgets
Let’s LAMBDA!
- Extract word that begins with specific character
- How to extract word from a string
- Compare two lists in Excel
- Dynamic rank and filter to extract data
- Convert numbers to words in Excel
- Remove special characters using LAMBDA
- Extract numbers from a cell in Excel
- Check if a cell contains specific text
- SUM values between two numbers with LAMBDA
- Sum comma-separated values using LAMBDA
Tutorials
Formulas
- Convert Numbers to Words
- Compare Multiple columns and find row matches
- Count unique dates
- CAGR Formula
- Mortgage payment schedule
- Random numbers without duplicates
- Extract first number before a text string
- Extract the last number from a string
- Get a number from any position in a string
- Extract the nth number from a text string
Recommended Online Courses:
GoSkills offers a range of Excel courses for beginners who want to grasp the essentials of formatting, functions, and formulas and for mavens who want to automate with macros and VBA, analyze big data, and produce business intelligence dashboards with Power Query and Power Pivot.
We strongly recommend you visit Powerspreadsheets.com for VBA resources and detailed guides.