How to Protect a Worksheet in Excel

Feb 21, 2020

Protect your complicated formulas in Excel by locking down certain cells, or hiding the formulas used in the cells. Only allow users to edit cells where needed.

How to protect the workbook structure in Excel

Feb 21, 2020

This example teaches you how to protect the workbook structure in Excel.

How to Convert an Excel File to XML data file

Feb 21, 2020

Extensible markup language (XML) is a common format for working with data. And if you want to get your spreadsheet from Excel to another program, you might have to use it.

How To Import or export text files in Excel

Feb 21, 2020

In this article we will learn how to import the text file in Excel file and how to export file into text file.

How to Get Data using MS Query in Excel

Feb 21, 2020

This example teaches you how to import data from a Microsoft Access database by using the Microsoft Query Wizard.

Computer Vision Basics in Microsoft Excel (using just formulas)

Feb 18, 2020

Computer Vision is often seen by software developers and others as a hard field to get into.

How To import Data from Access database into excel

Feb 08, 2020

Here we will take a look at how to import the database using Access and Excel.

How to Edit files Using Excel Online in OneDrive

Feb 08, 2020

You can edit Excel files with Excel Online from anywhere without having Excel installed on your computer.

How To Save your Excel files to OneDrive in Excel

Feb 08, 2020

Save your Excel files to your OneDrive location and access your files from any computer or share it with other people.

How To share a workbook in Excel

Feb 08, 2020

If you share a workbook in Excel 2016 or earlier, you can work with other people on the same workbook at the same time.