The Microsoft Excel Spreadsheet Course

Looking to master Microsoft Excel or Google Sheets? This multi lesson series offers step-by-step instruction to help you become proficient in developing and managing spreadsheets.

Product Features:

• What are spreadsheets?
  • Defining Spreadsheets
  • Benefits of Spreadsheets
  • Careers that benefit from Spreadsheets

• Adding Data
  • Copy and paste data
  • CSV file to import data
  • Manually add data

• Cleansing Data
  • Filter data
  • Sort data
  • Delete columns and rows

• Formatting Data
  • Font style, font size, font color
  • Color cell, cell borders, resize cell
  • Currency values

• Aligning Data:
  • Aligning Data (Center, Right, Left)
  • Merging Data Horizontal Merge, Vertical Merge

• Conditional Formatting
  • Colors

• Math Formulas
  • Math Inside of the Cell
  • Cell Reference Math
  • MIN, MAX, SUM, AVG

• Lookup Formulas
  • Vlookup
  • Hlookup
  • Xlookup

• Logical Formulas
  • OR
  • AND
  • IF

• IF Statements
  • SUMIF and SUMIFS
  • COUNTIF and COUNTIFS

• Combining Formulas
  • String
  • Concatenation

• Charts
  • Pivot Tables
  • Bar Charts

• This material can be used to learn/teach both Microsoft Excel and Google Sheets

Includes:

• 116 PowerPoint Slides
• Additional instructional videos created by © All 4 Computer Science
• 12 Quizzes
• 1 Project (Card Game)

MORE TO COME

Keywords: Coding, HTML, CSS, JavaScript, Web Page Design, Programming, Lessons, Resources, Computer Science, Google Sheets, Microsoft Excel

Contact via email

✉ allforcomputerscience@gmail.com