Skip to content
EasyTweaks.com
  • Home
  • Excel
  • Online Collaboration
  • Outlook
  • Python Automation
  • Office Automation
  • Data Analysis
  • Data Visualization

Microsoft Excel

How to insert a bar chart into Microsoft Excel 365 worksheets?

One of the best ways you can represent numerical data is by using bar graphs. For instance, if you want to represent a trend that has been growing over time, using a bar graph will make it much easier for the audience to understand than leaving the numerical data in tables. Fortunately, it is very … Read more

Categories Microsoft Excel

How to add data labels and callouts to Microsoft Excel 365 charts?

Here’s a question from a reader: I use Microsoft 365 Excel for data entry purposes. Once i have the data ready in the spreadsheet i would like to create different charts: pie, bars and so forth, on my data. It seems that by default no labels are posted in my chart making it harder to … Read more

Categories Microsoft Excel

How to combine multiple Excel 365 / 2021 spreadsheet columns into one column?

Using a quick formula to combine multiple Excel columns into one is much quicker than doing it manually. In this quick post, we’ll show two methods to do this: the ampersand formula or the CONCAT function. They are both simple, so you can choose any of the two. I will share the step-by-step procedure for … Read more

Categories Microsoft Excel

How to export your Excel 2019 / 365 spreadsheet and save as CSV?

The other day, i received the following email: Hey there, what would be the easiest way to save my Excel 2016 spreadsheet content into a “comma separated value” file that i can pass to a supplier i work with? All in all, it’s just one worksheet that i need to send out to them once … Read more

Categories Microsoft Excel

How to remove duplicated rows in an Excel 2019/365/2016 spreadsheet?

Here’s a typical data analysis question we get from time to time: I have a spreadsheet with over 100,000 rows Excel spreadsheet that has a bunch of customer information which i need to clean up for duplicates. I would estimate that it will take a me a few days to scrub the list manually. A … Read more

Categories Microsoft Excel

How to export data from Microsoft Access tables to .CSV, xlsx and text formats?

Here’s a question from Kevin: Just starting out with Microsoft Access and looking into sample database i just built. Wanted to understand bit more about the procedure for exporting data from an existing table. I understand that if i am interested to apply some follow up analysis to the data using Python’s Pandas library, then … Read more

Categories Microsoft Excel

How to enable Power Pivot data analysis for Excel if it is missing?

Here’s a question from a reader: Just heard of a new Business Intelligence add-in from Microsoft that ships with Excel and lets you crunch data from different data sources at the same time. That sounds interesting.Looks like Power Pivot is missing in my system, as i don’t see it in my Excel 365 installation. How … Read more

Categories Microsoft Excel

Microsoft 365 Excel Macros for beginners: How to record and write VBA Macros in your Excel 2019 workbooks?

Post updated: August 2021 Here’s a reader question: I have a co-worker that is using Excel VBA Macros to analyze a bunch of data. Can you explain how Macros work, and probably suggest a way for me to pick that skill up? Any simple tips for beginners are very much appreciated. Thanks for the question. … Read more

Categories Microsoft Excel Leave a comment

How to import data from Excel into an Access database?

Applicable to: Office 2019/2016/365 Here’s a question from Mike: “I know how to create Access forms and capture user input into a database table, but as i have already gathered  there a way to automatically import data from an Excel workbook into an Access database table instead”? Good question, Thanks. Yes, you can automatically import … Read more

Categories Microsoft Excel Tags Import Excel to Access 2016 Leave a comment

How to access and open an Excel 97/2003 .xls file in Excel 2016, 2019 and 365?

Last updated: May 2020 Applicable to: Microsoft Office Excel 365, 2019, 2016, 2013, 2007. Windows 7 and 10 operating systems. Skyler set us a note about her Microsoft Excel spreadsheet not opening: “I work as an analyst and have a significant number of old .xls files were created in the previous versions of Excel. Now … Read more

Categories Microsoft Excel Tags Open xls file in Excel 2016 4 Comments
Post navigation
Older posts
Page1 Page2 Page3 Next →

Recent Posts

  • How to lowercase Pandas DataFrame column names and values?

  • How to get the first column of a Pandas DataFrame?

  • How to sum multiple columns with nan values in Pandas?

Search Easytweaks.com

© 2007-2022 by EasyTweaks.com. All rights reserved. Posts in this site may contain affiliate links.
Contact Us || Sitemap || Privacy || Terms of Service