Browsing Tag
Excel
26 posts
Microsoft Excel: Easy guide for beginners with formulas and more
Microsoft Excel know-how is so expected that it hardly warrants a line on a resume anymore. But how…
How to Use the Weighted Average Formula in Excel
If someone asks me to find the average of five values — 1, 4, 7, 8, and 10…
How to Learn Excel Online: 21 Free and Paid Resources for Excel Training
Faced with an urgent need to brush up my spreadsheet skills, I went online and searched for the…
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…
