Microsoft recently added a new optical character recognition feature to Excel that lets users import data from a photograph taken from a smartphone. Here's how to use it. I first started using ...

Tracking stock performance is a critical process all investors must follow. Although Google Finance has several options to let you measure performance, you may want to do advanced mathematical ...

It's time to dump the pie charts and move to donuts or even waterfalls to show off your data in ways people can better grasp. Have you noticed that people groan when you pop open a spreadsheet to ...

Most of us use Microsoft Excel in our daily life in many ways. We use it to keep track of tasks to be completed using color coding and people dealing with business, use it to keep track of products ...

When you think about serial communications, Microsoft Excel isn’t typically the first program that springs to mind. But this spreadsheet has a rather powerful scripting language hidden away inside it, ...

I don’t use Microsoft Excel all that often, so it remains a bit of a mystery to me. I can enter text and create graphs and that’s basically it. That’s why I’ve set myself a goal to learn one new Excel ...

Placing spreadsheet data into a table quickly formats it and makes it easy to work with and analyze. Here’s how to use this basic yet powerful Excel tool. Tables are one of the fundamental tools in ...

Spreadsheets aren’t just for business owners and data analysts—here are some easy ways to integrate Microsoft Excel into your life. Microsoft Excel is part of the Excel is part of the Microsoft Office ...

Microsoft on Thursday announced some Excel and Power BI enhancements that add "connected data types" on top of the standard strings and numbers options. Connected data types give access to a lot of ...

Power Query is a game-changer in terms of the amount of time I save, ensuring imported data is ready for analysis in Excel. If you're new to this tool, it's helpful to know a few commands that can ...

While opening an Excel spreadsheet, if you get an error message saying External Data Connections have been disabled, here is how to get rid of it. It appears when ...

Use Excel data validation to prevent duplicate values in a column Your email has been sent Prevent duplicates before they happen by combining a simple function with data validation. Excel has built-in ...