Course Description
Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks.
What am I going to get from this course?
Learn to enter data, create worksheets, handle large worksheets etc.
Prerequisites and Target Audience
What will students need to know or do before starting this course?
Who should take this course? Who should not?
Beginners & anyone who wants to learn Excel
Curriculum
Module 2: Getting Started with Excel
Lecture 4
Navigating the Excel User Interface
Lecture 5
Using the Excel Ribbon
Lecture 6
Understanding Excel Worksheet Components
Lecture 7
Using the Backstage View
Module 3: Creating Workbooks and Using Templates
Lecture 8
Creating a New Workbook
Lecture 9
Creating Workbooks Using Templates
Lecture 10
Saving an Excel Workbook
Lecture 11
Using the Accessibility Checker
Lecture 12
Navigating a Worksheet by Mouse or Keyboard
Lecture 13
Understanding Excel Data Types
Lecture 14
Using the Inking Tools
Lecture 15
Working with Cell and Range Addressing
Lecture 16
Using Various Data Selection Techniques
Lecture 17
Working with Common Excel Commands
Lecture 18
Using the AutoFill Handle
Lecture 19
Using Flash Fill
Module 5: Excel Formula Basics
Lecture 20
What are Formulas and Functions?
Lecture 21
Understanding the Components of a Formula
Lecture 22
Calculation Hierarchy and the Order of Operations
Lecture 23
Creating Basic Formulas
Lecture 24
Working with Basic Functions and AutoSum
Lecture 25
Using Cell References
Lecture 26
Using the Quick Analysis Tools
Module 6: Adjusting a Worksheet
Lecture 27
Modifying Columns and Rows
Lecture 28
Hiding and Unhiding Columns and Rows
Module 7: Formatting and Aligning a Worksheet
Lecture 29
Formatting & Aligning Data
Lecture 31
Wrapping Text and Adjusting Orientation
Lecture 32
Formatting Numbers
Lecture 33
Using Borders and Shading
Lecture 34
Using the Format Painter
Lecture 35
Removing Formatting Quickly
Module 8: Using Cell Styles and Themes
Lecture 36
Using Cell Styles
Lecture 37
Applying Themes
Module 9: Inserting Objects and Graphics
Lecture 38
Inserting and Formatting Images
Lecture 39
Inserting and Formatting Shapes
Lecture 40
Inserting and Formatting SmartArt
Lecture 41
Working with Icons
Lecture 42
Working with 3-D Models
Lecture 43
Inserting Screenshots
Lecture 44
Inserting Hyperlinks
Lecture 45
Inserting Symbols and Equations
Lecture 46
Inserting WordArt and Text Boxes
Lecture 47
Inserting Other Excel Objects
Lecture 48
Arranging Objects
Module 10: Proofing a Workbook
Lecture 49
Using Find and Replace
Lecture 50
Using Go To and Go To Special
Lecture 51
Using the Spell Checker
Lecture 52
Using the Thesaurus and Translation Features
Module 11: Printing an Excel File
Lecture 53
Printing and Previewing Files
Lecture 54
Creating Custom Margins and Scaling
Lecture 55
Adding Headers and Footers
Lecture 56
Exporting to PDF and XPS
Module 12: Managing Worksheets
Lecture 57
Renaming and Coloring Worksheet Tabs
Lecture 58
Adding, Deleting and Navigating Worksheets
Module 13: Navigating and Viewing Excel Files
Lecture 59
Viewing Workbooks
Lecture 60
Using Zoom Tools
Lecture 61
Configuring Sheet Options
Lecture 62
Configuring Sheet Options
Lecture 63
Using the Freeze Panes and Split Commands
Lecture 64
Working with Window Commands
Lecture 65
Adjusting Workbook Properties
