Monthly Archives: May 2017

Archive of posts published in the specified Month

Excel 2016: Cell Basics

cellb_select_range

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

saving_sharing_autorecover_manage

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

creating_opening_template_new

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

onedrive-personal

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

getting_started_interface_start

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

duplicates_find_duplicates

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

parameter_intro

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

calc_total_expressions

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

design_template_new

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

formatting_button_action

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