Categorie: Excel

7 Excel tools that are more useful than learning another formula

7 Excel tools that are more useful than learning another formula https://www.makeuseof.com/excel-tools-more-useful-than-functions/ Data Form: A simpler way to work with wide tables Watch Window: See what’s changing without jumping around Evaluate Formula: Take the guesswork out of complex formulas Sheet Views: Because not everyone needs the same view Speak Cells: Sometimes it’s easier to

Lees verder

Your Excel sheets keep lagging because of these 3 formulas

Your Excel sheets keep lagging because of these 3 formulas https://www.makeuseof.com/excel-sheets-keep-lagging-because-of-these-formulas/ Formulas with volatile functions. There’s a reason the pros use them sparingly Legacy array formulas. Processing array formulas is not always so simple Lookup formulas. They’re convenient but can be expensive Unlock the power of a fast Excel sheet  

Lees verder

I stopped using PivotTables in Excel because I found something better

I stopped using PivotTables in Excel because I found something better https://www.makeuseof.com/excel-pivot-tables-better-alternative/ Meet Excel’s PivotCharts The smarter side of PivotTables Building your first PivotChart No formulas, just drag and drop Make PivotCharts your own Colors, styles, and chart types Interactive filtering with PivotCharts It makes data exploration way easier When

Lees verder

I rebuilt the same Excel report every month for 3 years — Power Query turned it into one refresh button

I rebuilt the same Excel report every month for 3 years — Power Query turned it into one refresh button https://www.makeuseof.com/rebuild-the-same-excel-report-with-power-query/ Breaking the copy-paste cycle. If you’re still combining files manually every month, there’s a better way From multiple files to one refreshable report. Set it up once, drop in the new

Lees verder

I typed three semicolons into Excel and found its strangest formatting trick

I typed three semicolons into Excel and found its strangest formatting trick https://www.makeuseof.com/typed-three-semicolons-into-excel-found-strangest-formatting-trick/ A custom number format has four slots Leave every one of them empty, and Excel draws nothing Formulas still read the hidden value Blanking the display never touches the data underneath This beats hiding columns or turning

Lees verder

I stopped rebuilding the same Excel pivot every week after learning this one trick: getpivotdata

I stopped rebuilding the same Excel pivot every week after learning this one trick https://www.makeuseof.com/stopped-rebuilding-same-excel-pivot-one-trick/ The hidden Pivot Table function Why GETPIVOTDATA is more useful than its intimidating name suggests One formula changed my entire workflow Separating presentation from the Pivot Table without losing live updates Reports that update themselves

Lees verder

VSTACK: I used to manually merge two spreadsheets every week — this Excel function completely replaced it

I used to manually merge two spreadsheets every week — this Excel function completely replaced it https://www.makeuseof.com/merge-spreadsheets-with-the-vstack-excel-function/ How VSTACK replaced my weekly spreadsheet merge One formula instead of copy-pasting every week What you should know before using VSTACK What works, what doesn’t, and when another tool makes more sense VSTACK

Lees verder

“I tried these 6 new Excel functions and they saved me a ton of time”

I tried these 6 new Excel functions and they saved me a ton of time https://www.makeuseof.com/new-excel-functions-worth-learning-this-year/ Regular expression (regex) functions Find, extract, and clean data without endless text formulas regexreplace REGEXREPLACE Function | Microsoft Support https://support.microsoft.com/en-us/excel/regexreplace-function regextest REGEXTEST Function | Microsoft Support https://support.microsoft.com/en-us/excel/regextest-function regexextract REGEXEXTRACT Function | Microsoft Support https://support.microsoft.com/en-us/excel/regexextract-function

Lees verder