On the first day of this comprehensive Microsoft Excel training course, students will learn to use Excel to create, modify and format Excel worksheets, perform calculations, and print and Excel workbooks. On the second day, they will learn to will apply visual elements and advanced formulas to a worksheet to display data in various formats. And on the third day, they will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.
Create basic, professional worksheets using Microsoft Excel.
Perform calculations in an Excel worksheet.
Use handy built-in templates.
Modify an Excel worksheet.
Format your data to create clear, presentable worksheets.
Manage Excel workbooks.
Save time with shortcuts.
Print the content of an Excel worksheet.
Learn how to use handy features new in Excel.
Use Excel database functions and logic functions to work with information in large datasets.
Leverage Excel's statistical functions to analyze data.
Visualize your data using charts to show trends, create comparisons, and demonstrate other meaningful insights.
Convert, sort, filter, and manage lists to keep your data organized.
Insert and modify illustrations, logos, or shapes to create professional reports.
Manage and analyze data using tables.
Emphasize interesting and unusual data with conditional formatting
Save time by using styles to apply formatting instantly.
Create pivot tables and charts to quickly summarize large amounts of data.
Learn to trace precedents and dependents to learn about the data connected to your active cell.
Convert blocks of text into columns.
Leverage data validation tools to control the data entered into your worksheet.
Consolidate data from various sources into one master worksheet for easy summary and review.
Protect your worksheets and workbooks for safe and secure collaboration.
Create, use, edit, and manage macros to automate repetitive tasks.
Use internationalization and accessibility tools to prepare your worksheets for any audience.
Work with other applications by importing and exporting data, charts, and files.
Microsoft Certified Partner
Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). Our curriculum has been tested and approved by ProCert Labs, the official tester of Microsoft courseware, and has been found to meet the highest industry standards of instructional quality.
Creating a Microsoft Excel Workbook
Starting Microsoft Excel
Creating a Workbook
Saving a Workbook
The Status Bar
Adding and Deleting Worksheets
Copying and Moving Worksheets
Changing the Order of Worksheets
Closing a Workbook
Exercise: Creating a Microsoft Excel Workbook
Exercise: Exploring the Ribbon
The Backstage View (The File Menu)
Introduction to the Backstage View
Opening a Workbook
Exercise: Open a Workbook
New Workbooks and Excel Templates
Exercise: Select, Open and Save a Template Agenda
Exercise: Print a Worksheet
Adding Your Name to Microsoft Excel
Adding a Theme to Microsoft Excel
The Quick Access Toolbar
Adding Common Commands
Adding Additional Commands with the Customize Dialog Box
Adding Ribbon Commands or Groups
Exercise: Customize the Quick Access Toolbar
Entering Data in Microsoft Excel Worksheets
Using Flash Fill
Expand Data across Columns
Adding and Deleting Cells
Adding a Hyperlink
Add WordArt to a Worksheet
Exercise: Entering Text and Using AutoComplete
Entering Numbers and Dates
Using the Fill Handle
Exercise: Entering Numbers and Dates
Formatting Microsoft Excel Worksheets
Selecting Ranges of Cells
Adding Color to Worksheet Tabs
Adding Themes to Workbooks
Exercise: Customize a Workbook Using Tab Colors and Themes
Adding a Watermark
The Font Group
Exercise: Working with Font Group Commands
The Alignment Group
Exercise: Working with Alignment Group Commands
The Number Group
Exercise: Working with Number Group Commands
Using Formulas in Microsoft Excel
Math Operators and the Order of Operations
AutoSum (and Other Common Auto-Formulas)
Copying Formulas and Functions
Relative, Absolute, and Mixed Cell References
Exercise: Working with Formulas
Working with Rows and Columns
Inserting Rows and Columns
Deleting Rows and Columns
Transposing Rows and Columns
Setting Row Height and Column Width
Hiding and Unhiding Rows and Columns
Splitting the Worksheet Window
Exercise: Working with Rows and Columns
Find and Replace
Exercise: Using Find and Replace
Using the Clipboard
Exercise: Using the Clipboard
Exercise: Using Format Painter
Working with Comments
Finalizing Microsoft Excel Worksheets
Setting Page Orientation
Setting the Print Area
Print Scaling (Fit Sheet on One Page)
Printing Headings on Each Page/Repeating Headers and Footers
Headers and Footers
Exercise: Preparing to Print
Using Named Ranges in Formulas
Naming a Single Cell
Naming a Range of Cells
Naming Multiple Single Cells Quickly
Exercise: Using Named Ranges in Formulas
Using Formulas That Span Multiple Worksheets
Exercise: Entering a Formula Using Data in Multiple Worksheets
Using the IF Function
Using AND/OR Functions
Using the SUMIF, AVERAGEIF, and COUNTIF Functions
Exercise: Using the IF Function
Using the PMT Function
Exercise: Using the PMT Function
Using the LOOKUP Function
Using the VLOOKUP Function
Exercise: Using the VLOOKUP Function
Using the HLOOKUP Function
Using the CONCAT Function
Exercise: Using the CONCAT Function
Using the TRANSPOSE Function
Using the PROPER, UPPER, and LOWER Functions
The UPPER Function
The LOWER function
The TRIM Function
Exercise: Using the PROPER Function
Using the LEFT, RIGHT, and MID Functions
The MID Function
Exercise: Using the LEFT and RIGHT Functions
Using Date Functions
Using the NOW and TODAY Functions
Exercise: Using the YEAR, MONTH, and DAY Functions
Utilize the Watch Window
Enable Iterative Calculations
Use the Scenario Manager
Use Financial Functions
Working with Lists
Converting a List to a Table
Exercise: Converting a List to a Table
Removing Duplicates from a List
Exercise: Removing Duplicates from a List
Sorting Data in a List
Exercise: Sorting Data in a List
Filtering Data in a List
Exercise: Filtering Data in a List
Adding Subtotals to a List
Grouping and Ungrouping Data in a List
Exercise: Adding Subtotals to a List
Working with Illustrations
Working with Clip Art
Exercise 15:Working with Clip Art
Exercise: Adding Shapes
Working with Icons
Working with SmartArt
Using Office Ink
Visualizing Your Data
Using the Chart Recommendation Feature
Exercise: Inserting Charts
Changing the Layout of a Chart
Using Chart Tools
Changing the Style of a Chart
Adding a Shape to a Chart
Adding a Trendline to a Chart
Adding a Secondary Axis to a Chart
Adding Additional Data Series to a Chart
Switch between Rows and Columns in a Chart
Positioning a Chart
Modifying Chart and Graph Parameters
Using the Quick Analysis Tool
Watching Animation in a Chart
Showing, Hiding, or Changing the Location of the Legend in a Chart
Showing or Hiding the Title of a Chart
Changing the Title of a Chart
Showing, Hiding, or Changing the Location of Data Labels in a Chart..211
Changing the Style of Pieces of a Chart
Exercise: Editing Charts
Add and Format Objects
Insert a Text Box
Create a Custom Chart Template
Working with Tables
Format Data as a Table
Move between Tables and Ranges
Add and Remove Cells within a Table
Change Table Styles
Band Rows and Columns
Total Row Option
Remove Styles from Tables
Exercise: Creating and Modifying a Table in Excel
Applying Conditional Formatting
Exercise: Using Conditional Formatting
Working with Styles
Applying Styles to Tables
Applying Styles to Cells
Exercise 21:Working with Styles
Creating and Modifying Templates
Modify a Custom Template
Using Pivot Tables
Creating Pivot Tables
Preparing Your Data
Inserting a Pivot Table
Creating a PivotTable Timeline
More PivotTable Functionality
Multi-Select Option in Slicers
Working with Pivot Tables
Inserting Pivot Charts
More Pivot Table Functionality
Creating a Standalone PivotChart
Exercise: Working with Pivot Tables
Exercise: Tracing Precedents
Exercise: Tracing Dependents
Converting Text to Columns
Exercise: Converting Text to Columns
Linking to External Data
Controlling Calculation Options
Exercise: Using Data Validation
Exercise: Consolidating Data
Exercise: Using Goal Seek
Working with Others
Protecting Worksheets and Workbooks
Password Protecting a Workbook
Removing Workbook Metadata
Restoring Previous Versions
Exercise: Password Protecting a Workbook
Password Protecting a Worksheet
Exercise: Password Protecting a Worksheet
Password Protecting Ranges in a Worksheet
Exercise: Password Protecting Ranges in a Worksheet
Marking a Workbook as Final
Recording and Using Macros
Copy a Macro from Workbook to Workbook
Exercise: Recording a Macro
Adding Macros to the Quick Access Toolbar
Managing Macro Security
Exercise: Adding a Macro to the Quick Access Toolbar
Random Useful Items
Exercise: Inserting and Customizing Sparklines
Using Microsoft Translator
Preparing a Workbook for Internationalization and Accessibility
Display Data in Multiple International Formats
Modify Worksheets for Use with Accessibility Tools
Accessibility: Using Sounds
Use International Symbols
Manage Multiple Options for +Body and +Heading Fonts
Importing and Exporting Files
Importing Delimited Text Files
Exercise: Importing Text Files
Exporting Worksheet Data to Microsoft Word
Exercise: Copying Data from Excel to Word
Exporting Excel Charts to Microsoft Word
Exercise: Copying Charts from Excel to Word
Each student will receive a comprehensive set of materials, including course notes and all the class examples.
Experience in the following is required for this Microsoft Excel class:
Familiarity with using a personal computer, mouse, and keyboard.
Comfortable in the Windows environment.
Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.