Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Noble Desktop

Excel Level I: Fundamentals

via Noble Desktop

Overview

Join us for a beginner Excel workshop where you'll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This comprehensive course is perfect for those with limited experience looking to expand their proficiency.

Syllabus

Introduction

Interface

  • Provides a brief description of the user interface for Microsoft Excel

Worksheets

  • Manage elements of worksheets

Data Entry

  • Examines and describes multiple means of entering data

Rows & Columns

  • Insert, delete, hide, and group rows and columns

Formulas

Autofill

  • Explores Excel's amazing ability to predict and extrapolate patterns

Calculations

  • Perform mathematical expressions and review the Order of Operations rule

AutoSum Functions

  • Review the five key functions: Sum, Average, Max, Min, and Count Numbers

Absolute Reference

  • Changing a cell reference into a constant, which is necessary for certain calculations

True or False

  • Tests to see whether criteria is true/false

Text Functions

  • Introduces functions used to modify text in Excel

Multi-Input Functions

  • More advanced functions that require more than one input

Formatting

Formatting

  • The addition of effects to an Excel document to provide visual instruction

Cell Styles

  • Apply consistent formatting to specific types of cells or values

Conditional Formatting

  • Apply a predetermined format based on specified rules

Charts & Tables

Tables

  • Explore the special functionality created when data is converted to a Table

Column Chart

  • Create a Column chart to visually examine data

Line Chart

  • Create a Line chart and Spark lines to visually examine data

Pie Chart

  • Create a Pie chart to visually examine data

Workbook Management

Freeze Panes

  • Enable a portion of the screen to stay visible at all times

Printing

  • Rules and strategies to make printing easy

Windows

  • Change how your worksheet displays data

Templates

  • Use prefabricated templates to build a spreadsheet

Excel Tricks

  • Fundamental keyboard shortcuts and other Excel tricks

End of Class Projects

Projects

  • End of class projects to review key concepts from the class

Taught by

Brian McClain, Mourad Kattan, Adebayo Norman, and Garfield Stinvil

Reviews

4.8 rating at Noble Desktop based on 552 ratings

Start your review of Excel Level I: Fundamentals

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.