MS Excel 2013/16 – Intermediate

excel-2013

  • Category : Microsoft Office 2013/16
  • Course Name : MS Excel 2013/16 – Intermediate
  • Instruction Language : English
  • No. of Courses : 1
  • No. of Lessons : 35
  • Price : R725 ( Includes Vat % ) | (USD $49)

MS Excel 2013/16: Intermediate

MS Office 2013

In the course MS Excel 2013/16: Intermediate, the presented interactive lessons focus mainly on performing various calculations. You will broaden your basic knowledge by the application of logical and text functions. You will get acquainted with the principles of referencing to the values in other cells. You will learn to fill cells with series of data. You will familiarise yourself with the advanced options of sorting and filtering data or searching for specific values in extensive tables. You will also examine how to split longer text entries in tables into individual data placed into several columns.

Lessons:

  • Customisation of the Quick Access Toolbar
  • Customising the Ribbon
  • Manipulation with sheets of multiple workbooks
  • Advanced paste options
  • Copying multiple items
  • Pasting external data into Excel
  • Advanced number formats
  • Custom number format
  • Worksheet protection
  • Advanced work with Excel tables
  • Using references in formulas
  • Comparing and connecting values using operators
  • Cell and range references
  • Conditional formatting rules
  • Conditional formatting based on a formula
  • Function library
  • Text functions
  • Advanced text functions
  • Math functions
  • Statistical functions
  • Date and time functions
  • Logical functions and conditional calculations
  • Nested functions
  • Errors in cells and their checking
  • Naming cell ranges
  • Data validation
  • Advanced fill series
  • Advanced sorting
  • Data filtering
  • Using slicers to filter data
  • Finding and replacing specific values
  • Removing duplicate data
  • Splitting text into columns
  • Flash Fill
  • Outline

College Africa Group is the African Continent’s authorised partner for Gopas. GOPAS is one of the major IT training providers. Its technical courses are annually attended by almost 30,000 students, mostly IT specialists.


System Requirements

The courses have been developed using Flash technology. For this reason the minimum system requirements for a user PC are very low:

  • Any of following internet browsers: Internet Explorer 8.0 or higher, Opera, Mozilla Firefox, Chrome; all with the Adobe Flash plug-in version 8.0 or higher
  • 1 GHz CPU; 512 MB RAM; OS Windows XP or higher
  • Display resolution of 1280 x 1024
  • Sound card, speakers or headphones are recommended

System Requirements For Using LMS

  • Processor: 1 GHz or higher
  • Memory: 512 MB RAM
  • Display resolution 1280 × 1024 or higher
  • Any of following internet browsers: Internet Explorer 8.0 or higher, Opera, Mozilla Firefox, Chrome; all with the Adobe Flash plug-in version 8.0 or higher
  • Operating system for online or internal LMS use: Windows XP or higher or Mac OS (+ Opera browser)
  • Sound card and speakers/headphones are recommended

MS Office 2013

Download TOC for MS Excel 2013/16- Intermediate
Buy