Excel Basics | For Accountants |
https://youtube.com/watch?v=ZX13uWEcaUQHi guys and welcome back to my channel. In this video I show some basics in Excel that every accountant should know. If you'd like to see more, make sure…
3 Amazing Time-Saving Tips Using Excel AUTO-CORRECT
https://youtube.com/watch?v=6NjeJ_WCYeIIn this video, I will show you how to use Excel Autocorrect to save time in Excel. Excel autocorrect is a feature that's built to correct misspelled words or convert…
Show Negative Numbers in Red Color (with a Bracket) in Excel
https://youtube.com/watch?v=9aokrf_tMRIIn this video, I will show you how to show negative numbers in red color and/or with brackets. This can be done using two methods: -- Conditional Formatting -- Custom…
Unpivot Data in Excel Using Power Query (FASTEST way ever)
https://youtube.com/watch?v=2482wD1FmEsIn this video, I will show you how to quickly unpivot data in Excel using Power Query. Since the Pivot table needs a specific data format, in case you get…
Show Numbers in Thousands or Millions in Excel (really easy way)
https://youtube.com/watch?v=6jLeD1YfWfYIn this video, I will show you a really easy way to show numbers in thousands in Excel (or in millions or billions). You can do this using the custom…
Automatically Open Specific Excel Files When you Start Excel
https://youtube.com/watch?v=nGdkfbvqd5QIn this video, I will show you how to open specific Excel files when you start Excel. You can specify a folder so that whenever you start Excel, it will…
Top 10 Excel Formulae You Need to Know (Tips and Tricks)
https://youtube.com/watch?v=ayLzc3oUEaIFor our '100 Most-Useful Excel Tips' for FREE, click below. If you're just starting your spreadsheet journey, using these top 10 Excel Formulas will maximise your efficiency and set you…
Highlight Dates that are Past the Due Date in Excel (or about to be due)
https://youtube.com/watch?v=zqkINF31_nwIn this video, learn how to highlight cells with dates that are past the due date. This can easily be done using the TODAY function in conditional formatting. In this…
How to Insert a Row After Every Row in Excel (a really simple trick)
https://youtube.com/watch?v=hiKY7v3xCcsIn this video, I will show you how to insert a row after every row in your dataset in Excel. While you can do this easily in a small dataset,…
Excel VBA Tips n Tricks #19 MkDir VBA Function Make folders and subfolders using excel
https://youtube.com/watch?v=ZDVfFbnrkfkCreate folders and subfolders dynamically with Excel's VBA! This is super easy. Check it out! **Limited Offer** Learn to Make Excel Do Your Work For You with The Ultimate Excel…