4 Ways To Protect Excel Workbooks, Worksheets And Cells

About this tutorial: Video duration: 6:14 $10 ONE TIME OFFER! Get the Full Udemy Course ONLY for $10 !! Click the link: ****************************************************************** In this video tutorial we will learn how to protect an entire workbook , sheets or cells. There are different methods and level of protection. For example: You can protect all the […]

Tricky: Find Excel Duplicates Based on Two Columns – 2283

About this tutorial: Video duration: 2:45 If you work in Accounts Payable, check out the great resources at Today’s question from a recent webinar that I did for the AP-Now members: Given an Excel worksheet of payments made by accounts payable, how can you look for duplicate payments. My solution involves the new TEXTJOIN function, […]

Quickly Add Bullets in Excel – 2281

About this tutorial: Video duration: 2:18 I was trading Excel tips with Robert from Florida and he gave me a list of four hard ways to get bullets into Excel. There is now a fifth way and it is super-easy! At least, it is easy if you are using Excel on a Windows machine and […]

Surprising: Split Outlook Distribution List In Excel – 2282

About this tutorial: Video duration: 4:49 Kim has a distribution list in Outlook with 130+ names. She wants those names in Excel. When she copies and pastes, everything ends up in a single cell. In this episode, a simple set of steps to split the distribution list into rows and then columns for Name and […]

Learn Excel 2010 – “Strikethrough Text”: Podcast #1681

“To-Do” lists in Excel are awesome! A visual of what needs to be done, when they need to be done and marking progress as the list items are completed. and upon completion, Bill prefers to use ‘Strikethrough”… but where is Strikethrough to be found when it is not represented on the Excel Ribbon? Try Ctrl+5. […]

Learn Excel – Force gmail to open attachments in Excel – Podcast #1847

About this tutorial: Video duration: 2:6 Google docs still does not render all Excel files correctly. If you have particular formatting, there is a chance that your gmail recipients will simply preview the file in gmail, which renders using Google Docs, which means they won’t see the right version of the spreadsheet. In today’s episode, […]

Learn Excel =INFO(“Directory”) to find – Podcast 1876

About this tutorial: Video duration: 2:54 You want to use some VBA to save a file to the desktop. But what is the real path to the desktop? It is not C:Desktop. In this episode, an arcane function = INFO to return the path of the current workbook.

Learn Excel 2010 -“Dynamic Chart Labels”: #1426

About this tutorial: Video duration: 3:2 Today we will learn how to replace Numeric Chart Labels with a Formula using the method Bill gives in Episode #1426. Also learn to vary Colors by Point AND “Making Excel Columns Wider” using Gap Width. Learn Excel 2007 through Excel 2010 from MrExcel

Learn Excel – Create an Invoice Register – Podcast 1808

About this tutorial: Video duration: 10:28 This follow-up video to episode 1505 shows how to automatically create an invoice register as your are using one of the Invoice Templates from Excel. Incoming search terms:how to create a invoice in excel register

Learn Excel 2010 – “Clear if New Day”: Podcast #1453

About this tutorial: Video duration: 5:13 Kevin wants to clear out any data from yesterday’s shift Worksheet any time someone opens the Workbook. Using the formula from Episode #1452, plus four tiny macros added today, Bill shows us the solution. …This blog is the video podcast companion to the book, Learn Excel 2007 through Excel […]

Learn Excel from MrExcel – “Exact Time by Keystroke”: Podcast #1724

About this tutorial: Video duration: 3:49 James is looking for a Keystroke to enter the Exact Current Time, to the Second, in a Cell. You would think this would be a 30-second podcast, but you would be wrong. Today, a small Macro to improve the Ctrl+Colon Shortcut. Follow along with MrExcel in Episode #1724 as […]

2010 Ribbon Customization – 1077 – Learn Excel from MrExcel Podcast

About this tutorial: Video duration: 3:20 Office 2010 finally allows you to customize the ribbon. Episode 1077 shows you how. This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Unhide One Column – 449 – Learn Excel from MrExcel Podcast

About this tutorial: Video duration: 3:8 Stuart from the UK asks: say that you have columns B through H hidden and want to unhide only one of those columns? Episode 449 will take a look at the process of hiding and unhiding columns. Although I had never tried it before Stuart posed the question, it […]

Dates as Numbers – 447 – Learn Excel from MrExcel Podcast

About this tutorial: Video duration: 2:52 Here is a bizarre problem sent in by a viewer. Many of you will think that you know the answer, but this problem is not as simple as it appears. In a worksheet, any dates are instantly converted to their 5 digit serial number. The actual date is shown […]

MrExcel’s Learn Excel #960 – Formula Tooltip

About this tutorial: Video duration: 2:42 Paul sends in a few tricks to help deal with the Function Tooltip that appears when you edit a cell. Episode 960 shows you how. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn […]

MrExcel’s Learn Excel #426 – April Fools

About this tutorial: Video duration: 3:4 One of my favorite April Fools Day tricks involves a trick that will only work with Excel 97 through Excel 2003. Since it is Friday, and your manager might be upgrading to Excel 2007 soon, try this trick out now, before the opportunity is lost. Episode 426 shows you […]

MrExcel’s Learn Excel #407 – Logo Shapes

About this tutorial: Video duration: 2:19 Use the freeform tool to make a 3-D version of your company logo. Episode 407 shows you how. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the […]

Learn Excel – Make Ctrl+V be Paste Special – Podcast 1828

About this tutorial: Video duration: 2:15 Seckin set up a worksheet for his co-workers with great conditional formatting. Unfortunately, the co-worker uses Ctrl+V instead of Paste Special Values, which destroys the conditional formatting and/or data validation. In this episode, record a simple macro that changes Ctrl+V to Paste Special Values.

Rename Excel Sheet without Mouse – Episode 2230

About this tutorial: Video duration: 4:50 Here is a challenge for today: How can you rename a worksheet without using the Mouse? Does anyone know the keyboard shortcut to solve this? Question for today: How can you rename a worksheet without using the mouse? The technique involves using the F6 Loop: Press F6 to get […]

“Don’t Fear The Spreadsheet” — Chart and Table: Podcast #1625

About this tutorial: Video duration: 4:58 Due to time constraints, Tyler needs to set up a Chart and a Table and she would like to do both simultaneously. Can it be done? Of course! It’s Microsoft Excel! Follow along with Episode #1625 as Bill “MrExcel” Jelen shows us how it’s done with a little available […]