Or follow us:
Join now to receive our Course Deals  

Buy Any Course or Bundle This Month & Get The Personal Success Training Program FREE

Certificate in Excel 2013 Core Essentials Online Course

Learn The Core Fundamentals of Excel 2013


Learn The Core Fundamentals of Excel 2013

The Basics

This module begins by covering how to sign into an account. Also covered are the parts of a workbook along with how to create, open, and save workbooks.

Your First Workbook
Next up is how to enter, select, and delete data. How to undo and redo is also covered, along with using cut, copy, and paste functions.

Working with Data
This module covers inserting rows and columns along with how to merge and split cells. Additional topics include using Paste Special, find and replace, and hiding and unhiding cells.

Using Basic Excel Tools
Cell references and formulas are covered in this module. Also discussed is how to use basic formulas, how to learn basic and advanced functions, and how to run spell check. How to use the sort and filter tools to organize data is also covered.

Using Timesaving Tools
Timesaving is the focus of this module. Students will learn how to use AutoFill, Flash Fill, AutoSum, AutoComplete, and AutoCalculate.

Formatting Text
Various ways to format and work with text are the main points of this module. Ways to change font face, size, and color, apply text effects, and add borders and fill to cells are all covered. Other topics include using the Font tab of the Format Cells dialog and how to clear formatting from text.

Formatting Data
There are many ways to format data in Excel 2013. This module looks at how to adjust text wrapping, changing the size of rows and columns, adjusting cell alignment, changing text direction, and applying number formatting.

Formatting the Workbook
This module will teach how to use cell styles, format data as a table, and change the theme of a workbook. Also covered is inserting page breaks and adding a background image.

Inserting Art and Objects
Inserting SmartArt, text boxes, and equations into worksheets is covered in this module. Also touched upon is how to draw shapes on worksheets.

Charting Data
Various methods to chart data in Excel 2013 are covered in this module. Topics include how to create Sparklines and timelines, plus how to insert PivotTables and PivotCharts, and use Slicers.

Viewing, Printing, and Sharing Your Workbook
Ways to view and distribute a workbook are covered in this module. Topics include using views, saving a workbook as PDF or XPS, printing and e-mailing a workbook, and sharing a workbook on SkyDrive.

Customizing the Interface
The final module of this course focuses on ways to customize the interface. Topics for discussion include how to change ribbon display options and how to customize the Quick Access toolbar. Also covered is how to hide and show ribbon tabs and create custom ribbon tabs. How to reset the interface is covered as well.

Course Fast Facts:

  1. Easy to follow and understand
  2. Only 6 to 8 hours of study is required
  3. Unlimited, lifetime access to online course
  4. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  5. You can study from home or at work, at your own pace, in your own time
  6. Certificate of Completion

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

This course is internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

The Basics

  • Getting Started
  • Signing In
  • Creating a New Workbook
  • Parts of a Workbook
  • Saving a Workbook
  • Opening a Workbook

Your First Workbook

  • Your First Workbook
  • Selecting Data
  • Entering and Deleting Data
  • Using Undo and Redo
  • Using Cut, Copy, and Paste

Working with Data

  • Working with Data
  • Inserting Rows and Columns
  • Merging and Splitting Cells
  • Moving Cells
  • Using Paste Special
  • Using Find and Replace
  • Hiding and Unhiding Cells

Using Basic Excel Tools

  • Using Basic Excel Tools
  • Understanding Cell References and Formulas
  • Using Basic Formulas
  • Using Basic Functions
  • Using Advanced Functions
  • Using Spell Check
  • Using Sort and Filter

Using Timesaving Tools

  • Using AutoFill
  • Using Flash Fill
  • Using AutoSum
  • Using AutoComplete
  • Using AutoCalculate

Formatting Text

  • Changing the Font Face, Size, and Color
  • Applying Text Effects
  • Applying Borders and Fill
  • Using the Font Tab of the Format Cells Dialog
  • Clearing Formatting

Formatting Data

  • Wrapping Text
  • Changing the Size of Rows and Columns
  • Adjusting Cell Alignment
  • Changing Text Direction
  • Changing Number Format

Formatting the Workbook

  • Using Cell Styles
  • Formatting Data as a Table
  • Changing the Theme
  • Inserting Page Breaks
  • Adding a Background

Inserting Art and Objects

  • Inserting SmartArt
  • Inserting Text Boxes
  • Inserting Pictures
  • Inserting Equations
  • Drawing Shapes

Charting Data

  • Creating Sparklines
  • Inserting Charts
  • Inserting PivotTables
  • Inserting PivotCharts
  • Using Slicers
  • Creating Timelines

Viewing, Printing, and Sharing Your Workbook

  • Using Views
  • Saving a Workbook as PDF or XPS
  • Printing a Workbook
  • E-Mailing a Workbook
  • Sharing Your Workbook on SkyDrive

Customizing the Interface

  • Changing Ribbon Display Options
  • Customizing the Quick Access Toolbar
  • Hiding and Showing Ribbon Tabs
  • Creating Custom Ribbon Tabs
  • Resetting Interface Changes

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet.

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

Now Only ₩167449 Save ₩56150 (25%)
OFF RRP ₩223599
Delivery Method Online
Get Info Pack

Special Offer

 

Receive The Personal Success Training Program FREE, When You Purchase This Course - Limited Time Remaining!  (Value 452500)

 

The Personal Success Training Program Helps You Stay Focused To Achieve Your Goals!
Benefits:
  • How to layout a Success Plan.
  • Get where you want to be in life.
  • How to unclutter your mind to succeed.
  • Achieve your dreams using your imagination.
  • How to have faith in yourself.
Features:
  • 12 month online access,  24/7 anywhere.
  • Complement your individual course purchase.
  • Internationally recognized by the IAOTS.
  • Thousands of positive reviews.
  • Limited Time Offer - Ends Soon.
 

Share this course

Course Summary

Course ID No.: 002EX13CEOC
Delivery Mode: Online
Course Access: Lifetime Course Access
Time required: Study at your own pace
Course Duration: 6 - 8 Hours
Qualification: Certificate