Microsoft Excel 2013 – Microsoft Office Specialist (MOS)
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
4 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2013 – Microsoft Office Specialist (MOS) to your Wishlist.

Add to Wishlist

Microsoft Excel 2013 – Microsoft Office Specialist (MOS)

Learn the features and functions in Microsoft Excel 2013 to help you pass the Microsoft office specialist Excel 2013
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
4 students enrolled
Created by Sean Carthy
Last updated 3/2016
English
Price: $50
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • 27 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
What Will I Learn?
  • Learn the features and functions in Microsoft Excel 2013 to help you pass the Microsoft office specialist (MOS) Excel 2013 exam 77-420l
View Curriculum
Requirements
  • Students need to know basic Excel before attempting the course
Description

The Ability to Master Excel

By the completion of this computer based Excel training video for Microsoft Excel 2013, you will be comfortable with many of the advanced features and functions that this powerful spreadsheet software from Microsoft has to offer.

With the ability to handle advanced tasks in Excel, you’ll be able to get more power out of your worksheets and be able to dramatically shorten your task times and increase your efficiency in the process.

Who is the target audience?
  • The course is suitable to students that want to pass the Microsoft office specialist (MOS) excel 2013 exam 77-420
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 84 Lectures Collapse All 84 Lectures 04:22:34
+
Lesson 1 – Introduction to Microsoft Excel 2013
9 Lectures 19:07

Introduction to the Microsoft Excel 2013.

Preview 02:40

Introduction to the basic functionality of Excel

Preview 03:19




New Workbook in Excel 2013
01:41

Enter Numerical data in Excel 2013
01:50

Compatibility checker in Excel 2013
02:43

Select ranges in Excel 2013
01:07
+
Lesson 2 - Modifying a worksheet in Excel 2013
10 Lectures 31:18
Edit Content
06:55

Copy and Paste
02:46

Paste Special
06:28

Copy and Move
02:24

Add and delete rows
03:34

Modify Column width
02:33

Autofill
02:28

Rename Sheets
01:42

Hide and unhide worksheets
01:29

Add colour to worksheets
00:59
+
Lesson 3 - Formula's in Excel 2013
10 Lectures 51:39
Adding and deleting worksheets
02:55

Adding two cells together
06:28

Reference cells in different worksheets
04:16

Subtotal
10:07

If condition
03:06

Conditional summary functions
08:44

Concatenate
06:31

Absolute referencing
03:41

Display formula's
02:09

Change font size and make bold
03:42
+
Lesson 4 - Formatting Excel 2013 Workbooks
9 Lectures 27:22
Date and number formatting
05:14

Merge and centre, alignment
05:16

Change font size and make bold
03:42

Apply patterns and background colours
01:50

Change the theme in a workbook
01:43

Create your own theme
02:06

Cell style
03:11

Conditional formatting
02:00

Conditional formatting using rules manager
02:20
+
Lesson 5 - Viewing and Printing Excel 2013 Workbooks
10 Lectures 39:21
Multiple Windows
03:00

Splitting Windows
02:59

Freeze panes
02:22

Zoom
01:18

Page view and Print Features
04:36

Inserting page breaks
05:25

Page Formatting
08:07

Headers and Footers
06:01

Column and Row titles, print area
04:21

Print multiple tabs
01:12
+
Lesson 6 - Working with Charts in Excel 2013
15 Lectures 42:09
Create Clustered Charts
02:04

Move and Resize Charts
01:46

Change chart type
01:10

Create a pie chart and explode it
01:46

Change chart layout and move chart
06:26

Add new data to a chart
02:51

Sparklines
02:56

Printing a chart
01:55

Quick analysis
04:14

Shapes
03:36

Wordart
01:56

Inserting a picture
02:54

Image editing
02:47

Adding a watermark
01:43

Smartart
04:05
+
Lesson 7 - Organising data in Excel 2013
9 Lectures 25:50
Create name ranges
00:40

Update name ranges
02:47

Create a table and a total
05:43

Insert rows and columns into a table
03:27

Change and remove table styles
01:52

Sort a table data
02:02

Autofilters
02:07

Remove duplicate data
02:28

Automatic subtotals
04:44
+
Lesson 8 - Macros, Importing and Exporting data in Excel 2013
12 Lectures 25:48
Overview
00:39

Find and replace
02:13

Customise quick access toolbar and ribbon
03:54

Find and replace
02:13

Hyperlink
02:31

Comments
01:49

Import a text file
01:22

Open a csv file
01:40

Export a worksheet data
01:28

Document properties
02:00

Upload documents to onedrive account
02:28

Macros
03:31
About the Instructor
Sean Carthy
0.0 Average rating
0 Reviews
4 Students
1 Course
Computer Trainer

I have twenty years’ experience of delivering training courses to a wide range of students. Excellent presentation skills and delivery of training courses. I have delivered Microsoft Office course for the last ten years. The course I deliver provide detailed instructions to help you understand how to use Microsoft Office in highly productive way. I enjoy teaching so I hope you enjoy learning from me.