Excel VBA School

You could learn here about MS excel basis and some advance sort keys. Formatting sort keys. CTRL+1                    Format Box ALT+E+S+T             Copy Format ALT+H+0                 Increase Decimal ALT+H+9                 Decrees Decimal  CTRL+SHIFT+7     Boxing ALT+O+C+A            Fit Column Width ALT+H+O+R            Change Sheet Tab Name ALT+W+F                (Un)Split Panes ALT+W+S                 (Un)Freeze Panes SHIFT+CTRL+#       Date format SHIFT+CTRL+S      $ Dollar format SHIT+CTRL+%       % Percentage format ALT+"="                   Sum function With CTRL Shortcuts. CTRL+A       Select All CTRL+B         Bold (only selected cell or range) CTRL+C         Copy(only selected cell or range) CTRL+D         Fill down(Select non blank cell or range) CTRL+E          Flash Fill CTRL+F          Find CTRL+G         Go To Special CTRL+H         Replace CTRL+I           Italic CTRL+K          Insert Hyperlink CTRL+L          Create Table C

Pivot Tables in Excel: How to Use the PivotTable Function The PivotTable function is one of the most widely used features of Microsoft Excel. It allows you to analyse and visualise data in various ways that can provide deep insights. If you have never used pivot tables in Excel or would like to build on your basic knowledge, you’re in the ExcelzerotoHero (Note: PivotTable is the trademarked term for Microsoft Excel’s pivot table function) By the time you finish this article, you should have a firm grip on how to create a pivot table in Excel. We will also cover the basics of how to view the same data in different ways using the PivotTable feature. We’ve also provided the worksheet shown in the examples so you can follow each step as you read. First, imagine a simple dataset like the following. This is a simple data set, but large enough to work with. Notice that all the rows

23 things to know about Excel Tables by Dave Bruns | May 17, 2018 Excel Tables have a boring (and confusingly generic) name, but they are packed with useful features. This article is a summary of the things you should know about Excel Tables. 1. Creating a table is fast You can create an Excel Table in less than 10 seconds. First, remove blank rows and make sure all columns have a unique name, then put the cursor anywhere in the data and use the keyboard shortcut Control + T. When you click OK, Excel will create the table. 2. Navigate directly to tables Like named ranges, tables will appear in the namebox dropdown menu. Just click the menu, and select the table. Excel will navigate to the table, even if it's on a different tab in a workbook. 3. Tables provide special shortcuts When you convert regular data to an Excel Table, almost every shortcut you know works better. For example, you can select rows with shift + space, and columns with control