Excel 2013: Excel 2013 Beginner - Intermediate
4.6 (14 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.
596 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2013: Excel 2013 Beginner - Intermediate to your Wishlist.

Add to Wishlist

Excel 2013: Excel 2013 Beginner - Intermediate

Excel: Intermediate Excel 2013 Features. Gain Knowledge And Learn To Use Excel With This Intermediate Training.
4.6 (14 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.
596 students enrolled
Last updated 8/2014
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 7.5 hours on-demand video
  • 15 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn Microsoft Excel 2013
  • Excel Workbooks and Worksheets managment
  • Excel Formulas and functions application
  • Excel Templates creations and usage
  • Excel working files
  • Money back guaranty
  • Life time access
View Curriculum
  • Computer
  • Microsoft Excel program
  • Willing to learn

The course helps to get overall idea about the basics and main features of Excel. It allows getting through the long list of functions and formulas starting with the essentials and advancing step by step. As a result the user reaches the level of an intermediate user.

The first few lessons help the beginners to learn the essentials of Excel, whereas for the more advanced users it allows recalling the initial basis for moving to the further material, which deals with practically most of the commonly used features.

No data entries are required throughout the course, so the user will be able to pick the starting step, which will be more relevant to their initial Excel skill level.

Formatting, functions, formulas and advanced tasks with the worksheets are delivered in various sections for detailed description and peculiarities of their usage.

The course includes 76 classes included in corresponding 15 sections. Each section deals with specific sets of functions and formulas relevant for a specific action. The information is offered in the form of short, but detailed videos. The user can cover the specific section in less than half an hour, which is practical in terms of time-management.

In the further steps of the course the users get introduced with Excel as a database, learn the best practices of data handling and charts. The use of graphical objects and its complex forms are also included in the course.

By the end of the course the user will turn into an Intermediate Excel user, capable of using the software in everyday tasks.

The course comes in money-back guarantee, if the user is not satisfied with the course. The course includes a life-time access to the course so that the user will choose the best timing for the educational process. The course gets finalized with the standard Udemy certificate, which verifies the successful participation and completion of the course.

Who is the target audience?
  • Basic computer skills
  • No experience or prior knowledge of Excel needed
  • If you have an upper intermediate knowledge of Excel this course is not for you
  • The course is for beginners and intermediate level students
Students Who Viewed This Course Also Viewed
Curriculum For This Course
92 Lectures
3 Lectures 21:12

Excel workbook and the navigation bars

Preview 13:44

Workbook and worksheet navigation, basic numbering techniques and the sum function overview

Preview 07:26

Downloadable materials

Working files
Excel workbooks and worksheets
4 Lectures 20:49

How to plugin a formula within the spreed sheet and how to organize data

How to plug in a formula within an excel spreadsheet

How to add and remove worksheets, and How to rename, copy, and move worksheets

How to navigate an excel woorkbook

How to navigate an excel workbook

Downloadable material

Working files
How to enter and edit data in the cell
8 Lectures 44:57

How to enter text , numbers in the sell and how to enter numbers as a text

How to enter text, numbers, and dates in an excel workbook. How to enter numbers

How to edit the content within the cell and how to undo and redue operations

How to edit the contents of a cell, and also how to undo and redo actions

How to cut, copy, paste and how to drag and drop data within the workbook

How to cut, copy, and paste in a workbook, and How how to drag and drop cells

Go over the feel handle of Microsoft Excel

How to use the fill handle of Microsoft excel

How to insert and delet cells, colums and rows

How to insert, and delete cells, columns, and rows

How to change column width and row hight

How to change column widths and row heights

How to hide and unhide colums and rows also how to search for values within the workbook

How to hide and unhide columns and rows and How to search for values in a workbo

Downloadable material

Working files
Basic mathematical operations and functions
5 Lectures 22:36

Go over how to get started with basic math formulas in excel

Preview 04:38

Go over the order of operations with Bodmas and I am also going to introduce you to basic formulas

Preview 08:00

Go over how to copy formulas and functions

Coying and Pasting Formulas and Functions

Go over how to display formulas on a worksheet

Displaying Formulas on a Worksheet

Downloadable material

Working files
Worksheet formatting and editing
8 Lectures 40:00

How to select cells for formatting and how to modify font size and color

Selecting Cells For Formatting and Modifying Typeface Font, Size, And Color

How to merge and rap the content of the cells

Merging And Wrapping Cell Contents

How to use number formats within Excel

Using Number Formats

Cell content alignment and orientation and adding/removing borders from selected cells

Cell Content Alignment, Orientation, Adding And Removing Borders From A Section

How to apply the date function

Applying a date

How to apply a data format to the cell or a range and go over the format painter

Finding And Replacing Formats

Finding and replacing formats

Clearing Cell Contents Vs Clearing Cell Formatting

Download the workbooks for this section

Working files
Managing workbooks and worksheets
4 Lectures 15:33

Go over how to view and scroll multiple worksheets at the same time, and we are also going to go over hiding and un-hiding sheets

Worksheet Navigation And Coloured Worksheet Tabs and Moving Or Copying Worksheet

Go over how to view and scroll multiple worksheets at the same time, and we are also going to go over hiding and un-hiding sheets

Viewing And Scrolling Multiple Workbooks At The Same Time and Hiding And Un-Hidi

Go over how to modify more than one worksheet at a time

Modifying More Than One Worksheet At A Time

Downloadable material

Working files
Setting up the page formatting for printing
7 Lectures 30:43

Learn how to use print titles and print areas when trying to print a large workbook

Using Print Titles And Print Areas

Go over paper size, orientation, margins, and scaling options

Paper Size, Orientation, Margins, And Scaling Options

Go over creating headers and footers

Creating Headers and Footers

Go over using the page break and the page layout views

Using The Page Break And The Page Layout Views

Go over printing a range of cells and running the spell checker

Printing A Range Of Cells and Running the Spell Checker

Go over controlling most print settings in one place

Controlling Most Print Settings In One Place

Downloadable material

Working files
Formulas and functions
8 Lectures 46:30

Go over the sum function

The Sum Function

Go over copying formulas and functions

Copying Formulas And Functions

Go over useful count functions

Useful Count Functions

what absolute referencing is

Absolute Referencing Explained

Go over using formulas across worksheets

Formulas Across Worksheets

Go over 3D referencing.

3D Referencing

Go over making use of named cells and ranges

Making Use Of Named Cells And Ranges

Downloadable material

Working files
More complicated formatting
4 Lectures 18:23

Go over enhancing worksheets by using themes and we will also go over adding, editing, and deleting comments

Preview 08:07

Go over creating your own autofill list

Preview 04:44

Go over converting data to a table for formatting

Enhancing Worksheets Using Themes and Adding, Editing, And Deleting Comments

Downloadable material

Working files
Protection and security
5 Lectures 13:27

Go over activating and deactivating worksheet protection

Activating And Deactivating Worksheet Protection

Go over password protecting the whole workbook

Protecting Part Of A Worksheet To Aid Data Entry

Go over protecting part of a worksheet to aid data entry

Password Protecting The Whole Workbook

Go over using the 2013 templates

Ready to use templates

Downloadable material

Working files
5 More Sections
About the Instructor
Optimum  Education Center
4.8 Average rating
16 Reviews
625 Students
2 Courses
“Optimum” educational center
  • Optimum is a leading educational center specialized in the IT field. We have over 3 years of experience in teaching different subjects. The study groups have been developed and taught based on specific practical syllabuses. Our center has around 850 graduates, who have successfully completed our courses in the physical location of our center.
  • Developing and advancing our programs, currently we are bringing our experience to the global market. We guarantee that you will be delivered the most up to date and practical content provided by our professional instructors.
  • Optimum IT Center is:
  • - High-level educational center specialized in IT (Information Technologies) sphere
  • - Professional training and re-training center for the professionals of the IT sphere
  • - A chaining element between the Job Market of IT sphere and potential employees delivering practical knowledge
  • - A team consisting of experienced professionals in the relevant fields.
Edwin Mirzayans
4.6 Average rating
14 Reviews
596 Students
1 Course
Business, Marketing


University of Maryland College Park, MD College of Arts and Humanities


Margasoft L.L.C. (Marketing Specialist), Yerevan, Armenia

The Bridal Detective L.L.C. (Director of Marketing), Jacksonville, FL

Business White Pages (Sales Agent), Yerevan, Armenia

The Beatles Pub (Marketing), Yerevan, Armenia

USIS Inc. (Marketing Agent), Vienna, Virginia, USA

Senior Life Services (Life Insurance Agent), Jacksonville, Florida, USA

American General Life and Accident (Life Insurance Agent), Jacksonville, FL

Chase Construction Inc.(Project Manager)Bethesda, MD


·Published my short stories in 2004, in a book called “The Unknown Thoughts Inside My Head.”

·Published a fictional book based on true events surrounding the housing market in 2008, called “The Bubble.”

·Published two article’s for Hetq.am entitled “Andre from America: Leaving For Yerevan to Become a ‘National Hero,’ and “Days Of Innocence: The Children of Mary Izmirlyan Orphanage.”