Spreadsheets

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Share tech news, updates, or what's on your mind.

Sign up to Post

Viewers will learn the basics of using Excel Tables, the benefits found with them, and some pitfalls.
5
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
5
Viewers will learn how to share Excel data with others from desktop Excel, as well as Excel Online via OneDrive, and embed an Excel file on a website.
2
Viewers will learn the basics of the new Quick Analysis feature in Excel 2013.
0
Viewers will learn the basics of printing in Excel 2013 and how to adjust some common settings.
0
Viewers will learn a basic data manipulation technique of unpivoting data in Power Query for Excel 2013 and the importance of using good data.

1. Start with data in a poor structure

2. Create a table on your data

3. Unpivot columns

4. Rename columns

5. Apply query and close editor

6. Summarize data in newly created table

5
Viewers will learn a basic relationship technique in Power Pivot for Excel 2013.
1
Viewers will learn how to create a PivotTable and make basic changes to it in Excel 2013.
6
Viewers will learn the basics of formula auditing in Excel 2013.
1
Viewers will learn the basics about Excel 2013’s new Flash Fill feature.
0
Viewers will learn how to find and create templates in Excel 2013.
0
Viewers will learn the basics of using filtering and sorting in Excel 2013.
1
Viewers will learn about various customizable options in Excel 2013.
0
Viewers will learn about using Excel in a browser with Excel Online.
0
Viewers will learn various types of data validation for different data types in Excel 2013.
1
Viewers will learn how to customize the ribbon and quick access toolbar in Excel 2013.
1
Viewers will learn what comprises a theme in Excel 2013, as well as how to customize them.
3
Viewers will learn how to apply various conditional formatting in Excel 2013.
5
Viewers will learn the different options available in the Backstage view in Excel 2013.
1
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
1

Spreadsheets

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.