Monthly Archives: May 2017

Archive of posts published in the specified Month

Excel 2016: Cell Basics


Introduction Whenever you work with Excel, you’ll enter information—or content—into cells. Cells are the basic building blocks of a worksheet. You’ll need to learn the basics of cells and cell content to calculate, analyze, and organize data in Excel. Optional: Download our practice…

Read more

Excel 2016: Saving and Sharing Workbooks


Introduction Whenever you create a new workbook in Excel, you’ll need to know how to save it in order to access and edit it later. As with previous versions of Excel, you can save files locally to your computer. But unlike older versions,…

Read more

Excel 2016: Creating and Opening Workbooks


Introduction Excel files are called workbooks. Whenever you start a new project in Excel, you’ll need to create a new workbook. There are several ways to start working with a workbook in Excel. You can choose to create a new workbook—either with a…

Read more

Excel 2016: Understanding OneDrive


Introduction Many of the features in Office are geared toward saving and sharing files online. OneDrive is Microsoft’s online storage space you can use to save, edit, and share your documents and other files. You can access OneDrive from your computer, smartphone, or…

Read more

Excel 2016: Getting Started with Excel


Introduction Excel is a spreadsheet program that allows you to store, organize, and analyzeinformation. While you may believe Excel is only used by certain people to process complicated data, anyone can learn how to take advantage of the program’s powerful features. Whether you’re…

Read more

Access 2016: How to Create a Find Duplicates Query


Introduction A find duplicates query allows you to search for and identify duplicate records within a table or tables. A duplicate record is a record that refers to the same thing or person as another record. Not all records containing similar information are…

Read more

Access 2016: Creating a Parameter Query


Introduction A parameter query is one of the simplest and most useful queries you can create. Because parameter queries are so simple, they can be easily updated to reflect a new search term. When you open a parameter query, Access will prompt you…

Read more

Access 2016: How to Create Calculated Fields and Totals Rows


Introduction Calculated fields and totals rows let you perform calculations with the data in your tables. Calculated fields perform calculations using data within one record, while totals rows perform a calculation on an entire field of data. Calculated fields When you create a…

Read more

Access 2016: Designing Your Own Database


Introduction Now that you know how to use and modify existing databases, you might be interested in designing your own. Database design can be very complicated—so complicated, in fact, that people take extensive courses just to learn how to plan them. For this…

Read more

Access 2016: Formatting Forms


Introduction After creating a form, you might want to modify its appearance. Formatting your forms can help make your database look consistent and professional. Some formatting changes can even make your forms easier to use. With the formatting tools in Access, you can…

Read more