Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

CHAR

Weekly Calendar

By Jeff Lenning | October 22, 2024 |

In this tutorial, we’re going to learn how to create a dynamic weekly calendar in Excel that shows which programs or events are running on any given day. This technique is perfect for managing schedules where events have different start and end dates and may only occur on certain weekdays. Objective We are trying to…

How to Remove Leading Spaces in Excel

By Excel University | January 17, 2023 |

Any work you do in Excel is built around data. The cleaner the data is, the easier worksheets are to read and maintain – and correct formatting plays a big role. Being able to remove leading spaces in Excel helps make your data look clean and keeps your formulas operating as expected. Extra leading spaces…