Excel 2013: Excel 2013 Beginner - Intermediate
4.5 (12 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.
590 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.5 (12 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.
590 students enrolled
Last updated 8/2014
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 7.5 hours on-demand video
  • 15 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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
Requirements
  • Computer
  • Microsoft Excel program
  • Willing to learn
Description

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
Expand All 92 Lectures Collapse All 92 Lectures 07:15:56
+
Introduction
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
00:02
+
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
06:23

How to add and remove worksheets, and How to rename, copy, and move worksheets
09:34

How to navigate an excel woorkbook

How to navigate an excel workbook
04:50

Downloadable material

Working files
00:02
+
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
08:56

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
06:31

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
08:28

Go over the feel handle of Microsoft Excel

How to use the fill handle of Microsoft excel
07:33

How to insert and delet cells, colums and rows

How to insert, and delete cells, columns, and rows
05:12

How to change column width and row hight

How to change column widths and row heights
03:00

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
05:15

Downloadable material

Working files
00:02
+
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
05:30

Go over how to display formulas on a worksheet

Displaying Formulas on a Worksheet
04:26

Downloadable material

Working files
00:02
+
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
08:56

How to merge and rap the content of the cells

Merging And Wrapping Cell Contents
06:04

How to use number formats within Excel

Using Number Formats
02:55

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

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

How to apply the date function

Applying a date
06:29

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

Finding And Replacing Formats
04:13

Finding and replacing formats

Clearing Cell Contents Vs Clearing Cell Formatting
04:35

Download the workbooks for this section

Working files
00:02
+
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
06:48

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
05:46

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

Modifying More Than One Worksheet At A Time
02:57

Downloadable material

Working files
00:02
+
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
06:09

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

Paper Size, Orientation, Margins, And Scaling Options
06:08

Go over creating headers and footers

Creating Headers and Footers
06:30

Go over using the page break and the page layout views

Using The Page Break And The Page Layout Views
03:50

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

Printing A Range Of Cells and Running the Spell Checker
05:10

Go over controlling most print settings in one place

Controlling Most Print Settings In One Place
02:54

Downloadable material

Working files
00:02
+
Formulas and functions
8 Lectures 46:30

Go over the sum function

The Sum Function
07:16

Go over copying formulas and functions

Copying Formulas And Functions
05:08

Go over useful count functions

Useful Count Functions
03:48

what absolute referencing is

Absolute Referencing Explained
07:05

Go over using formulas across worksheets

Formulas Across Worksheets
07:52

Go over 3D referencing.

3D Referencing
06:29

Go over making use of named cells and ranges

Making Use Of Named Cells And Ranges
08:50

Downloadable material

Working files
00:02
+
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
05:30

Downloadable material

Working files
00:02
+
Protection and security
5 Lectures 13:27

Go over activating and deactivating worksheet protection

Activating And Deactivating Worksheet Protection
04:21

Go over password protecting the whole workbook

Protecting Part Of A Worksheet To Aid Data Entry
04:02

Go over protecting part of a worksheet to aid data entry

Password Protecting The Whole Workbook
02:12

Go over using the 2013 templates

Ready to use templates
02:50

Downloadable material

Working files
00:02
5 More Sections
About the Instructor
Optimum  Education Center
4.1 Average rating
13 Reviews
619 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.5 Average rating
12 Reviews
590 Students
1 Course
Business, Marketing

EDUCATION

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

WORK EXPERIENCE

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


Accomplishments:

·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.”