Basic tasks in Excel - Excel - Office Support - Office 365

Loading...

Sign in

Apps Install Account Training Admin

Excel / Get started / Basics / Basic tasks in Excel

Basic tasks in Excel Applies To: Excel 2016, Excel 2013, Excel 2010

Excel is an incredibly powerful tool for getting meaning out of vast amounts of data. But it also works really well for simple calculations and tracking almost any kind of information. The key for unlocking all that potential is the grid of cells. Cells can contain numbers, text, or formulas. You put data in your cells and group them in rows and columns. That allows you to add up your data, sort and filter it, put it in tables, and build great-looking charts. Let’s go through the basic steps to get you started. Create a new workbook Enter your data Apply cell borders Apply cell shading Use AutoSum to add your data Create a simple formula Apply a number format Put your data in a table Show totals for your numbers using Quick Analysis Add meaning to your data using Quick Analysis Show your data in a chart using Quick Analysis Sort your data Filter your data Save your work Print your work Activate and use an add-in Find and apply a template





Connect with an expert CONTA CT US



Expand your skills E X P LORE TRA I NI NG

Was this information helpful?



Yes



No

Loading...

Basic tasks in Excel - Excel - Office Support - Office 365

Sign in Apps Install Account Training Admin Excel / Get started / Basics / Basic tasks in Excel Basic tasks in Excel Applies To: Excel 2016, Excel ...

267KB Sizes 1 Downloads 15 Views

Recommend Documents

Excel Glossary - Excel - Office Support - Office 365
An address can be a URL (Web address) or a UNC path (network address), and can include a specific location within a file

Basic tasks in Visio - Visio - Office Support - Office 365
Each type drawing has templates, each with its own set of shapes that are ready to use. Just drag the shapes onto the dr

Basic tasks in Word 2013 - Word - Office Support - Office 365
Opening documents, reading, track changes and other basic tasks in Microsoft Word 2013. ... Microsoft Word 2013 is a wor

Featured Excel Templates - Office Templates - Office 365
Featured Excel Templates. Welcome to Excel Excel · Formula tutorial Excel · PivotTable tutorial Excel · Simple budget Ex

Apply data validation to cells - Excel - Office Support - Office 365
Use data validation rules to control the type of data or the values that users enter into a cell. One example of validat

Display numbers as fractions - Excel - Office Support - Office 365
123 26/57, rounding to the nearest double-digit fraction value ... If no fraction format is applied to a cell, and you t

Add and subtract numbers - Excel for Mac - Office Support - Office 365
Adding and subtracting in Excel is easy; you just have to create a simple formula to do it. Just remember that all formu

Microsoft Office Excel
Mar 25, 2008 - Download free books at BookBooN.com. Excel 2007. 6. Contents. 4. Copying cells. 30. 4.1. Simple Copying.

Load the Solver Add-in in Excel - Office Support
Load the Solver Add-in in Excel - Office Supporthttp://support.office.com/.../Load-the-Solver-Add-in-in-Excel-612926fc-

Load the Analysis ToolPak in Excel - Office Support
You provide the data and parameters for each analysis, and the tool uses the appropriate statistical or engineering macr