How to Lock Cells in Excel

There are many ways you can lock cells in Excel to protect others from overwriting your formulas and your data. I’ll show you an easy way in this quick tutorial.

How to Use the Excel TEXTSPLIT Function

Excel’s TEXTSPLIT function can split words into separate cells. You can have multiple delimiters, you just have to know how to define these properly. You can also do amazing things like splitting into columns and rows and internally sorting words.

New Excel Functions in Office 365 (VSTACK, TEXTSPLIT, TOCOL, DROP, WRAPCOLS, CHOOSECOLS, TAKE)

Excel recently released a set of new functions like VSTACK, TEXTSPLIT and TOCOL that will have you looking forward to working with complex files and data because your life just got more exciting (at least mine did!).

How to Do Many-to-One Side Calculations in Data Models with DAX

In Power BI or Power Pivot, you often need to create reports that go from the many side of the relationship to the one side. How can you do that without expanding your data model by adding more columns to your table? There is an easy trick you can use to solve this with a single DAX formula. Of course, the formula uses the CALCULATE function.

Excel LAMBDAs Made Easy with the New Advanced Formula Environment (Editor)

The new Microsoft Excel Advanced Formula Add-in makes it easy to write and manage LAMBDAs in Excel.
It’s a “new” version of Name Manager and hopefully it could replace Name Manager in the future.

Avoid these 7 Common Errors in Microsoft Excel (and how to fix them)

How do you fix broken Excel formulas? What do you do when the formulas return errors? Find out what the most common Excel formula errors are and how you can fix them. It’s easy! You just need the right approach. This post covers it all!

Top 10 Power BI Tips & Tricks

Power BI can do THAT? Learn 10 quick tips to enhance your Power BI dashboards: Conditionally format charts, create a separate measures table, customize your own tool tips and a lot more.

Create Searchable Drop Down Lists in Excel with ZERO Effort

It takes ZERO effort to now get searchable drop-down lists in Excel. Excel’s data validation list now offers autocomplete by default. Empty cells are skipped too! This is all for desktop and online version. Check out this post to find out more.

7 Things You’re Doing Wrong (or perhaps not the best way) in Excel

Don’t merge cells in Excel – Don’t Copy Excel sheets without updating links – Don’t hide rows and columns! There are better ways of doing these things. Find out 7 things you’re doing wrong in Excel and how to do it correctly.

Combining Data from Multiple Cells – Text and Numbers

Learn practical and easy methods (including a hidden tip not many know about) to combine data from multiple cells into a single cell in Excel.

Top Excel Functions for Engineers

If you’re a Mechanical Engineer, make sure you know these 10 Excel functions. Your work-life will become much easier once you learn these Excel formula combinations.

How to Use Power BI – Beginner’s Guide

Get started with Power BI now by creating your first dashboard. Download the free files, follow along and in 20 minutes you’ll have setup your interactive dashboard which you’ve published to the web!

Previous
1 5 6 7 8 9 30
Next

Free Guide!

The ONE Critical Excel Skill You Need

This free Excel guide will help you to:

  • Pinpoint the Excel skill you should work on now
  • Understand how this skill can help you
  • Find the optimal learning path to master this skill