MOS: Microsoft Office Excel 2016 - Course

Instruction Language: English
Application Language: English
This course serves as a preparation for the examination MOS - Microsoft Office Excel 2016 (Exam 77-727). You will get familiarised in it with the Excel 2016 environment and its documents and you will learn to control them. You will learn in each lesson to create tables step by step. You will find out how to enter values correctly into the cells and how to set the cell formatting, including conditional formatting. You will learn to manipulate each cell and cell range, you will learn to work with worksheets and entire files. You will create a chart and learn to create calculations by basic arithmetic formulas. You will broaden your 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. You will also familiarise yourself with the usage of macros, including their creation and editing and you will examine the options of macro security.

Product code: EN-MOS16-Exc

Online

Price
£ 32.00
£ 38.72 incl. VAT info
*
*
  • Introduction to the practical use of Excel
  • Data entry into cells
  • Excel table
  • Cell and range references
  • Charts creation
  • Excel workbook
  • Moving and copying cell values
  • Advanced work with Excel tables
  • Using references in formulas
  • Chart design
  • Creation and saving of a workbook
  • Number and date fill series
  • Data filtering
  • Basic formulas
  • Chart formatting
  • Manipulating worksheets
  • Text series and custom lists
  • Sorting
  • AutoSum
  • Shapes
  • Navigation within a worksheet
  • Alignment of data in cells
  • Removing duplicate data
  • Logical functions and conditional calculations
  • SmartArt
  • Finding and replacing specific values
  • Font formatting
  • Text functions
  • Pictures in Excel
  • Hyperlinks
  • Copying formatting
  • Page setup
  • Numeric values in cells
  • Adjusting rows and columns
  • Borders and fill
  • Themes
  • Cell styles
  • Header and footer
  • Conditional formatting
  • Data validation
  • Sparklines
  • Manipulation with sheets of multiple workbooks
  • Advanced paste options
  • Customisation of the Quick Access Toolbar
  • Naming cell ranges
  • Customising the Ribbon
  • Outline
  • Macro security
  • Workbook views
  • Introduction to macros
  • File properties
  • Excel window
  • Splitting worksheets into panes
  • Macro editing
  • Printing
  • Saving a workbook to the Web
Products specifications

System Requirements

ProductType Single courses
ApplicationLanguage English
EducationLanguage English