You should stop using Excel’s Import Wizard and use this instead https://www.makeuseof.com/stop-using-excels-import-wizard-and-use-this-instead/ IMPORTCSV is a faster, formula-based alternative Its syntax only has one required argument IMPORTCSV also handles web-hosted CSV files Replace the file path with a URL, and Excel fetches the data for you Filter imported data without loading
Lees verderCategorie: Excel
You’re ignoring one of Excel’s simplest and smartest visual tools: sparklines
You’re ignoring one of Excel’s simplest and smartest visual tools https://www.makeuseof.com/ignoring-excels-simplest-smartest-visual-tools/ The tiny charts you’ve been overlooking What sparklines are and why they matter Three types, three clear use cases When to use line, column, and win/loss sparklines You can set them up in seconds A 30-second trick that adds
Lees verder“I use Excel every day and these are the features I’d be lost without”
I use Excel every day and these are the features I’d be lost without https://www.makeuseof.com/excel-features-for-every-day-use/ PivotTables Make sense of 1,000 rows with a quick glance Lookup functions The shortcut to answers you’d otherwise spend hours finding Conditional formatting See what matters immediately Drop-down lists Stop typing the same thing over
Lees verder“6 Excel habits I had to unlearn to get good at it”
6 Excel habits I had to unlearn to get good at it https://www.makeuseof.com/excel-habits-to-unlearn/ Holding onto merged cells Pretty sheets aren’t worth broken filters and sorting Keeping everything on one sheet Tabs exist for a reason Burying my assumptions If it’s important, it deserves its own cell Writing unreadable formulas Clear
Lees verder“Excel’s data validation is far more powerful than just dropdowns — here’s what it can actually enforce”
Excel’s data validation is far more powerful than just dropdowns — here’s what it can actually enforce https://www.makeuseof.com/excels-data-validation-more-powerful-than-just-dropdowns/ Custom formulas let you control far more than a list The Custom option accepts any TRUE/FALSE formula as a validation rule Prevent duplicate entries with a COUNTIF formula It flags repeats before
Lees verderArray functions in Excel
Those curly brackets in Excel aren’t a glitch — here’s what they actually mean https://www.makeuseof.com/curly-brackets-in-excel/ Legacy array formulas The curly brackets you can’t type yourself Array constants The curly brackets you do type yourself Modern Excel and the shift to dynamic arrays No more Ctrl + Shift + Enter See
Lees verder“I stopped restructuring my Excel sheets manually the day I discovered CHOOSECOLS”
I stopped restructuring my Excel sheets manually the day I discovered CHOOSECOLS https://www.makeuseof.com/choosecols-in-excel/ CHOOSECOLS function – Microsoft Support https://support.microsoft.com/en-us/office/choosecols-function-bf117976-2722-4466-9b9a-1c01ed9aebff KIES.KOLOMMEN-functie – Microsoft Ondersteuning https://support.microsoft.com/nl-nl/office/kies-kolommen-functie-bf117976-2722-4466-9b9a-1c01ed9aebff
Lees verderYou don’t need to be a coder to use Python in Excel for data cleaning
You don’t need to be a coder to use Python in Excel for data cleaning https://www.makeuseof.com/dont-need-coder-use-python-excel-data-cleaning/ Getting started is easier than you think. Microsoft hid the hardest parts and left you with the useful ones Using Python in Excel. Python handles messy data that would take dozens of formulas Once
Lees verderYou don’t need to be a coder to use Python in Excel for data cleaning
You don’t need to be a coder to use Python in Excel for data cleaning https://www.makeuseof.com/dont-need-coder-use-python-excel-data-cleaning/ Getting started is easier than you think. Microsoft hid the hardest parts and left you with the useful ones Using Python in Excel. Python handles messy data that would take dozens of formulas Once
Lees verder“This Excel feature helps me make better decisions (and avoid regrets)”
This Excel feature helps me make better decisions (and avoid regrets) https://www.makeuseof.com/what-if-analysis-feature-in-excel-for-better-decisions/ Goal Seek – Find out how you can reach your target Scenario Manager – Compare your best case, worst case, and most likely scenarios Data Tables – Test dozens of possibilities in seconds
Lees verder“These 3 Excel functions make me feel like a spreadsheet wizard”
These 3 Excel functions make me feel like a spreadsheet wizard https://www.makeuseof.com/excel-functions-feel-like-spreadsheet-wizard/ 4 The SEQUENCE function generates data automatically – Create dynamic number and date sequences 3 LET makes complex formulas maintainable – Eliminate repetitive calculations and improve readability 2 LAMBDA creates reusable custom functions – Build custom functions for
Lees verder“I replaced Excel’s PivotTables with this extremely overpowered tool and haven’t looked back”
I replaced Excel’s PivotTables with this extremely overpowered tool and haven’t looked back https://www.makeuseof.com/excel-power-pivot-better-than-pivottables/ +++ Power Pivot – Overview and Learning – Microsoft Support https://support.microsoft.com/en-us/office/power-pivot-overview-and-learning-f9001958-7901-4caa-ad80-028a6d2432ed Start the Power Pivot add-in for Excel – Microsoft Support https://support.microsoft.com/en-us/office/start-the-power-pivot-add-in-for-excel-a891a66d-36e3-43fc-81e8-fc4798f39ea8 Get started with Power Pivot in Microsoft Excel – Microsoft Support https://support.microsoft.com/en-us/office/get-started-with-power-pivot-in-microsoft-excel-fdfcf944-7876-424a-8437-1a6c1043a80b +++ Power
Lees verder“I make messy Excel data beautiful in minutes and it’s all thanks to these 5 tips”
I make messy Excel data beautiful in minutes and it’s all thanks to these 5 tips https://www.makeuseof.com/make-messy-excel-data-beautiful/ 5 Clean up text with TRIM, CLEAN, and PROPER 4 Apply consistent styles with table and cell formatting 3 Highlight what matters with Conditional Formatting 2 Show trends instantly with Sparklines 1 Freeze
Lees verder“I Stopped Wasting Time in Excel When I Learned These 3 Functions”
“I Stopped Wasting Time in Excel When I Learned These 3 Functions” https://www.makeuseof.com/excel-functions-time-saver/ FILTER SUMIFS / COUNTIFS XLOOKUP ++ FILTER function – Microsoft Support https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759 SUMIFS function – Microsoft Support https://support.microsoft.com/en-us/office/sumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b XLOOKUP function – Microsoft Support https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929 ++ De functie FILTER – Microsoft Ondersteuning https://support.microsoft.com/nl-nl/office/de-functie-filter-f4f7cb66-82eb-4767-8f7c-4877ad80c759 SOMMEN.ALS, functie – Microsoft Ondersteuning
Lees verder9 Excel Mistakes You Should Never Make
9 Excel Mistakes You Should Never Make https://www.makeuseof.com/excel-mistakes-you-should-never-make/ Relying on Hard-Coded Values Making Formulas Too Complex Printing Without a Preview Check Creating Too Many Worksheets Missing Out on Time-Saving Excel Formulas Forgetting to Enable Auto-Save Not Securing Sensitive Information Ignoring Proper Data Formatting Skipping Regular File Backups
Lees verderMost Excel users don’t know that these features exist
Most Excel users don’t know that these features exist https://www.makeuseof.com/excel-features-you-didnt-know/ 7 Watch Window – Keep important cells in sight without scrolling 6 Camera Tool – Create live snapshots of your data 5 Custom Views – Instantly edit your spreadsheet for different audiences 4 Goal Seek – Work backwards to find
Lees verder6 Power Features in Excel Most People Never Touch (But Should)
6 Power Features in Excel Most People Never Touch (But Should) https://www.makeuseof.com/excel-features-you-should-use/ Conditional Formatting Formula Auditing Flash Fill Pivot Tables Data Validation Quick Analysis
Lees verderEen grafiek met iconen of afbeeldingen
V. Canva maakt mooie grafieken met illustraties. Kan er ook zo iets in Excel? A. Ja hoor. Maak je grafiek (bijvoorbeeld staaf of kolom). Rechtsklik op de grafiek, en dan Opvulling, Afbeelding. Kies bv. een icoon. Rechtsklik op de grafiek, en kies Gegevensreeks opmaken. Kies daar voor Stapelen. Je kan
Lees verderGROUPBY en PIVOTBY: draaitabellen met functies
Microsoft is nieuwe functies aan het uitvouwen waarmee je dingen die je kan doen waarvoor je (vroeger?*) draaitabellen nodig hebt (had?*) * = laat ons nog even wachten om te zien of dit effectief opvolgers worden. Maar in elk geval: je moet eerst weten wat draaitabellen zijn, hoe ze werken
Lees verderReguliere expressies in Excel
Er zijn een aantal nieuwe functies in Excel die het werken met strings ernstig vergemakkelijken, omdat ze reguliere expressies gebruiken. Dit is wat het is: Reguliere expressie – Wikipedia https://nl.wikipedia.org/wiki/Reguliere_expressie En in Excel is dit op komst: What’s New in Excel (May 2024) – Microsoft Community Hub https://techcommunity.microsoft.com/t5/excel-blog/what-s-new-in-excel-may-2024/ba-p/4133490 New Regular
Lees verder