EXCEL 2016 FOR BEGINNERS
Take This Course $995
by iCoursetraining
By completing our Excel 2016 course - you will be fully prepared to pass the MicroSoft Office Specialist Exam in Excel. This course teaches the basic functions and features of Excel and includes the new additional project requirements in the newest exam release.
MODULE 1: INTRODUCTION AND AGENDA
-
Video Lesson 1:
Course Introduction
MODULE 2: GETTING STARTED
-
Video Lesson 1:
What is Excel?
-
Video Lesson 2:
Using the Ribbon
-
Video Lesson 3:
Spreadsheet Terminology
-
Video Lesson 4:
Overview of the Excel Interface
-
Video Lesson 5:
Workbook and Worksheet Views and Zoom
MODULE 3: BASIC WORKSHEET SKILLS
-
Video Lesson 1:
Creating Worksheets and Workbooks
-
Video Lesson 2:
Using Templates and Importing Files
-
Video Lesson 3:
Copying and Moving Worksheets
-
Video Lesson 4:
Selecting a Range, Columns, Rows and Non-Contiguous Cells
-
Video Lesson 5:
Formatting Cells and Ranges
-
Video Lesson 6:
Order and Group Cells and Ranges and Using Autofill
-
Video Lesson 7:
Customizing Options Working with Print and Save Commands
MODULE 4: WORKING WITH FORMULAS
-
Video Lesson 1:
Order of Operations and Using Formulas
-
Video Lesson 2:
Common Functions: AVERAGE, MAX, MIN, COUNT
-
Video Lesson 3:
Working with Date Arithmetic and Currency Formatting
-
Video Lesson 4:
Relative vs. Absolute Cell Addressing
-
Video Lesson 5:
Conditional Logic in Formulas: SUMIF, AVERAGEIF, and COUNTIF
-
Video Lesson 7:
Format and Modify Text Using Formulas: RIGHT, LEFT, MID, TRIM
MODULE 5: EDITING WORKBOOKS
MODULE 6: FORMATTING WORKSHEETS
-
Video Lesson 1:
Inserting, Deleting, and Adjusting Columns and Rows
-
Video Lesson 2:
Changing Numeric Formats Using the Format Cells Dialogue Box
-
Video Lesson 3:
Changing Text Format and Aligning Data Using Borders and Shading
-
Video Lesson 4:
Using the Format Painter
-
Video Lesson 5:
Working with Themes and Using Cell Styles
MODULE 7: MULTIPLE WORKBOOKS
MODULE 8: PROTECTING WORKBOOKS
MODULE 9: PRINTING AND PAGE SETUP
MODULE 10: CHARTS AND OBJECTS
-
Video Lesson 1:
Creating and Formatting Charts and Graphs
-
Video Lesson 2:
Inserting and Formatting Objects
MODULE 11: PROJECTS
-
Video Lesson 1:
Project A - Consolidating Several Worksheets into One
-
Video Lesson 2:
Project B - Creating Tables and Charts
-
Video Lesson 3:
Project C - Working with Formulas
View All Users Who Viewed This Course Also Viewed
-
-
Excel for Beginners
$995 -
EXCEL 2016 ADVANCED
$995
iCoursetraining
iCoursetraining specializes in technology training courses by providing online classes for students of all skill levels and experience with busy schedules. Our online classes allow students to take courses at their own pace and schedule with step by...More
Other Courses from iCoursetraining
-
$995Excel for Beginners
-
$995Excel Advanced
