2015
Udemy
Dr. Bette Daoust
3:42
English
The course teaches you all you need to know for part 1 of the Microsoft Office Specialist exam for Excel.
Whether you need the skills for work or for personal use, this course will help you to:
Work effectively with Excel
Populate a worksheet with Data
Modify data entries and use Data Types
Use Basic Formulas
And Use Functions to enhance your work
Not only will you be exposed to the basics of Excel, we will work with you to practice your skills using real-life examples.
Together, we will walk you through the entire basics of Excel and provide you with opportunities to practice your new skills, step-by-step.
1 - Introduction
2 - Understanding Workbooks and Worksheets
3 - Moving Around a Worksheet
4 - Using the Ribbon
5 - Using Shortcut Menus
6 - Customizing Your Quick Access Toolbar
7 - Working with Dialog Boxes
8 - Using Task Panes
9 - The Backstage
10 - Excel s Views
11 - The Excel Help System
14 - Creating Workbooks
15 - Saving Workbooks
16 - Basic Data Entry and Modification
17 - Modifying Data Part 2
18 - Cut Copy and Paste
20 - Backstage View
21 - Printing with the Backstage
22 - Changing the Excel Environment
23 - Accessing and Using Excel Templates
25 - Overview of Formulas
26 - Order of Operations
27 - Building Basic Formulas
28 - Using Cell References in Formulas
29 - Using Cell Ranges in Formulas
31 - Exploring Functions
32 - Displaying Dates and Times with Functions
33 - Summarizing Data with Functions
34 - Using Formulas to Create Subtotals
35 - Formula Error Detection
36 - Displaying and Printing Formulas
Download File Size:373.41 MB