Section 1: Spreadsheet Basics With Excel

MOOC Summaries - Career Edge - Business and Data Analysis

Section 1: Spreadsheet Basics With Excel

“Introduction … Purpose, Format, and Structure … Essential Excel Functions … IF Functions and VLOOKUP … Conclusion”
(Source)

Summaries

  • Section 1: Spreadsheet Basics with Excel > Subsection 1: Introduction > 4.1.1.1. Introduction to Spreadsheet Basics
  • Section 1: Spreadsheet Basics with Excel > Subsection 2: Purpose, Format, and Structure > 4.1.2.2. Navigating Excel
  •  Spreadsheet Basics with Excel > Subsection 4: IF Functions and VLOOKUP > 4.1.4.1. Essential Excel Functions: SUMIF and COUNTIF

Section 1: Spreadsheet Basics with Excel > Subsection 1: Introduction > 4.1.1.1. Introduction to Spreadsheet Basics

  • Spreadsheets are a collection of individual data ‘cells’ that enable the user to store information, perform calculations, and generate graphs in a quick, easy, and flexible way.
  • A spreadsheet can serve as a quick and flexible calculator that will allow you to tackle and model complex analyses.
  • We’ll start by covering some of the basics, then gradually explore the key formulas that can help you uncover essential data insights with confidence and ease.
  • While many features of spreadsheets are consistent across applications, different programs and program versions will vary in their navigation and tools.

Section 1: Spreadsheet Basics with Excel > Subsection 2: Purpose, Format, and Structure > 4.1.2.2. Navigating Excel

  • Microsoft Excel is a powerful software application that can help you aggregate, synthesize, and share large amounts of data and information.
  • Step-by-step review of Excel’s navigation.

  • Step-by-step demo of functions.

Return to Summaries List.

photo: depositphotos/thodonal
Print Friendly, PDF & Email