Sale!

Microsoft Excell 2016 For Windows– Professional Video Training Tutorial

£4.99 £2.89

Category:

Description

Description
    • MICROSOFT EXCELL 2016 TUITION
    •  
    • SAME DAY DISPATCH
    • TRUSTED SELLER.

Product Description

MICROSOFT EXCELL 2016 TUITION DVD EDITION

Getting Started with Excell

    What is Excel used for ?

    Using the menu system

    Using the Quick Access Toolbar

    Understanding workbooks and worksheets

    Using the Formula bar

    Using the Status bar

    Using navigation tools

    Using shortcut menus and the Mini toolbar

    Creating new workbooks

    Using Excel Help

      1. Entering Data

    Exploring data entry and editing techniques

    Entering data with AutoFill

    Working with dates and times

    Using Undo and Redo

    Adding comments

    Using Save or Save As

      1. Creating Formulas and Functions

    Creating simple formulas

    Copying a formula into adjacent cells

    Calculating year-to-date totals

    Creating a percentage-change formula

    Working with relative, absolute, and mixed references

    Using SUM and AVERAGE

    Using other common functions

      1. Formatting

    Exploring font styles and effects

    Adjusting row heights and column widths

    Working with alignment and Wrap Text

    Designing borders

    Exploring numeric and special formatting

    Formatting numbers and dates

    Using conditional formatting

    Creating and using tables

    Inserting shapes, arrows, and other visual features

      1. Adjusting Worksheet Layout and Data

    Inserting and deleting rows and columns

    Hiding and unhiding rows and columns

    Moving, copying, and inserting data

    Finding and replacing data

      1. Printing

    Exploring the Page Layout tab and Page Layout view

    Previewing page breaks

    Working with Page Setup and printing controls

      1. Charts

    Creating charts

    Exploring chart types

    Formatting charts

    Working with axes, titles, and other chart elements

    Creating in-cell charts with sparklines

      1. Adjusting Worksheet Views

    Freezing and unfreezing panes

    Splitting screens horizontally and vertically

    Collapsing and expanding data views with outlining

      1. Multiple Worksheets and Workbooks

    Displaying multiple worksheets and workbooks

    Renaming, inserting, and deleting sheets

    Moving, copying, and grouping sheets

    Using formulas to link worksheets and workbooks

    Locating and maintaining links

      1. IF, VLOOKUP, and Power Functions

    Using IF functions and relational operators

    Getting approximate table data with the VLOOKUP function

    Getting exact table data with the VLOOKUP function

    Using the COUNTIF family of functions

      1. Security and Sharing

    Unlocking cells and protecting worksheets

    Protecting workbooks

    Assigning passwords to workbooks

    Sharing workbooks

    Tracking changes

      1. Data Management Features

    Sorting data

    Inserting subtotals in a sorted list

    Using filters

    Splitting data into multiple columns

    Splitting and combining columnar data with Flash Fill

    Removing duplicate records

    Using validation tools

      1. Data Analysis Tools

    Using Goal Seek

    Using Solver

    Using Scenario Manager

    Using data tables

      1. PivotTables

    Creating PivotTables

    Manipulating PivotTable data

    Grouping by date and time

    Grouping by other factors

    Using slicers to clarify and manipulate fields

    Using PivotCharts

      1. Introduction to Macros

    Exploring the need for macros

    Creating a simple macro

    Running a macro

 

 

Delivery
ALL ITEMS SHIPPED SAME DAY
Returns
See our Terms for details.
Payment

We accept payment via Debit & Credit Card and PayPal. All transactions are 100% secure.

Why Buy From Us?

M J Dobsons

 

Also Available from MJDobson Ebay Shop and Our UK Website
Windows Systems – Language CoursesKey RingsExercise DVDs
Children’s Cds-Iphone Cases-Anti-Virus-Repair DVDs

 

                             
 

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.