Microsoft Excel 2013 For Beginners
Course Introduction
Microsoft Excel 2013 For Beginners
0%
Completed
Introduction
Introduction
Course Introduction
Video - 00:4:58 mins
What Is Excel?
Video - 00:3:48 mins
Excel Terminology
Video - 00:13:43 mins
Understanding Excel Interface
Video - 00:8:59 mins
Difference Between Workbook and Worksheet
Video - 00:6:45 mins
Diving Deeper Into Excel
In this section you will learn how to work within the Excel environment hands-on
Introduction to Workbook and Worksheet Creation
Video - 00:13:36 mins
Working With Data & Importing Templates
Video - 00:12:07 mins
Moving & Copying Worksheets
Video - 00:11:59 mins
Working With Excel Ranges & Navigation
Video - 00:11:15 mins
Formatting Cells and Ranges
Video - 00:18:20 mins
Conditional Formatting & Ordering Cells
Video - 00:12:38 mins
Working with Print-Save-Views
Video - 00:14:51 mins
Excel Functions
In this section you will learn how to work with Excel Functions & Formulas
Understanding Order Of Operations
Video - 00:8:29 mins
Working With Auto-fill and Functions
Video - 00:15:35 mins
Understanding Date-Number Formatting
Video - 00:8:57 mins
Absolute Referencing
Video - 00:13:22 mins
Conditional Logic
Video - 00:8:54 mins
Modifying Text
Video - 00:14:46 mins
Perform Edit Related Functions
In this section you will learn how to perform editing and working with various tools in Excel
Editing Ranges
Video - 00:10:04 mins
Additional Tools
Video - 00:8:57 mins
Find and Replace
Video - 00:9:30 mins
Productive Tools In Excel
In this section you will work hand-on with several Excel tools that boost your productivity
Working with Columns and Rows
Video - 00:9:29 mins
Understanding Numeric Format
Video - 00:14:19 mins
Text Formatting and Borders
Video - 00:7:51 mins
Format Painter Tool
Video - 00:5:08 mins
Themes and Cell Styles
Video - 00:6:37 mins
Zoom & Split Functionality
In this section you will learn the two most productive tools
Zoom Functionality and Split
Video - 00:5:25 mins
Freeze Panes
Video - 00:10:13 mins
Adding Comments
Video - 00:12:15 mins
Understanding Page Breaks & Margins
In this section you will learn how to navigate through the concept of adding page breaks and setting margins
Page Break and Print Preview
Video - 00:7:15 mins
Margin Headers
Video - 00:11:26 mins
Worksheet Options
Video - 00:12:58 mins
Charts Graphs and Options
Video - 00:15:48 mins
Inserting and Formatting Objects
Video - 00:9:53 mins
Projects
In this section you will have a look a look at 3 different projects hands-on
Project A
Video - 00:19:24 mins
Project B
Video - 00:13:58 mins
Project C
Video - 00:18:24 mins
Resources
Resources
Resource
Reading
More
Announcements
Course Info
Finish Course Early?
You have not completed all required lessons and assessments.
Your Progress
0%
Go Back to Course
Complete Anyway