Microsoft Excel 2013 Foundation

This course will provide complete information for learning the basic concepts of excels 2013 application and also for customizing excel options.You will also learn to create and manage worksheets, format cells, ranges, and tables, advanced formulas, utilize and creating charts and also inserting objects etc.

Key techniques:
  • 6 hours e-learning content with high quality.
  • 6 chapter quizzes.
  • Expertise.
  • 1 Microsoft exam.
  • Preparation for Microsoft Excel 2013 exam.
Objectives:
  • Build expertise with excel, powerful spreadsheet application created by Microsoft to analyze business functions.
  • New features are included in excel 2013 includes remote file saving, selecting and timeless features.
  • Professional time benefits in different ways.The new 2013 flash excel features allow for easy work with the data.
  • It has no save files in remote locations allowing users to access online data from anywhere.
  • In addition, Excel 2013 has an option to save files in remote locations, which allows users to access online files from anywhere.
Skills you learn:
  • Creating tables.
  • Creating cells and ranges.
  • Creating charts.
  • Creating data.
  • Creating online access from anywhere.
Who should take this course?
  • Those who want to master excel 2013 and improve their job prospect.
  • This course is beneficial for those who want to make excel in Microsoft Excel 2013.

Course Content:

Overview of MOS Foundation
  • Welcome
  • Overview of MOS Foundation
  • Table of Content
  • Course Objective
  • Course Overview
  • Value of Excel for Professionals
  • Value of Excel for Organizations
  • Lessons Covered
  • Exam Pattern
  • MOS Excel 2013 Level 1 Certification
  • Sources of Information
Introduction to Excel 2013
  • Introduction to Excel 2013
  • Objectives
  • Excel 2013 Application User Interface
  • Excel 2013 Application User Interface contd
  • Excel 2013 Application Window
  • Excel 2013 Application Window Elements
  • Ribbon Options
  • Business Scenario
  • Demo Summary
  • Quick Access Toolbar
  • Customize Quick Access Toolbar
  • Business Scenario
  • Demo summary
  • Backstage View in Excel 2013
  • New Features in Excel 2013
  • Quiz
  • Summary
Create and Manage Workbooks and Worksheets
  • Create and Manage Workbooks and Worksheets
  • Objectives
  • Excel 2013 Workbooks
  • Create a Blank Workbook
  • Create a Workbook from a Template
  • Open an Existing Workbook
  • Business Scenario
  • Demo Summary
  • Native and Non native Files
  • Connect Import External Files
  • Connect Import External Files contd
  • Business Scenario
  • Demo summary
  • Worksheet Operations
  • Change Worksheet Tab Color
  • Hide or Unhide Worksheets
  • Business Scenario
  • Demo summary
  • Search and Replace Data
  • Go To and Name Box
  • Business Scenario
  • Demo summary
  • Insert Hyperlinks
  • Business Scenario
  • Demo summary
  • Modifying Workbook Themes
  • Modify Page Setup
  • Insert and Delete Columns and Rows
  • Modify Row Height and Column Width
  • Hide or Unhide Columns and Rows
  • Business Scenario
  • Demo summary
  • Insert Headers and Footers
  • Insert Headers and Footers contd
  • Business Scenario
  • Demo summary
  • Data Validation
  • Data Validation contd
  • Business Scenario
  • Demo summary
  • Enable Developer Tab
  • Macro Security Options
  • Record Macros
  • Business Scenario
  • Demo summary
  • Workbook Views
  • Use Zoom for Workbooks
  • Freeze Panes
  • Split Window
  • Business Scenario
  • Demo summary
  • Show Formulas
  • Business Scenario
  • Demo summary
  • Add Values to Workbook Properties
  • Business Scenario
  • Demo summary
  • Save Workbooks in Alternate File Formats
  • Set Print Area and Print Workbooks
  • Business Scenario
  • Demo summary
  • Save Workbooks to Remote Locations
  • Quiz
  • Summary
Create Cells and Ranges
  • Create Cells and Ranges
  • Objectives
  • Cells and Ranges
  • Create Data using FillSeries
  • Business Scenario
  • Demo Summary
  • Create Data using AutoFill
  • Business Scenario
  • Demo Summary
  • Customize AutoFill Options
  • Business Scenario
  • Demo Summary
  • Paste Options
  • Paste Special
  • Format Cell Structure
  • Business Scenario
  • Demo Summary
  • Merge and Center
  • Business Scenario
  • Demo Summary
  • Format Cell Content
  • Business Scenario
  • Demo Summary
  • Cell Styles
  • Business Scenario
  • Demo Summary
  • Number Formats
  • Format Painter
  • Business Scenario
  • Demo Summary
  • Data Model with Advanced Conditional Format
  • Data Model with Advanced Conditional Format contd
  • Sparklines
  • Business Scenario
  • Demo Summary
  • Create Named Ranges
  • Business Scenario
  • Demo Summary
  • Data Group and Ungroup
  • Subtotals
  • Quiz
  • Summary
Create Tables
  • Create Tables
  • Objectives
  • Tables in Excel 2013
  • Create and Format a Table
  • Business Scenario
  • Demo Summary
  • Define Table Names
  • Business Scenario
  • Demo Summary
  • Insert Table Rows and Columns
  • Business Scenario
  • Demo Summary
  • Delete Table Rows and Columns
  • Business Scenario
  • Demo Summary
  • Move Table Rows and Columns
  • Business Scenario
  • Demo Summary
  • Convert to Range
  • Business Scenario
  • Demo Summary
  • Remove Duplicates
  • Business Scenario
  • Demo Summary
  • Design Table Styles
  • Business Scenario
  • Demo Summary
  • Table Style Options
  • Filter Tables
  • Business Scenario
  • Demo Summary
  • Sort Table Data
  • Business Scenario
  • Demo Summary
  • Quiz
  • Summary
Apply Formulas and Functions
  • Apply Formulas and Functions
  • Objectives
  • Formulas and Functions
  • Cell References and Ranges in Formulas
  • Cell References and Ranges in Formulas contd
  • Business Scenario
  • Demo Summary
  • Formula Calculations Order
  • SUM Function
  • Business Scenario
  • Demo Summary
  • COUNT Function
  • COUNTA Function
  • Business Scenario
  • Demo Summary
  • AVERAGE Function
  • MIN Function
  • MAX Function
  • Business Scenario
  • Demo Summary
  • Conditional Logic in Functions
  • SUMIF Function
  • SUMIFS Function
  • Business Scenario
  • Demo Summary
  • COUNTIF Function
  • COUNTIFS Function
  • Business Scenario
  • Demo Summary
  • AVERAGEIF Function
  • AVERAGEIFS Function
  • Business Scenario
  • Demo Summary
  • LOWER PROPER UPPER and CONCATENATE Functions
  • TRIM Function
  • Business Scenario
  • Demo Summary
  • LEFT Function
  • RIGHT Function
  • mid Function
  • Business Scenario
  • Demo Summary
  • Quiz
  • Summary
Create Charts and Objects
  • Create Charts and Objects
  • Objectives
  • Introduction to Charts
  • Create Charts
  • Create Charts contd
  • Create Charts contd
  • Business Scenario
  • Demo Summary
  • Format Charts
  • Format Charts contd
  • Business Scenario
  • Demo Summary
  • Move and Resize Charts
  • Business Scenario
  • Demo Summary
  • Recommended Charts
  • Business Scenario
  • Demo Summary
  • Introduction to Objects
  • Insert Picture Objects
  • Business Scenario
  • Demo Summary
  • Insert Other File Formats as Objects
  • Business Scenario
  • Demo Summary
  • Add Textboxes
  • Business Scenario
  • Demo Summary
  • Add SmartArt
  • Business Scenario
  • Demo Summary
  • Quiz
  • Summary

Exam and certification:
  • For the Microsoft Excel 2013 certification, you have to take the Microsoft Excel certification exam.
  • You have to register for the exam online at Microsoft official website.
  • After registration next sign in for the exam and select the exam and schedule for the exam with the allotted time.
  • No pre-requisites for taking the exam.
Unlock your certificate:
  • After completion of the online course and certification and after you passes the exam you have to get 85% of the course to unlock the certificate.
  • Contact us using the form on the right of any page on the COEPD.US website or select the Live Chat link. Our customer service representatives can provide you with more details.
© 2015 4cLearn. All Rights Reserved.