Microsoft Excel

Essential Skills and Concepts for Spreadsheets (Calc, Excel)

Build a foundation in any spreadsheet application including: Open Office Calc, Microsoft Excel, Google Sheets, etc.
Rating: 4.3 out of 5 (195 ratings)
6,722 students
Created by Derek Armstrong
English
English [Auto]
This course will cover data entry, data manipulation, charting, and pivot tables.

Requirements

  • Access to a spreadsheet application (Open Office Calc, Microsoft Excel, Google Sheets, etc.)

Description

This course covers:

  • Vendors of spreadsheets

  • Data entry

  • Spreadsheet skills (sort and filter)

  • Spreadsheet skills (data manipulation)

  • Charting

  • Pivot tables

Upon completion of the course, please submit a review and share on your social media if you thought the course was helpful. Thank you.

UPDATE (3/30/2020): The cost of this video course is now FREE. The associated Reference Guide for this section is available as a PDF download at the StrongStartComputing .com website ... see "REFERENCE GUIDES TO YOUTUBE COURSES" blog post.

Alternatively, the entire ESC4C Reference Guide can be purchased on Amazon as a paperback ($14.99) or Kindle eBook ($5.99) format.

NOTE: This course was taken directly out of my ESC4C course (Part B - Section 12).

Who this course is for:

  • Beginner to intermediate level users who want to improve their productivity, and provide decision making information to management.

Course content

1 section • 5 lectures • 1h 18m total length

  • Free Preview for ESC4Spreadsheets
    00:52
  • Introduction
    00:52
  • Basic Skills
    24:52
  • Data Manipulation Skills
    31:12
  • Charting and Pivot Tables
    21:02

Instructor

Derek Armstrong
Information Security Tester
Derek Armstrong
  • 4.2 Instructor Rating
  • 343 Reviews
  • 14,702 Students
  • 3 Courses

My original degree was in mechanical engineering at New Mexico State University, and I have an MBA from the University of California-Riverside. However, for the last eighteen years I have worked in information technology, and more specifically,  information security for the last eight. I have achieved several certifications in infosec including a CISSP. I have enjoyed working in the IT field, and would now like to share some of the things I've learned along the way to help others get started in this field.