7 Excel Hacks That Will Make Your Life Easier

7 Excel Hacks That Will Make Your Life EasierA whopping 67% of middle-skill jobs require experience in Excel. Just because you hate numbers and the thought of spreadsheets make you nauseous doesnt mean you cant add this valuable skill to your resume with confidence. Here are a few tricks to make you an Excel wizard.1. ChartsThese are not just for the know-it-all in grade school. Charts are a great way to make your data visual, and a great way to impress the bigwigs. Once youve entered your data, simply click Insert ChartChart schriftart and youre on your way.2. Conditional FormattingThe possibilities here are endless. Want to show off profit margins? Or efficiency? Simply click HomeConditional FormattingAdd and make your magic. Low numbers (say those below 70%) or profits under 3% could be set to automatically highlight in red, while excellent numbers could be highlighted in green.3. Quick AnalysisHave a smaller data set? You can skip to the fancy chart and table stage by using this tool. Just highlight your data and click on the icon in the bottom right corner of your highlight field to open the Quick Analysis menu.4. AutofillWhy enter the same thing in every row when you can have Excel do it for you? Just schrift in the datum you need repeated, then click and drag the lower right-hand corner of the cell all the way down the column.5. Power ViewHave a larger data set? Power View can collate and make sense of your data for you, generating visual, interactive reports for you to present directly to the boss. Just click InsertReports and start exploring.6. Pivot TablesThey sound really fancy, but theyre super useful. You dont have to write a single formula, but you can summarize all of your data into impressive and informative tables and lists. Just click InsertPivotTable, select your data range, use the drop-down menu to select your fields, then make your table7. VLOOKUPIf youre working in a database with multiple sheets and tabs, VLOOKUP is a great way to bring them all together and pull coherent information from the entire data set. Under the Formula menu, select VLOOKUP and enter the cell that contains your reference, then the range of cells to pull from, the column number, and either true or false.These few tricks are mobilfunktelefon for everyone, but will make you stand out among your colleagueseven if youre bad at numbers.Once you have these done, step up your game and learn these 7 advanced Excel Tricks. It might even get you a raise or promotion.7 Excel Tricks Thatll Make Your Life a Lot Easier (Especially if Youre Not a Numbers Person)