Microsoft Office 2013: Excel
4.0 (1 rating)
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.
11 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Office 2013: Excel to your Wishlist.

Add to Wishlist

Microsoft Office 2013: Excel

Know all about Excel
4.0 (1 rating)
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.
11 students enrolled
Last updated 1/2017
English
Curiosity Sale
Current price: $10 Original price: $200 Discount: 95% off
30-Day Money-Back Guarantee
Includes:
  • 7 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • This course will prepare you to pass the exam Microsoft Office 2013 Excel
  • The MOS exam have been designed to test a candidate's ability to demonstrate the correct application of the principal features of Excel 2013.
View Curriculum
Requirements
  • Fundamental understanding of the Excel environment
Description

From Microsoft: Microsoft Excel 2013 is designed to help you get professional-looking results with features that let you get away from walls of numbers and draw more persuasive pictures of your data, guiding you to better, more informed decisions. It includes templates for the set-up and design, Quick Analysis tool which converts your data into a chart or table in two steps or less, Flash Fill is data assistant that finishes your work, chart recommendations, slicers to filter table data, and several new functions in the math and trigonometry, statistical, engineering, date and time, lookup and reference, logical, and text function categories. 

Microsoft Office 2013  is a version of Microsoft Office, a productivity suite for Microsoft Windows.

Our MOS Excel 2013 training course provides students with the knowledge and skills that are needed to use the advanced software features, and integrate the Office programs with other software. When you pass the Excel 2013 Exam 77-420, you achieve Microsoft Certified Application Specialist (MOS) status in Excel 2013.

The Microsoft Certified Application Specialist Certification, (MOS) recognizes business professionals who have demonstrated expertise in Microsoft Office 2013.

Who is the target audience?
  • IT professionals
  • Anyone and everyone
Students Who Viewed This Course Also Viewed
Curriculum For This Course
114 Lectures
07:02:23
+
Microsoft Excel 2013 - Course Introduction
1 Lecture 01:11
+
Section 1-1 Create Worksheets and Workbooks
7 Lectures 25:55
Create Worksheets and Workbooks
00:23

Creating New Blank Workbooks
05:43


Importing Files
05:09

Opening Non-Native Files Directly in Excel
03:06

Adding Worksheets to Existing Workbooks
01:59

Copying and Moving Worksheets
03:37
+
Section 1-2 - Navigate Through Worksheets and Workbooks
5 Lectures 16:09
Navigate Through Worksheets and Workbooks
00:19

Searching for Data Within a Workbook
03:41

Using Go To and Name Box
03:50


Inserting Hyperlinks
06:03
+
Section 1-3 - Format Worksheets and Workbooks
9 Lectures 35:07
Format Worksheets and Workbooks
00:27

Changing Worksheet Tab Color
03:21

Modifying Page Setup and Inserting Watermarks
11:26


Changing Workbook Themes
04:08

Adjusting Row Height and Column Width Part1
02:01

Adjusting Row Height and Column Width Part2
02:09

Inserting Headers and Footers
03:58

Setting Data Validation
04:25
+
Section 1-4 - Customize Options and Views for Worksheets and Workbooks
11 Lectures 44:43
Customize Options and Views for Worksheets and Workbooks
00:40

Hiding Columns - Rows - Worksheets
03:18


Managing Macro Security
05:26

Changing Workbook Views
03:28

Recording Simple Macros
06:03

Adding Values to Workbook Properties
03:15

Using Zoom
03:12

Displaying Formulas
02:18

Freezing Panes
05:22

+
Section 1-5 - Configure Worksheets and Workbooks to Print or Save
8 Lectures 27:32
Configure Worksheets and Workbooks to Print or Save
00:31

Setting a Print Area
02:41

Saving Workbooks in Alternate File Formats
04:24

Printing Individual Worksheets and Scaling
05:46

Repeating Headers and Footers
03:46

Maintaining Backward Compatibility
03:48


Saving Files to Remote Locations
04:46
+
Section 2-1 - Insert Data in Cells and Ranges
6 Lectures 33:38
Insert Data in Cells and Ranges
00:21

Appending Data to Worksheets
03:04


Copying and Pasting Data
08:27

Using AutoFill Tool
08:39

Inserting and Deleting Cells
08:15
+
Section 2-2 - Format Cells and Ranges
9 Lectures 41:51
Format Cells and Ranges
00:26

Merging Cells
06:00


Modifying Cell Alignment & Indentation plus Changing Font and Font Styles Part2
02:34

Using Format Painter
04:19

Wrapping Text Within Cells
04:30

Applying Number Formatting
04:36

Applying Highlighting and Cell Styles
06:20

+
Section 2-3 - Order and Group Cells and Ranges
6 Lectures 30:48
Order and Group Cells and Ranges
00:20

Applying Conditional Formatting
10:34

Transposing Columns and Rows
03:07

Inserting Sparklines
04:32


Creating Outline - Collapsing Groups of Data in Outlines and Inserting Subtotals
08:13
+
Section 3-1 - Create a Table
4 Lectures 13:12
Create a Table
00:14

Creating a Table and Moving Between Tables and Ranges
04:58

Adding and Removing Cells Within Tables
04:40

Defining Titles
03:20
9 More Sections
About the Instructor
iCollege Certifications
4.1 Average rating
1,713 Reviews
11,519 Students
100 Courses
Certification Leader

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

Utilizing state of the art technologies, highly experienced consultants and innovative methodologies, we provide, cutting-edge education products, services and solutions for individuals, corporate organizations, governmental institutions and education providers.

Our collective knowledge and experience in education and training sets the standard for service delivery in learning solutions.

Stone River eLearning
4.2 Average rating
16,730 Reviews
276,166 Students
201 Courses
270,000+ Happy Udemy Students

At Stone River eLearning, technology is all we teach. If you're interested in programming, development or design - we have it covered. 

Check out our huge catalog of courses and join the over 450,000 students currently taking Stone River eLearning courses. We currently offer 100+ different technology training courses on our Stone River eLearning website and are adding new courses on hot and trending topics every month. A subscription option is available for those with a real passion for learning.