Data Analytics · @dataanalytics.07

Posted 2 weeks ago
98.48K followers
9.63K views
144 likes
0 comments
8 shares

Are you still applying basic formulas manually in Excel? 😱 Stop wasting time and use this smart Excel trick instead. Step 1: Press Ctrl + A to select your data Step 2: Press Ctrl + T to convert your data into a table Step 3: Press Ctrl + Shift + T Now go to the bottom section of your table and you will see the Total Row option. From there, you can quickly apply formulas like: Sum Average Count Max Min all directly from the dropdown menu in Excel. This simple trick can save a lot of time and make your reporting much faster and smarter. Excel shortcuts every data analyst should know. Follow for more Excel, Power BI, SQL, and Data Analytics tips. For training, dashboards, or projects: Website: www.alidataanalytics.com Facebook: @alitheanalyst Instagram: @dataanalytics00 #Excel #ExcelTips #DataAnalytics #Spreadsheet #MicrosoftExcel