MrExcel Excel Videos

Help now has its own tab in the Excel Ribbon. Today, a short tour of the icons available there.

Excel now debuts a new Home screen in the File menu - it is a combination of the existing New and Open screens. Also - the icons on the Ribbon are changing for those using Office 365. To download this workbook: https://www.mrexcel.com/download-center/2018/08/new-ribbon-and-help-screen.xlsx List of upcoming seminars: Excel Seminar Schedule

New in Office 365: The ability to format individual cells in a pivot table and have the formatting stick. Added to Office 365, Version 9029.2xxxx or later Right-click the cell and Format Cell or simply apply the formatting. The cell formatting will stick, even after pivoting or filtering. List of upcoming seminars: Excel Seminar Schedule To download the workbook from today's video, visit the URL in the YouTube description

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