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.
3 students enrolled
$50
Take This Course
  • Lectures 84
  • Length 4.5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2015 English

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.

What are the requirements?

  • Students need to know basic Excel before attempting the course

What am I going to get from this course?

  • Learn the features and functions in Microsoft Excel 2013 to help you pass the Microsoft office specialist (MOS) Excel 2013 exam 77-420l

What is the target audience?

  • The course is suitable to students that want to pass the Microsoft office specialist (MOS) excel 2013 exam 77-420

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

02:40

Introduction to the Microsoft Excel 2013.

03:19

Introduction to the basic functionality of Excel

Enter Text into Excel
Preview
01:55
Working with dates in Excel
Preview
01:50
Save a workbook in Excel 2013
Preview
02:02
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
Section 1: Lesson 2 - Modifying a worksheet in Excel 2013
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
Section 2: Lesson 3 - Formula's in Excel 2013
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
Section 3: Lesson 4 - Formatting Excel 2013 Workbooks
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
Section 4: Lesson 5 - Viewing and Printing Excel 2013 Workbooks
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
Section 5: Lesson 6 - Working with Charts in Excel 2013
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
Section 6: Lesson 7 - Organising data in Excel 2013
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
Section 7: Lesson 8 - Macros, Importing and Exporting data in Excel 2013
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Sean Carthy, 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.

Ready to start learning?
Take This Course