Take your Excel skills to the next level with my intermediate skills category. Learn how to use advanced formulas, manipulate data with PivotTables and PivotCharts, and automate repetitive tasks with macros. My comprehensive tutorials and real-world examples will give you the confidence to handle complex Excel projects like a pro. Whether you’re looking to boost your career, impress your boss, or create some awesome templates, my intermediate skills category is the perfect place to continue your Excel journey.
Microsoft Excel allows you to manipulate data in countless ways. One common task is summing up data across an Excel workbook (aka sum multiple tabs in Excel). This could come in handy if you’re managing…
Have you ever tried typing a date into a blank cell of an Excel file and it pops back with a random number? Have you ever wondered if that numeric value means anything? Surprisingly, it…
Have you ever found yourself in a situation where you’re juggling project deadlines, keeping tabs on due dates, or just curious about the time between two important events? I think most of us have. Learning…
If you’ve ever found yourself trying to figure out how to subtract dates in Excel to get days, months, or years, you’re not alone. Excel can be a powerful tool, but it can also be…
There will come a time in your spreadsheet ventures when you will want to copy multiple cells in Excel. This can be a very long and tedious task if you were to enter tables of…
Are your spreadsheets looking a bit boring? Perhaps too busy? Do you find yourself struggling to make them visually appealing? If so, you’re not alone. Many people use spreadsheets as a way to organize and…
Did you know that Microsoft Excel can be used daily? And I’m not just talking about if you work in an office. I’m talking about real daily life both personal and professional. Hi, I’m Lindsay…
This post may contain affiliate links, meaning that if you make a purchase using my link, I may receive a commission at no extra cost to you. Are you toying with the idea of how…
Learn how to earn active income putting your spreadsheet skills to the test with Excel Freelance work.
Have you ever been working on a huge Excel spreadsheet with your fingers tired from scrolling and scrolling on the mouse, and clicking here, and clicking there, and thinking “There has got to be a…