MrExcel Excel Videos

How to move focus to an Excel slicer using only the keyboard? Can you use the keyboard in Excel to activate a slicer? Yes! Alt, H, FD, O to enter Select Objects mode Tab twice to get to first object Once a slicer is selected, you can move the slicer with arrows Tab again to move to Multi-Select, then Tab to Clear Filter then Tab to Slicer tiles. More tabs will move to other objects and slicers

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 to the sheet tabs F6 again to task pane(s) F6 again to status bar F6 again to Ribbon F6 again to Split Window From the worksheet, F6, Shift+F10 to open right-click menu, arrow to rename, Enter Type Name, Enter, F6 until you are back in the worksheet To download this workbook: https://www.mrexcel.com/download-center/2018/07/rename-sheet-without-mouse.xlsx List of upcoming seminars: Excel Seminar Schedule

Simple steps to make your workbook more accessible for people using a screen reader or other adaptive technologies. People could be consuming your worksheets with screen readers or other adaptive technologies The cartoon you added to your worksheet is hilarious, but a screen reader might just call it "Screen Clipping". Use the Check Accessibility button on the Review tab or click the notifier in the Status Bar. It will find cells with bad contrast, images without Alt Text.

A follow-up to episode 2226 - more cool features with Forms and Surveys in Excel. First - some analysis of the responses from episode 2226 0:05 Coke or Pepsi 0:55 Time of Day 1:14 Date of responses 1:52 3D Map of responses 2:16 Drawing winner of book 3:06 Further Discussion of Features in Forms 3:50 How to add a logo. 4:03 How to add a theme. 4:15 How to restrict answers to a number between two values. 4:38 How to shuffle answers. 5:15 How to add a Likert Scale question. 5:33 How to add a Net Promoter Score question 6:30 Using the new Quiz feature 6:58 Getting Name and E-mail of respondents 7:10 Using Power Query to change text numbers to numbers 7:35

Geography and Stocks are the first types of Linked Data Types in Excel This feature is exclusive to Office 365 since it requires downloading online data Type some cities, select the cities, mark as Geography Hover over icon to see data card New =A2.Population syntax or wrap in square brackets: =A2.[National anthem] New FIELDVALUE function New #FIELD! error Cool trick: Sort table by a column that is not there Field error during refresh How to Recalc using Data, Refresh

Insert Forms appeared in Excel recently Build a form online at Forms.Microsoft.com Share the form with a QR Code or a link The results will appear in your Excel workbook! To download this workbook: https://www.mrexcel.com/download-center/2018/07/surveys-and-forms-in-excel.xlsx List of upcoming seminars: Excel Seminar Schedule New Data Analytics Course: https://mrx.cl/imadatacourse

Easy checkmarks in Excel from Jack Whipple Rather than use P in Wingdings 2 font, you can use Icon Sets 1 = Green Checkmark: Done 0 = Empty Circle: Still to Do -1 = Yellow Dash: Not required this year, but keep it on the list for next year To start, Home, Conditional Formatting, Icon Sets, 3 Symbols (Uncircled) Home, Conditional Formatting, Manage Rules. Change second symbol to a round circle. 3rd symbol to dash Bonus tip from Debra Dalgleish at Contextures.com (subscribe to her weekly newsletter!) http://www.contextures.com/newsletter/ctxnewsindexlist.html Conditional Formatting in A: Use Formula. If B = 1, then strikethrough Why is Ctrl+5 strikethrough? Because when people used to take inventory with hash marks |||| the fifth would...

Ctrl+Wheel Mouse will increase the size of the grid in Excel But it does not increase the size of the dialog boxes When I am presenting in a big room with a screen that is too small, the magnifier helps Press Windows key and Plus Sign Three types of magnifier: Full Screen is the default. Docked creates a part at the top of the screen. I prefer Lens, but change the size of the lens Important: To turn it off: Windows Key and Escape

Susan in Melbourne wants to create a pivot table that shows text in the values area. Typically, this can not be done. But it is possible with the DAX formula language. Format as Table using Ctrl+T Insert, Pivot Table, Add This Data to the Data Model Build the Row & Column Areas Right-click the Table name in the Fields list, choose Add Measure Formula is =CONCATENATEX(Table1,Table1[Code],", ") To download this workbook: https://www.mrexcel.com/download-center/2018/07/pivot-table-with-text-in-values-area.xlsx