Microsoft Excel Course Online September 16, 2024 Introduction

Topics covered in the introductory Microsoft Excel course include the following:

Getting started with Excel

Understand various ways of entering data in Excel. Find out how to use multiple worksheets in Excel, and learn to organize data by creating, moving, copying, and managing Excel worksheets. Find out how to work more efficiently by using repeat actions in Excel to duplicate prior actions quickly. Find out how to save time using Excel Shortcuts as you discover keyboard shortcuts that save time and help you to work more efficiently.

Learning the Excel workspace

Discover how to work more efficiently as you learn the Excel workspace and methods for quickly accessing commonly used functions and commands.  Learn how Excel can automatically complete text and numbers, reducing data entry work while improving accuracy.

• Understanding the Excel interface
• Data entry using Excel
• Moving around a worksheet using keyboard shortcuts
• Editing in the formula bar
• Using AutoFill
• Naming worksheets and saving the workbook
• Using the Quick Access Toolbar

Creating worksheets and working with data in Excel

Understand various ways of entering data in Excel and printing from Excel as you learn how to easily print or convert Excel content to PDF. Find out how to use multiple worksheets in Excel, and learn to organize data by creating, moving, copying, and managing Excel worksheets. Find out how to work more efficiently by using repeat actions in Excel to quickly duplicate prior actions. Find out how to save time using Excel Shortcuts as you discover keyboard shortcuts that save time and help you to work more efficiently.

• Creating a worksheet
• Selecting cells, ranges, collections, rows, and columns
• Inserting/deleting rows and columns
• Inserting, deleting, hiding, copying, and moving worksheets

Formatting in Excel

Learn how to apply formatting to Excel sheets and content. Understand how to apply formatting and color to text and cells and set the alignment of text and numbers within cells vertically and horizontally. Learn to visually distinguish specific text and numbers by applying formatting. Learn how to use the Format Painter in Excel to duplicate formatting from any cell and apply it to others. Applying Conditional Formatting: Discover how to apply formatting depending upon rules relating to content.

• Formatting text, dates, and numbers
• Changing column width and row height
• Editing cell alignment
• Using cell styles
• Applying borders and using shading
• Using the Format Painter in Excel
• Applying conditional formatting
• Applying themes
• Using text functions
• Creating and using templates
• Conditional formatting

Creating charts and graphs in Excel

Learn to create line charts and sparklines to represent data visually. Find out about various chart types, including creating Column Charts using Excel as you learn to create column charts for data visualization. Discover how to create pie charts, bar charts, and line graphs for data visualization.

• Understanding chart types
• Creating charts in Excel
• Customizing charts
• Printing a chart from a chart sheet or a sheet
• Using Sparklines

Using calculations, formulas and functions in Excel 

Discover how to use Excel for calculations including sum, average, and counts as well as how to calculate and tabulate data easily with built-in formulas. Learn to create Excel calculations, formulas, and functions, including using Excel formulas to perform mathematical expressions. Use True / False in Excel to check for matching data. Find out how to use Excel Functions, including AutoSum and text functions that can modify text based on input values. Also, learn about multi-Input Functions, which require multiple inputs and Constant Cell References that can be used for calculations.

• Creating formulas
• Using the order of operations in formulas
• Using functions in Excel, including SUM, AVERAGE, MAX, MIN, COUNT and IF
• Understanding cell references
• Using formula auditing to edit formulas and functions
• Printing your spreadsheet
• Protecting your workbook 

Excel efficiency tips

Find out how to use functions for formatting, standardizing and correcting text, including removing extra spaces and changing case to standardize input to lowercase, uppercase, or title case. Learn to create references to cells, allowing you to keep formulas accurate even as cell content changes and making it possible to copy formulas to other cells. Discover how to lock the values in specific cells so they can be consistently referenced or used in formulas. Learn to work efficiently having Excel automate your work.

• Text Functions
• Cell referencing
• Lock values
• Excel efficiency tips