In this post i will show you 6 quick and easy to remember keyboard shortcuts for navigation in Excel

In this postI will show you 7 quick and easy to remember keyboard shortcuts for cell selection in excel.

In this video we will explore the copy-paste special tools. You may think there nothing special about copy and paste! Well, I can assure You, you are probably missing out some good tricks.

In this video I will show you how to improve your productivity and impress your coworkers with one trick. CTRL + E, to activate Smart filling. This will allow you to automatically fill data on your rows when Excel senses a pattern.

In this video we will explore the select special tools These tools will allow you to select specific cells when they meet a criterion and combine some of them with other tools like the shortcut CTRL + enter to create a special filling.

In this video I will show you 9 quick and easy to remember keyboard shortcuts for general actions with workbooks in excel that will help you save time while you work on your spreadsheet makes you look like a pro.

In this video I will show you 9 quick and easy to remember keyboard shortcuts for general actions with worksheets in excel that will help you save time while you work on your spreadsheet.

In this video I will show you how to use the Excel Function Wizard. This tool will guide you through the process of creating a function when you are not sure of how a function work and how to arrange the arguments.

In this video i will show you different ways to compare individual cells or a list of values using the functions IF, CONCAT and XLOOKUP

In this video I will show you some of the most common errors when working with the excel function XLOOKUP and will show you how to fix them.

In this video I want to show you a solution that i put together for a user request. This user had data for years and months but were type in the same cell as a text string. The request was to come up with a formula to add up the years and the months.

In this video I will show you how to use the Excel series tool from the home ribbon tab. With this tool you can create sequence of numbers with different step values and cover all the numbers that you need.