Let's learn about Excel via these 72 free blog posts. They are ordered by HackerNoon reader engagement data. Visit the Learn Repo or LearnRepo.com to find the most read blog posts about any technology.
Excel is a powerful spreadsheet program developed by Microsoft, widely used for data organization, analysis, and visualization. It matters as an indispensable tool for businesses and individuals for financial modeling, data tracking, and reporting.
1. How to Create Word Documents Within Excel VBA
By the end of this article, you’ll be able to create Word documents from within Excel VBA.
2. How to get data from API in Excel
How to get data from API JSON in Excel table with the simplest tutorial with formula. Ready to go open-sourced VBA formula with intuitive video tutorial
3. How To Use Microsoft Excel To Classify Your Data
An accessible introduction to ML - no programming or math required. By the end of this tutorial, you’ll have implemented your first algorithm without touching a single line of code. You’ll use Machine Learning techniques to classify real data using basic functions in Excel. You don’t have to be a genius or a programmer to understand machine learning. Despite the popularized applications of self-driving cars, killer robots, and facial recognition, the foundations of machine learning (ML) are quite simple. This is a chance to get your feet wet and understand the power of these new techniques.
4. The Top C# .NET Spreadsheets
Explore the top C# .NET spreadsheets and their notable features for your applications in this review of leading options.
5. The Top Java Excel API Libraries
Explore the top Java Excel API Libraries and their notable features for your applications in this review of leading options.
6. My Favorite Free Excel Courses for Programmers, Data Analysts, and IT Professionals
If you want to learn Microsoft Excel, a productivity tool for IT professionals, and looking for free online courses, then you have come to the right place.
7. The Lambda Function That Creates xlsx Files From JSON Data to Store On S3 Using NodeJS/Typescript
How to write a Lambda function to convert json data to xlsx file and then upload to s3 and return a signed url of that uploaded file on a serverless framework
8. The Top C# .NET Excel API Libraries
Explore the top C# .NET Excel API Libraries and their notable features for your applications in this review of leading options.
9. Simplify Data Conversion: Excel and CSV to Java Objects with Reflection
A powerful library to convert Excel and CSV Files to POJOs and vice versa in Java by using reflection and annotations
10. The Top JavaScript Spreadsheets
Explore the top JavaScript spreadsheets and their notable features for your applications in this review of leading options.
11. The Top React Spreadsheet Tools
Explore the top React spreadsheet tools and their notable features for your applications in this review of leading options.
12. Excel to PDF: A New Innovative Approach to PDF Generation from Microsoft Excel
Discover the challenges of Excel to PDF conversion and see how DynamicDocs Excel PDF Add-in improves the native 'Save As PDF' functionality.
13. Importing, Exporting CSV and Excel XLSX in .NET C# Applications
Learn how to import and export CSV and Excel XLSX in .NET C# applications.
14. Common MS Excel Questions to Help you Excel in a Data Analyst Job Interview
EXCEL Interview Questions for Data Analysts
15. How to Become an Excel Pro: 10 Best Tips
Antonio Reza gives you the best Excel tips to become a verified pro.
16. Top 10 Excel Functions Everyone Should Know
Excel offers a huge variety of features and functions that can improve the ability to perform tasks daily. It does not matter that you are a business owner or an office worker, or any casual Excel user, these 10 Excel functions will definitely benefit your performance on Excel spreadsheets. This article will work like Excel training for you because many Excel tutorials and Excel certification include these functions in their courses.
17. Excel Formulas for Assigning Categories by Value Range Using Functions!
Assigning a category based on a number range is a common practice everywhere in schools, colleges, and offices.
18. My Favorite Free Tutorials to Learn Microsoft Excel in Depth
Want to learn Microsoft Excel in-depth and need free resources? I have created a list of the best free Excel courses from sites like Udemy and Coursera.
19. Excel Hack: How to Get Currency Data in Excel
If you want to convert currency data in Excel, here is a step-by-step guide for you using the Excel Stocks function.
20. The Fastest Way to Become A Professional Data Analyst
Sharyph, a tech writer, goes over how to become a professional data analyst.
21. How to Send a Text Message Over Excel like Kelly Rowland
In 2002, Hip Hop and Pop artists, Nelly and Kelly Rowland collaborated and came out with the smooth R&B classic - Dilemma.
22. Excel DAYS Function Explained: Calculating Date Differences Between Two Dates!
DAYS function in Excel is used to calculate the number of days between two dates.
23. Excel Dates Showing Numbers? Here's the Quick Fix
Fix Excel Date Serial Number Formatting Issue. By default, Excel stores Dates as Serial Numbers starting from January 01, 1990.
24. Top 10 Favorite Google Sheets Features for Everyday Work
Boost your Google Sheets productivity with ten features proven to help your everyday work.
25. How to Extract the Year From Any Date in Excel Using the YEAR Function Effortlessly?
The YEAR function in excel will return the year value in 4 digits from the given input date. The YEAR function was introduced in Excel version 1.0.
26. Using SheetGPT to Create Meta Descriptions for Your Website
Revolutionize e-commerce meta descriptions creation using SheetGPT's integration with Google Sheets. Quickly generate and optimize hundreds of meta descriptions
27. 5 Excel Features That Can Grow Your Net Worth in No Time
Excel is not only an accounting tool, but also an amazing personal finance tool.
28. Python Prevails: 57% Choose Python As Their Go-to Data Science Tool
Data science uses advanced tools to extract meaning and answers from data through various programming, statistic, and communicative mechanisms.
29. Mastering Excel Functions for Data Analysis
Learn how to harness the power of Excel for your data-driven success with this comprehensive guide.
30. Top 25 Microsoft Excel Tips That Will Put You in the Top 1%
Top 25 Microsoft Excel Tips That Will Put You in the Top 1%
31. Spreadsheets Don't Scale Well: Here's How 3 Startups Have Overcome Those Limitations
Spreadsheets are the versatile go-to for a wide array of business practices. Companies use them for everything from finance to marketing analytics. "Just use Excel" has even been the go-to battle cry of data scientists who are frustrated by watching companies waste billions of dollars trying to ramp up analytics programs that they're not ready for.
32. Is Excel a Security Risk?
Is Excel a security risk? This guide shows why some people have concerns with using this spreadsheet software for sensitive information.
33. Google Sheets Hack: How to Get Currency Data into Google Sheets
I recently came across the challenge of getting currency exchange data into spreadsheets. In this article, I show two quick and easy methods to do so.
34. My Challenge to Excel Users: I Dare you to Learn How to Code
What if, instead of starting that next Excel spreadsheet, you tried your hand at trying to write some code to do the exact same thing?
35. 4 Data Transformations Made Spreadsheet-Easy
Gigasheet combines the ease of a spreadsheet, the power of a database, and the scale of the cloud.
36. Avoid Data Loss: Merge Excel Cells with TEXTJOIN & CONCAT Functions!
The issue “Merging cells only keeps the upper-left value and discards others” happens when you try to merge cells that contain more than one value.
37. How To Add A Check Symbol In Excel and Word
If you use Microsoft Word and Excel frequently, you might have repeatedly had the question of how to add symbols such as the tick or checkmark in your document or spreadsheet. Keep reading to learn about the various shortcuts you can use to make these routine tasks take less time and effort.
38. 5 Ways to Add Security to Excel & PDF with .NET Document APIs
Learn how GcExcel helps to ensure your application’s code security in these 5 ways!
39. Quickly Extract Month Values in Excel with the MONTH Function
The MONTH function in Excel is used to extract the month number (1 to 12) from a given input date.
40. Using Minute Function to Extract Minutes From Input Time Like a Pro
The MINUTE function is used to extract the minute portion from a given input time value and returns the output as the numerical value.
41. Excel NOW Function: Real-Time Date & Time in Your Sheets
The NOW function in Excel returns the current date and time based on your computer’s system clock.
42. The Future Of Tech With An Excel Expert
How someone went from a financial analyst far too familiar with Excel to the solutions architect at a tech company specialising in productivity apps.
43. What is the DynamicDocs Excel Add-In and How Do You Use It?
DynamicDocs Excel Add-in integrates with DynamicDocs API and generates PDFs directly from Excel. In this article, we describe how to get started.
44. How Better Sheets Can Help You Kick Ass With Google Sheets!
Better Sheets offers tutorials, templates, tools, and monthly updates based on 10 years of professional experience and feedback from 5,000 students.
45. How to Unite Excel’s Power with Jira and Confluence’s Functionalities
Learn how you can create detailed graphs, extensive spreadsheets, and other Excel functionalities in Jira and Confluence without having to switch to Excel.
46. Calculate Date Differences Easily Using Excel DAYS Function!
DAYS function in Excel is used to calculate the number of days between two dates. It is supported in all modern versions of Excel.
47. Here's How to Use Excel's EDATE Function to Return a Specific Date In the Past or Future
EDATE Function returns a date that is a specified number of months before or after a given start date.
48. How to Convert Radians to Degrees in Excel Using Simple Formulas
In Excel, the RADIANS function directly converts a given degree value into its equivalent radian value. By default, the RADiANS function in Excel
49. Augmented Analytics & Data Storytelling: Covid Ups FP&A Demand
Businesses need agile tools to quickly identify and communicate actionable insights for more informed decision-making.
50. This Tool Unlocks Unlimited Free Data for Testing, Prototyping, and Demos
Bloomer mock tool can generate random mock customised data for free. No limit on number of records that can be generated.
51. 7 Essential Things in Excel That You Definitely Need to Master
Learn essential features for efficient data analysis and boost your professional productivity in Excel.
52. How to Use Excel TODAY Function? -> Excel 24x7
How to Use Excel TODAY Function? -> Excel 24x7
53. How to Export Your Data from WordPress
A useful selection of tools that will help you export different types of data from WordPress site for migrations, analytics or other purposes.
54. How to Calculate Age from Date of Birth in Excel? -> Excel24x7!
How to Calculate Age from Date of Birth in Excel? -> Excel24x7!
55. Calculate Workdays in Excel With the NETWORKDAYS Function Like a Pro!
The Excel NETWORKDAYS Function returns the number of available working days between the starting date and the ending date. It automatically excludes weekends.
56. Using the Excel DAYS360 Function for Financial Analysis- A Guide
The DAYS360 function in Excel is used to calculate the number of days between two dates based on a 360-day year.
57. Step-by-Step: Transform Text Case in Excel Using Formula
In Excel, you can easily convert the text string into Sentence Case.
58. How WEEKNUM Simplifies Date Management in Excel
The WEEKNUM function in Excel is used to return the week number from a given input date.
59. How to Use Excel DATE Function -> Excel 24x7
The Excel DATE function is useful when you need dates that update automatically based on other values in your worksheet.
60. How to Calculate ISOWeekNumbers in Excel: Step-by-Step
The ISOWEEKNUM function returns the week number of the year based on the given date value in Excel.
61. The Best Way to Use the Excel NETWORKDAYS.INTL Function
The Excel NETWORKDAYS.INTL Function is used to return the number of work days between the starting dates and the ending dates
62. How Do I Find the Cell That Contains the Maximum or Minimum Value in Excel?
Find the cell addresses that have both the maximum and minimum values in rows and columns. Find the cell address of the cell that contains the maximum value in
63. Using Excel's TIME Function to Return Time From Hour, Minute, Seconds!
Excel TIME Function is used to create or return a valid Excel time value from individual hour, minute, and second values.
64. EOMONTH Function: Simplifying Monthly Financial Calculations in Excel
EOMONTH is a simple yet effective Date related Function in the Microsoft Excel.
65. Sync Excel Worksheets With VBA & the 'Select All Sheets' Method
In Excel, you may often work with multiple worksheets or workbooks while managing data. Sometimes, you need to sync data between two or more worksheets.
66. Learn How to Use the SECOND Function to Retrieve Second Values from Input Time?
The SECOND function in Excel extracts the seconds part of a given input time and returns a number between 0 and 59.
67. Quickly Return Hour Values with Excel's HOUR Function!
HOUR function is used to return the hour as a number between 0 and 23 from a given time.
68. Reverse Excel Cell Signs With the Paste Special & VBA in Easy Steps
In this tutorial, I’ll explain how to reverse the sign of numbers in Excel using both formulas and VBA code, along with clear examples for better understanding
69. GPT Is Changing the Way We Use Excel — Forever
Large Language Models (LLMs) GPT is transforming the way we use Excel by making the process of learning formulas conversational.
70. How to Use Excel WEEKDAY Function?
Excel WEEKDAY function returns the day of the week as the number.
71. Essential Excel Shortcuts to Speed Up Your Daily Tasks!
This tutorial includes shortcuts for both Windows and Mac users. From basic navigation to advanced data operations, this tutorial covers everything you need.
72. Master Excel: Essential File Options Shortcuts You Need Now
Here is a list of shortcuts available in the Excel application. These shortcuts can help you use Excel quickly and more efficiently
Thank you for checking out the 72 most read blog posts about Excel on HackerNoon.
Visit the /Learn Repo to find the most read blog posts about any technology.