Professor-Excel.comhat einen Beitrag geschrieben.9. Oktober 2022Today, I have something for all of you working in finance: Do you sometimes calculate an internal rate of return (IRR)? #Excel provides two functions: IRR and XIRR. Which one should you use? https://professor-excel.com/irr-or-xirr-easily-choose-the-best-excel-function/ IRR or XIRR: Easily Choose the Best Excel FunctionIRR and XIRR both return the internal rate of return in Excel. But which one of the to use? Learn here the difference and how to solve errors!professor-excel.com
Professor-Excel.comhat einen Beitrag geschrieben.3. April 2022Quick #ExcelFact: Copy the values from the Excel Status Bar - just click on it! #Excel
Professor-Excel.comhat einen Beitrag geschrieben.4. Februar 2022Our founder, Henrik, got interviewed by Finance Strategists. Read the full interview here and get to know, how Professor Excel started! https://www.financestrategists.com/founder-spotlight/professor-excel/ #interviewInterview with Henrik Schiffner | Founder of Professor ExcelFinance Strategists recently spoke with Henrik Schiffner of Professor Excel. He shared his thoughts on the past, present, and future of the company, as well as insight gained from running the business.www.financestrategists.com
Professor-Excel.comhat einen Beitrag geschrieben.13. Dezember 2021Quick #Excel tip for the start of the week: How to paste a copied cell to visible cells only - skipping all filtered out or hidden cells in-between. https://professor-excel.com/paste-to-visible-cells-only-how-to-skip-filtered-out-cells/ Paste to Visible Cells Only: How to Skip Filtered Out CellsYou have filtered out our hidden cells. Here is how to paste a copied cell to all visible cells - and not the hidden cells in-between.professor-excel.com
Professor-Excel.comhat einen Beitrag geschrieben.12. Dezember 2021New #Excel tutorial: Fill down all empty cells with the last value above. https://professor-excel.com/how-to-fill-down-empty-cells-with-values-from-above/ How to Fill Down Empty Cells With Values From AboveFill down the value from the last cell above: Here are 3 methods to repeat the last filled cell, in a normal table or a PivotTable.professor-excel.com
Professor-Excel.comhat einen Beitrag geschrieben.9. Dezember 2021Has your e-mail bounced because the attached #Excel file is too large? Here is how to find out why your workbook is so big! https://professor-excel.com/why-is-my-excel-file-so-big-here-is-how-to-find-it-out/ Why Is My Excel File So Big? Here Is How to Find It Out!Excel file suddenly very big? After saving it, it needs a lot of MB? Here is how to find out why the Excel file is very large!professor-excel.com
Professor-Excel.comhat einen Beitrag geschrieben.8. Dezember 2021Do you sometimes work with the #INDIRECT function in #Excel? Here is how to easily evaluate INDIRECT functions! https://professor-excel.com/follow-up-indirect-how-to-easily-evaluate-indirect-functions/ Follow Up INDIRECT: How to Easily Evaluate INDIRECT FunctionsFollow up INDIRECT functions: Easily evaluate and see the final cell references of INDIRECT formulas with these three simple methods.professor-excel.com
Professor-Excel.comhat einen Beitrag geschrieben.20. November 2021Do you sometimes work with Harvey balls? Here are the four best methods to insert them to your #Excel worksheet. https://professor-excel.com/harvey-balls-how-to-insert-filled-circles-in-excel/ Harvey Balls: How to Insert Filled Circles ഠ◔◑◕⬤ in ExcelHarvey Balls in Excel can be fixed or dynamic with conditional formatting. If you don't want to change them, you can use "normal" characters.professor-excel.com
Professor-Excel.comhat einen Beitrag geschrieben.19. November 2021It's #Excel-Fact-Time! PS.: If you want to see a video of the flight simulator, please refer to this YouTube video: https://youtu.be/-gYb5GUs0dM
