Excel 2013: Excel 2013 Beginner - Intermediate

Excel: Intermediate Excel 2013 Features. Gain Knowledge And Learn To Use Excel With This Intermediate Training.
4.5 (7 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.
583 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 92
  • Length 7.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
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 8/2014 English

Course 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.

What are the requirements?

  • Computer
  • Microsoft Excel program
  • Willing to learn

What am I going to get from this course?

  • 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

What 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

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

Section 1: Introduction
13:44

Excel workbook and the navigation bars

07:26

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

Article

Downloadable materials

Section 2: Excel workbooks and worksheets
06:23

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

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

How to navigate an excel woorkbook

Article

Downloadable material

Section 3: How to enter and edit data in the cell
08:56

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

06:31

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

08:28

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

07:33

Go over the feel handle of Microsoft Excel

05:12

How to insert and delet cells, colums and rows

03:00

How to change column width and row hight

05:15

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

Article

Downloadable material

Section 4: Basic mathematical operations and functions
04:38

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

08:00

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

05:30

Go over how to copy formulas and functions

04:26

Go over how to display formulas on a worksheet

Article

Downloadable material

Section 5: Worksheet formatting and editing
08:56

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

06:04

How to merge and rap the content of the cells

02:55

How to use number formats within Excel

06:46

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

06:29

How to apply the date function

04:13

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

04:35

Finding and replacing formats

Article

Download the workbooks for this section

Section 6: Managing workbooks and worksheets
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

05:46

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

02:57

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

Article

Downloadable material

Section 7: Setting up the page formatting for printing
06:09

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

06:08

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

06:30

Go over creating headers and footers

03:50

Go over using the page break and the page layout views

05:10

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

02:54

Go over controlling most print settings in one place

Article

Downloadable material

Section 8: Formulas and functions
07:16

Go over the sum function

05:08

Go over copying formulas and functions

03:48

Go over useful count functions

07:05

what absolute referencing is

07:52

Go over using formulas across worksheets

06:29

Go over 3D referencing.

08:50

Go over making use of named cells and ranges

Article

Downloadable material

Section 9: More complicated formatting
08:07

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

04:44

Go over creating your own autofill list

05:30

Go over converting data to a table for formatting

Article

Downloadable material

Section 10: Protection and security
04:21

Go over activating and deactivating worksheet protection

04:02

Go over password protecting the whole workbook

02:12

Go over protecting part of a worksheet to aid data entry

02:50

Go over using the 2013 templates

Article

Downloadable material

Section 11: Graphical figures and objects
03:55

Go over obtaining and inserting online images

04:48

Go over using smart art graphics

05:56

Go over inserting shapes and screenshots

05:15

Go over formatting graphical objects.

06:34

Go over the stacking order.

06:48

Go over grouping multiple objects together.

04:29

Using Graphical Objects And Mathematical Formulas

Article

Downloadable material

Section 12: Charts and how to use them
03:36

Go over the new recommended charts option.

07:33

Go over how to create a chart using the long or the short method and we are going to go over formatting a chart with the 2013 shortcut options.

06:36

Go over modifying the chart type and formatting chart elements.

02:43

Go over adding a trend line to an existing chart.

08:17

Go over the pie chart in detail.

06:00

Go over mini graphs sparklines.

Article

Downloadable material

Section 13: Excel and how to use it as a database
06:01

Go over fixing on screen rows and columns.

08:19

Go over fixing print rows and columns and we are also going to go over sorting data In excel.

05:29

Go over filtering data to reduce dataset size.

05:11

Go over removing duplicate entries in the data and adding subtotals to a worksheet.

04:30

Go over using text to columns effectively.

03:29

Go over linking to data on a webpage.

Article

Downloadable material

Section 14: Advanced and a bit complicated formulas
03:59

Go over using an If formula.

05:14

Go over the use of the If function to hide excel error messages.

04:27

Go over the Datedif function in excel.

04:58

Go over text manipulation using functions.

06:35

Go over using the text function to format numbers and we are also going to go over date manipulation functions.

05:25

We are going to introduce sumif, countif, and averageif.

04:41

Go over the use of rank to calculate placing’s.

02:49

We are going to go over flash fill.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Optimum Education Center, “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.

Instructor Biography

Edwin Mirzayans, 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.”

Ready to start learning?
Take This Course