Microsoft Excel: Spreadsheet (Templates, Charts and Maps, Analyzing Data in Spreadsheet)

19/03/2020 1 By indiafreenotes
  1. Spreadsheet Templates

In Excel or Google Sheets, a template is a file that is saved with a different file extension and serves as a basis for new files. The template file contains a variety of content and settings that are applied to the new files created from the template.

Content and Formatting in a Template

A template can hold a variety of text features, such as page titles, row and column labels, section headings, and more. Save data, including text and numbers. A template can also house graphics, such as shapes, logos, and images, as well as formulas to be reused in new workbooks.

Fonts, text sizing, and color are formatting options you can save to an Excel template. More formatting options include background fill color, column widths, number and date formats, alignment, and the number of default sheets in a workbook.

  1. Charts/Maps in Spreadsheet

Create maps and charts using data collected with your google forms.  You can even publish this map/chart and have it auto update as more people fill out the form.

  • Set up a Named Range on your Form Response Sheet (Countries, Vacation Location, etc.)
  • Set up your sheet. Type in a list of countries.
  • Use the countif formula to count up all the times someone choose that country.
  • Now, you can highlight your entire set of data (countries and numbers).
  • Choose Insert Chart.
  • Choose Map
  • You can edit the colors and customize your map by choosing Advanced edit
  • You can then publish your chart. You can use the embed code to put it in a website, blog, etc.
  1. Analyzing Data in Spreadsheet

To know how to analyze data in excel, you can instantly create different types of charts, including line and column charts, or add miniature graphs. You can also apply a table style, create PivotTables, quickly insert totals, and apply conditional formatting. Analyzing large data sets with Excel makes work easier if you follow a few simple rules:

Select the cells that contain the data you want to analyze.

Click the Quick Analysis button image button that appears to the bottom right of your selected data (or press CRTL + Q).

Selected data with Quick Analysis Lens button visible

In the Quick Analysis gallery, select a tab you want. For example, choose Charts to see your data in a chart.

Pick an option, or just point to each one to see a preview.

You might notice that the options you can choose are not always the same. That is often because the options change based on the type of data you have selected in your workbook.

To understand the best way to analyze data in excel, you might want to know which analysis option is suitable for you. Here we offer you a basic overview of some of the best options to choose from.

  • Formatting: Formatting lets you highlight parts of your data by adding things like data bars and colors. This lets you quickly see high and low values, among other things.
  • Charts: Charts Excel recommends different charts, based on the type of data you have selected. If you do not see the chart you want, click More Charts.
  • Totals: Totals let you calculate the numbers in columns and rows. For example, Running Total inserts a total that grows as you add items to your data. Click the little black arrows on the right and left to see additional options.
  • Tables: Tables make it easy to filter and sort your data. If you do not see the table style you want, click More.
  • Sparklines: Sparklines are like tiny graphs that you can show alongside your data. They provide a quick way to see trends.