Browsing Tag
Excel
23 posts
Memory-efficient mass data transfer between Excel and database using Apache POI, Spring Event, Async Threads
Create an Excel file with millions of rows of data from the database with minimal impact on heap…
Merging data from multiple Excel files
In our work, we often receive Excel tables with data in the same format. If we want to…
How to Use Power Queries in Excel
Though tech tools offer a wide variety of data management solutions, consolidating information from multiple sources remains a…
How to Use the SUBTRACT Function in Excel
Excel is a powerful spreadsheet program from Microsoft that makes it easy to work with numbers and other…
How to Password Protect an Excel File
If you’re like millions of other users, you use Excel spreadsheets to plan your budgets, track sales or…
How to Use the COUNTIF Function in Excel
Excel can do more than just simple math. That’s thanks to its bevy of built-in functions and min-formulas…
How to Use Excel Like a Pro: 29 Easy Excel Tips, Tricks, & Shortcuts
Sometimes, Excel seems too good to be true. All I have to do is enter a formula, and…
How to Use VLOOKUP Function in Microsoft Excel [+ Video Tutorial]
Coordinating a massive amount of data in Microsoft Excel is a time-consuming headache. Thankfully, you don’t have to.…
Merge Cells in Excel in 5 Minutes or Less
Knowing the ins and outs of Excel is essential for organizing data, understanding analytics, and getting the most…
How to Create a Heat Map in Excel
Heat maps in Excel help businesses to visualize large data sets, transforming a pool of numbers into easily…