Excel 2016 - Level 1 | Beginner’s Course and Aims | NextTech

Excel 2016 - Level 1

loading..
(Course eligible for SATVs)

loading..

This is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2016. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles. 

  • Starting Excel From the Desktop
  • Understanding the Excel Start Screen
  • The Excel Workbook Screen
  • How Excel 2016 Works
  • Using the Ribbon
  • Showing and Collapsing the Ribbon
  • Understanding the Backstage View
  • Accessing the Backstage View
  • Using Shortcut Menus
  • Understanding Dialog Boxes
  • Launching Dialog Boxes
  • Understanding the Quick Access Toolbar
  • Adding Commands to the QAT
  • Understanding the Status Bar
  • Exiting Safely From Excel 2016
  • Understanding Workbooks
  • Using the Blank Workbook Template
  • Typing Text
  • Typing Numbers
  • Typing Dates
  • Understanding the Fill Handle
  • Typing Formulas
  • Easy Formulas
  • Saving a New Workbook on Your Computer
  • Checking the Spelling
  • Making Basic Changes
  • Printing a Worksheet
  • Safely Closing a Workbook
  • Understanding the Windows Filing Structure
  • Understanding Naming Conventions
  • Understanding Version Compatibility
  • Saving With a Different Name
  • Saving in Another Location
  • Saving in Another Version
  • Saving in a Web Format
  • Saving in Binary Format
  • Saving as a Template
  • Saving as Macro Enabled
  • Saving With Thumbnails
  • Saving Tags and Author Details
  • Opening an Existing Workbook
  • Navigating a Workbook
  • Navigating Using the Keyboard
  • Using Go To
  • Recent Files and Folders
  • Understanding Data Editing
  • Overwriting Cell Contents
  • Editing Longer Cells
  • Editing Formulas
  • Clearing Cells
  • Deleting Data
  • Using Undo and Redo
  • Understanding How Help Works
  • Using Tell Me
  • Accessing the Help Window
  • Navigating the Help Window
  • Using Google to Get Help
  • Printing a Help Topic
  • Other Sources of Assistance
  • Understanding Formulas
  • Creating Formulas That Add
  • Creating Formulas That Subtract
  • Formulas That Multiply and Divide
  • Understanding Functions
  • Using the SUM Function to Add
  • Summing Non-Contiguous Ranges
  • Calculating an Average
  • Finding a Maximum Value
  • Finding a Minimum Value
  • Creating More Complex Formulas
  • What if Formulas
  • Common Error Messages
  • Absolute Versus Relative Referencing
  • Relative Formulas
  • Problems With Relative Formulas
  • Creating Absolute References
  • Creating Mixed References
  • 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 List
  • Extracting With Flash Fill
  • More Complex Flash Fill Extractions
  • Extracting Dates and Numbers
  • Understanding Cells and Ranges
  • Selecting Contiguous Ranges
  • Selecting Non-Contiguous Ranges
  • Using Special Selection Techniques
  • Selecting Larger Ranges
  • Selecting Rows
  • Selecting Columns
  • Viewing Range Calculations
  • Creating an Input Range
  • Understanding Copying in Excel
  • Using Fill for Quick Copying
  • Copying From One Cell to Another
  • Copying From One Cell to a Range
  • Copying From One Range to Another
  • Copying Relative Formulas
  • Copying to a Non-Contiguous Range
  • Copying to Another Worksheet
  • Copying to Another Workbook
  • Understanding Moving in Excel
  • Moving Cells and Ranges
  • Moving by Dragging
  • Moving Data to Other Worksheets
  • Moving Data to Other Workbooks
  • Understanding Pasting Options
  • Pasting Formulas
  • Pasting Values
  • Pasting Without Borders
  • Pasting as a Link
  • Pasting as a Picture
  • The Paste Special Dialog Box
  • Copying Comments
  • Copying Validations
  • Copying Column Widths
  • Performing Arithmetic With Paste Special
  • Copying Formats With Paste Special
  • Understanding Font Formatting
  • Working With Live Preview
  • Changing Fonts
  • Changing Font Size
  • Growing and Shrinking Fonts
  • Making Cells Bold
  • Italicising Text
  • Underlining Text
  • Changing Font Colours
  • Changing Background Colours
  • Using the Format Painter
  • Applying Strikethrough
  • Subscripting Text
  • Superscripting Text
  • Understanding Number Formatting
  • Applying General Formatting
  • Formatting for Money
  • Formatting Percentages
  • Formatting as Fractions
  • Formatting as Dates
  • Using the Thousands Separator
  • Increasing and Decreasing Decimals
  • Understanding Cell Alignment
  • Horizontal Cell Alignment
  • Vertical Cell Alignment
  • Indenting Cells
  • Rotating Text
  • Wrapping and Merging Text
  • Unmerging Cells
  • Approximating Column Widths
  • Setting Precise Columns Widths
  • Setting the Default Column Width
  • Approximating Row Height
  • Setting Precise Row Heights
  • Hiding Rows and Columns
  • Unhiding Rows and Columns
  • 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
  • Understanding Headers and Footers
  • Adding a Quick Header
  • Adding a Quick Footer
  • Switching Between Headers and Footers
  • Typing Text Into Headers and Footers
  • Modifying Headers and Footers
  • Adding Page Numbering
  • Adding Date Information
  • Adding Workbook Information
  • Adding a Picture
  • Formatting Headers and Footers
  • Dragging Margins for Headers and Footers
  • Creating a Different First Page
  • Different Odd and Even Pages
  • Understanding Printing
  • Previewing Before You Print
  • Selecting a Printer
  • Printing a Range
  • Printing an Entire Workbook
  • Specifying the Number of Copies
  • The Print Options
  • Understanding Worksheets
  • Changing the Worksheet View
  • Worksheet Zooming
  • Viewing the Formula Bar
  • Viewing Worksheet Gridlines
  • Viewing the Ruler
  • Inserting Cells Into a Worksheet
  • Deleting Cells From a Worksheet
  • Inserting Columns Into a Worksheet
  • Inserting Rows Into a Worksheet
  • Deleting Rows and Columns
  • Working With Multiple Worksheets
  • Worksheet Wisdom
  • Inserting and Deleting Worksheets
  • Copying a Worksheet
  • Renaming a Worksheet
  • Moving a Worksheet
  • Hiding a Worksheet
  • Unhiding a Worksheet
  • Copying a Sheet to Another Workbook
  • Changing Worksheet Tab Colours
  • Grouping Worksheets
  • Hiding Rows and Columns
  • Unhiding Rows and Columns
  • Freezing Rows and Columns
  • Splitting Windows
  • 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 Command
  • Using the More Borders Command
  • Drawing Borders
  • Drawing a Border Grid
  • Erasing Borders
  • Formatting the Drawing Pencil
  • Applying Alternate Currencies
  • Applying Alternate Date Formats
  • Formatting Clock Time
  • Formatting Calculated Time
  • Understanding Number Formatting
  • Understanding Format Codes
  • Creating Descriptive Custom Formats
  • Custom Formatting Large Numbers
  • Custom Formatting for Fractions
  • Padding Numbers Using Custom Formatting
  • Aligning Numbers Using Custom Formats
  • Customising the Display of Negative Values

This course is intended for students who wish to gain a foundational understanding of Microsoft Office Excel 2016 that is necessary to create and work with electronic spreadsheets.

This course assumes little or no knowledge of spreadsheets or Microsoft Excel 2016. However, it would be beneficial to have a general understanding of personal computers and the operating system environment, especially in regard to working with files and folders.

Key Participants Benefit

Upon successful completion of this course, you will be able to:

  • navigate your way around Microsoft Excel 2016
  • create and work with a new workbook
  • save workbooks in a variety of formats
  • open and navigate within workbooks and worksheets
  • make changes to data in a workbook
  • obtain help for Excel whenever you need it
  • understand, create and work with formulas and functions
  • understand and use formula cell referencing
  • use the fill operations available to fill a data series
  • understand and work with ranges in a worksheet
  • copy and paste data in Excel
  • move the contents of cells and ranges within and between workbooks
  • use the special pasting options in Excel
  • use font formatting techniques
  • understand and use the number formatting features in Excel
  • align the contents of cells in a number of ways
  • format rows and columns in a worksheet
  • apply a variety of page setup techniques
  • create and work with headers and footers
  • print your workbook data
  • work with elements that make up the structure of a worksheet
  • use a range of techniques to work with worksheets
  • apply borders to cells and ranges in a worksheet
  • apply a range of number formatting techniques to worksheet cells

Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organisation. You will: Get started with Microsoft Office Excel 2016. Perform calculations. Modify a worksheet. Format a worksheet. Print workbooks. Manage workbooks.

Register

Traditional Classroom   

    Show all

    Traditional Classroom   

      Show all

      Traditional Classroom   

        Show all

        Traditional Classroom   

          Show all

          NextTech Live   

            Show all

            Flexible Mentored Learning   

              Show all

              Flexible Mentored Learning   

                Show all

                Flexible Mentored Learning   

                  Show all

                  Flexible Mentored Learning   

                    Show all

                    blah is false