Blog Articles: Excel and Google Sheets

When you want to apply formatting in Excel based on certain criteria, it's called Conditional Formatting. This list of in-depth tutorials will help you find the answers you need so that you can learn and apply this useful function.  If you can't find what you're looking for or need answers...

Microsoft Excel is a powerful tool to save and analyze a variety of data. It is used in education, by small businesses, and by some of the world's largest corporations for daily tasks. But, what if the program isn't working as smoothly as you would like or a formula doesn't...

Alan Murray is the founder of Computergaga, which offers Excel training courses online, in person and via his popular YouTube channel. He values teaching Excel users at all levels and showing them the tools that can save time and drive efficiency. He spoke with us recently about his customer’s needs,...

Summary Loan Amortization Terms You Should Know Free Loan Amortization Schedule Templates for Excel General Loan Amortization Schedule Templates Mortgage Amortization Schedule Templates Loan Amortization Schedule Templates for Home Equity Auto Loan Amortization Schedule Templates If you've taken out a loan or plan to do so in the future, you...

Microsoft Excel is considered the standard in both business and education for data analysis. The spreadsheet program is used to gather, maintain, process, and make sense of large data sets.  While Excel can store and display your figures with ease, it makes sense to use the functions available with the...

Mike Girvin has been delivering free Excel education via YouTube since 2008, with more than 3,000 videos, 100 classes and playlists, and 500,000 subscribers. His excelisfun YouTube channel delivers free videos, Excel magic tricks, pdf notes, Excel and Power BI files and practice problems on a wide range of concepts...

Ken Puls is an Excel guru. His blog offers downloadable courses, free utilities and help forums and live training. An accountant by trade, Puls helps clients with Power Query training and other basic, intermediate and advanced Excel skills. Puls spoke with us recently about why Excel is so ubiquitous and...

If you're looking for new ways to stay organized, a calendar or daily planner is a good start. Keeping your days, hours, and minutes filled with the right things will make you more productive, and Excel has several tools that can help.  This is a versatile program, and you can...

John Michaloudis is the founder and chief inspiration officer of MyExcelOnline, an online resource for Excel users looking to learn via webinars, online courses and podcasts. He began writing an internal Excel newsletter while working for General Electric before he realized there was a massive demand for help with the...

Pivot tables are one of Excel's most powerful functions, but they are also one of the most intimidating. These are powerful because they can help you make sense of and summarize a massive amount of data. The intimidation comes in because these tables have a reputation for being complex, so...