New Line in Excel Cell
If you use Word, you know that you can enter a new line by pressing the Enter key. But when you try this…
Category: examples
Excel Logical Operators: Equal To, Not Equal To, Greater Than, Less Than
When you work in Excel, sometimes you may want to calculate data only if a particular condition is met. You can achieve this…
The Dollar Sign in Excel
The dollar sign ($) in Excel is used to create a locked cell reference. In some cases, locking cells is important, otherwise, you…
Bullet Points in Excel
It’s easy to add bullet points in Word. It’s a text processor that is designed to work with text and bulleted lists, so…
Move Sheet Shortcut in Excel
In this lesson, I’ll show you a few ways you can use keyboard shortcuts or navigation shortcuts to move sheets and navigate them….
Convert Excel Data to Word Table
Depending on what exactly you want to copy, there are a few ways you can use to convert an Excel table to a…
Change Date Format to dd/mm/yyyy in Excel
Depending on the country you are in, you can use a few different date formats. In this lesson, I’ll show you how to…
Pivot Table Slicers
With PivotTable slicers, you can filter a PivotTable using visual buttons. Slicers also show the current filtering state, by greying out positions that…
Add Developer Tab in Excel
You can add the Developer tab in Excel 2019 by following these steps. Inside Excel Options, under the Customize Ribbon tab, check the…
Lock Cells in Excel
In Excel 2019, but also in earlier versions, Excel allows you to create a password to lock a number of cells or even…