Chat with us, powered by LiveChat

For All Enquiries

1300 731 939

Excel 2019 – Level 2

  • Course Code:

    50545
  • Course Duration:

    1 Day
  • Course Price:

    $395
  • Availability:

    Call/Email to register interest
  • Overview & ObjectivesOpen or Close

    Microsoft Excel Level 2 is the second of a 3-Level study program for Microsoft Excel. This level extends the learner’s basic knowledge of Excel and provides the learner with skills and knowledge to produce more effective and productive workbooks. It covers formulas and function techniques, more intricate formatting, setting complex printing options, using intricate charting features, and working more effectively with existing worksheets and workbooks.

  • Skills GainedOpen or Close

    Microsoft Excel Level 2 is designed for existing users of Excel who would like to expand their skills and knowledge and learn more of the techniques associated with creating better and more productive workbooks.

    At the completion of this course you should be able to:

    • use the fill operations available to fill a data series, and move the contents of cells and ranges within and between workbooks
    • work with logical functions in Excel
    • use a range of formula techniques
    • apply a range of number formatting techniques to data
    • apply conditional formatting to ranges in a worksheet
    • apply borders to cells and ranges
    • apply a variety of page setup techniques and work with various elements of a worksheet
    •  use a range of find and replace techniques
    • sort and filter data in a list in a worksheet
    • use a range of techniques to enhance charts
  • Course ModulesOpen or Close

    Filling Data

    • Understanding Filling
    • Filling A Series
    • Filling A Growth Series
    • Filling A Series Backwards
    • Filling Using Options
    • Creating A Custom Fill List
    • Modifying A Custom Fill List
    • Deleting A Custom Fill ListMoving Data

       

    • Understanding Moving In Excel
    • Moving Cells And Ranges
    • Moving Data To Other Worksheets
    • Moving Data To Other WorkbooksLogical Functions

       

    • Understanding Logical Functions
    • Using IF To Display Text
    • Using IF To Calculate Values
    • Nesting IF Functions
    • Using IFERROR
    • Using TRUE And FALSE
    • Using AND
    • Using OR
    • Using NOTFormula Techniques

       

    • Scoping A Formula
    • Developing A Nested Function
    • Creating Nested Functions
    • Editing Nested Functions
    • Copying Nested Functions
    • Using Concatenation
    • Switching To Manual Recalculation
    • Forcing A Recalculation
    • Pasting Values From FormulasNumber Formatting Techniques

       

    • Using Alternate Currencies
    • Formatting Dates
    • Formatting Time
    • Creating Custom FormatsConditional Formatting

       

    • Understanding Conditional Formatting
    • Formatting Cells Containing Values
    • Clearing Conditional Formatting
    • More Cell Formatting Options
    • Top Ten Items
    • More Top And Bottom Formatting Options
    • Working With Data Bars
    • Working With Colour Scales
    • Working With Icon Sets
    • Understanding Sparklines
    • Creating Sparklines
    • Editing SparklinesApplying Borders

       

    • Understanding Borders
    • Applying A Border To A Cell
    • Applying A Border To A Range
    • Applying A Bottom Border
    • Applying Top And Bottom Borders
    • Removing Borders
    • The More Borders Options
    • Using The More Borders OptionPage Setup

       

    • Understanding Page Layout
    • Using Built-In Margins
    • Setting Custom Margins
    • Changing Margins By Dragging
    • Centring On A Page
    • Changing Orientation
    • Specifying The Paper Size
    • Setting The Print Area
    • Clearing The Print Area
    • Inserting Page Breaks
    • Using Page Break Preview
    • Removing Page Breaks
    • Setting A Background
    • Clearing The Background
    • Settings Rows As Repeating Print Titles
    • Clearing Print Titles
    • Printing Gridlines
    • Printing Headings
    • Scaling To A Percentage
    • Fit To A Specific Number Of Pages
    • Strategies For Printing Larger WorksheetsWorking With A Worksheet

       

    • Understanding Worksheets
    • Changing Worksheet Views
    • Worksheet Zooming
    • Viewing The Formula Bar
    • Viewing The Gridlines
    • Viewing The Ruler
    • Inserting Cells
    • Deleting Cells
    • Inserting Columns
    • Inserting Rows
    • Deleting Rows And Columns
    • Switching Between WorksheetsWorksheet Techniques

       

    • Inserting And Deleting Worksheets
    • Copying A Worksheet
    • Renaming A Worksheet
    • Moving A Worksheet
    • Hiding A Worksheet
    • Unhiding A Worksheet
    • Copying A Worksheet To Another Workbook
    • Moving A Worksheet To Another Workbook
    • Changing Worksheet Tab Colours
    • Grouping Worksheets
    • Hiding Rows And Columns
    • Unhiding Rows And Columns
    • Freezing Rows And Columns
    • Splitting WindowsFinding And Replacing

       

    • Understanding Find And Replace Operations
    • Finding Text
    • Finding Cell References In Formulas
    • Replacing Values
    • Using Replace To Change
    • Formulas
    • ]Replacing Within A Range
    • Finding Formats
    • Finding Constants Using Go To Special
    • Finding Formulas Using Go To Special
    • Finding The Current Region
    • Finding The Last Cell
  • PrerequisitesOpen or Close

    Microsoft Excel Level 2 assumes the learner has the skills and knowledge required to create, edit, print and chart simple worksheets. Understanding ranges and the copying process is important. It would also be beneficial to have a general understanding of personal computers and the Windows operating system environment.

Hav a question

Have a Question?

Give us a Call

Contact Us
PGlmcmFtZSBzcmM9Imh0dHBzOi8vd3d3Lmdvb2dsZS5jb20vbWFwcy9lbWJlZD9wYj0hMW0xNCExbTghMW0zITFkMTMyNTkuMTkzNzAyNTI2ODQzITJkMTUxLjAwMzI1NjYhM2QtMzMuODE3NTE0NiEzbTIhMWkxMDI0ITJpNzY4ITRmMTMuMSEzbTMhMW0yITFzMHgwJTNBMHhlOGI4NWUwZmIzMGQ5MzZmITJzTUlTK0dsb2JhbCtJbnN0aXR1dGUrb2YrVGVjaG5vbG9neSE1ZTAhM20yITFzZW4hMnNhdSE0djE0NDc2Mjg0NjEzMzgiIHdpZHRoPSI0MDAiIGhlaWdodD0iMjUwIiBmcmFtZWJvcmRlcj0iMCIgc3R5bGU9ImJvcmRlcjowIiBhbGxvd2Z1bGxzY3JlZW4+PC9pZnJhbWU+
CONTACT US
Excel 2013 – Level 2
November 26, 2015 25% off
Thank You. We will contact you as soon as possible.
Featured Course: Excel Level 2
Learn to use excel with this intermediate level one day course from MIS Global Technologies and gain the following skills:
  • VLOOKUP
  • Reference functions
  • Use Database Tables
  • Data Validation tools
  • Use Hyperlinks
  • Protect workbooks
CONTACT US
Thank You. We will contact you as soon as possible.
Excel Level 2
Featured Course: Office 365
This is a 5-day Instructor Led Training (ILT) course that targets the needs of IT professionals who take part in evaluating, planning, deploying, and operating Office 365 services. You will learn how to:
  • Implement and Manage Identities by Using DirSync
  • Manage Clients and End-User Devices
  • Provision SharePoint Online Site Collections
  • Configure Exchange Online and Lync Online for End Users
CONTACT US
Thank You. We will contact you as soon as possible.
PGlmcmFtZSBzcmM9Imh0dHBzOi8vd3d3Lmdvb2dsZS5jb20vbWFwcy9lbWJlZD9wYj0hMW0xNCExbTghMW0zITFkMTMyNTkuMTkzNzAyNTI2ODQzITJkMTUxLjAwMzI1NjYhM2QtMzMuODE3NTE0NiEzbTIhMWkxMDI0ITJpNzY4ITRmMTMuMSEzbTMhMW0yITFzMHgwJTNBMHhlOGI4NWUwZmIzMGQ5MzZmITJzTUlTK0dsb2JhbCtJbnN0aXR1dGUrb2YrVGVjaG5vbG9neSE1ZTAhM20yITFzZW4hMnNhdSE0djE0NTU1MTI2NDQyNTAiIHdpZHRoPSI0MDAiIGhlaWdodD0iMjUwIiBmcmFtZWJvcmRlcj0iMCIgc3R5bGU9ImJvcmRlcjowIiBhbGxvd2Z1bGxzY3JlZW4+PC9pZnJhbWU+
CONTACT US
MIS Global Technologies
Phone: 1300 731 939
Suite 513, Level 5 Westfield Office Tower
159-175 Church Street Parramatta NSW 2150
Thank You. We will contact you as soon as possible.
We're happy to answer any questions you may have or provide you with any help you need when choosing the course that's right for you. Please leave a message in the form below and one of our friendly staff will get back to you as soon as possible
Thankyou! Your enquiry has been sent successfully. One of our friendly staff will get back to you soon. For anything urgent you can always call us on 1300 731 939
Featured Course: Excel Level 1
Learn to use excel with our one day course for beginners at MIS Global Technologies and learn about the following:
  • How to enter and edit data
  • How to Insert rows and columns
  • The BEDMAS rule
  • How to format dates
  • How to modify the header or footer
Reserve Your Place Today
Thank You. We will contact you as soon as possible.
Excel Level 2
Please leave a message and let us know which course you are interested in taking with us. One of our friendly staff will contact you as soon as they are available and will help you with your studies.
Thank you for your interest