How to add a regression line to an Excel scatter chart?

In today’s Data Analysis tutorial we’ll learn how to create a scatter plot with a regression line in Microsoft Excel. Create example data We’ll get started by creating a very simple data set that you can easily copy into an Excel spreadsheet and follow along. Sales Revenue 345 45.41088 312.0128 68.19295 234.7125 42.02261 248.6958 32.54282 … Read more

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