• Home
  • Course Library
  • Contact
      • Cart

        0
    Have any questions?
    learn@ontracktv.com
    Login
    ontrackTVontrackTV
    • Home
    • Course Library
    • Contact
        • Cart

          0

      IT & Software

      • Home
      • All courses
      • IT & Software
      • Microsoft Excel 2016 Beginner
      CoursesPopularMicrosoft Excel 2016 Beginner
      • Getting Familiar with the Interface 8

        • Lecture1.1
          Understanding the Ribbon
        • Lecture1.2
          Collapsing and expanding the Ribbon
        • Lecture1.3
          Using the Ribbon Display options
        • Lecture1.4
          Customizing the Ribbon
        • Lecture1.5
          Contextual tabs in the Ribbon
        • Lecture1.6
          Understanding the Quick Access Toolbar
        • Lecture1.7
          Customizing the Quick Access Toolbar
        • Lecture1.8
          Using Zoom and View shortcuts in the status bar
      • Understanding the worksheet structure 3

        • Lecture2.1
          Creating a new workbook
        • Lecture2.2
          Understanding the worksheet and cells
        • Lecture2.3
          Understanding cell ranges
      • Selecting and navigating in a worksheet 8

        • Lecture3.1
          Selecting cells and ranges
        • Lecture3.2
          Selecting a row or column
        • Lecture3.3
          Selecting multiple adjacent rows or columns
        • Lecture3.4
          Selecting multiple non-adjacent rows or columns
        • Lecture3.5
          Selecting all cells in a worksheet
        • Lecture3.6
          Navigating using the scrollbars
        • Lecture3.7
          Navigating using the keyboard
        • Lecture3.8
          Using the Go To command
      • Entering and editing data 19

        • Lecture4.1
          Entering data
        • Lecture4.2
          Entering data using the Formula Bar
        • Lecture4.3
          Entering dates
        • Lecture4.4
          Understanding how text data behaves
        • Lecture4.5
          Understanding how numbers and dates behave
        • Lecture4.6
          Adjusting the column width and row height
        • Lecture4.7
          Autofitting the column width and row height
        • Lecture4.8
          Replacing data in a cell
        • Lecture4.9
          Canceling data entry
        • Lecture4.10
          Editing data in a cell
        • Lecture4.11
          Editing data using the Formula Bar
        • Lecture4.12
          Deleting data / Clearing contents
        • Lecture4.13
          Copy and paste using the Ribbon
        • Lecture4.14
          Copy and paste using right click on the mouse
        • Lecture4.15
          Copy and paste using keyboard shortcuts
        • Lecture4.16
          Cut and paste using the Ribbon
        • Lecture4.17
          Cut and paste using right click on the mouse
        • Lecture4.18
          Cut and paste using keyboard shortcuts
        • Lecture4.19
          Moving data within a worksheet
      • Modifying worksheets 10

        • Lecture5.1
          Inserting new columns and rows using the Ribbon
        • Lecture5.2
          Inserting new columns and rows using right click on the mouse
        • Lecture5.3
          Inserting new cells using the Ribbon
        • Lecture5.4
          Inserting new cells using right click on the mouse
        • Lecture5.5
          Inserting a new worksheet
        • Lecture5.6
          Renaming a worksheet
        • Lecture5.7
          Navigating through worksheets
        • Lecture5.8
          Moving and reordering worksheets
        • Lecture5.9
          Creating a copy of a worksheet using right click
        • Lecture5.10
          Creating a copy of a worksheet by dragging
      • Saving and closing a workbook 2

        • Lecture6.1
          Saving a new workbook
        • Lecture6.2
          Closing a workbook
      • Working with the Auto Fill tool 5

        • Lecture7.1
          Using Auto Fill with text
        • Lecture7.2
          Using Auto Fill with numbers and text with numbers
        • Lecture7.3
          Using Auto Fill with dates
        • Lecture7.4
          Controlling the series increment
        • Lecture7.5
          Filling cells with data using CTRL + Enter
      • Using formulas and functions 10

        • Lecture8.1
          Understanding and entering formulas
        • Lecture8.2
          Understanding functions and function syntax
        • Lecture8.3
          Understanding the SUM function
        • Lecture8.4
          Using the SUM function
        • Lecture8.5
          Using AutoSUM
        • Lecture8.6
          Editing formulas or functions
        • Lecture8.7
          Using Auto Fill with formulas or functions
        • Lecture8.8
          Understanding relative cell referencing (must-know!)
        • Lecture8.9
          Understanding absolute cell referencing (must-know!)
        • Lecture8.10
          Using the Insert Function command
      • Formatting data 16

        • Lecture9.1
          Applying the thousands separator and decimal places to numbers
        • Lecture9.2
          Applying the accounting or currency format to numbers
        • Lecture9.3
          Applying the percentage format to numbers
        • Lecture9.4
          Applying or changing a date format
        • Lecture9.5
          Changing the font
        • Lecture9.6
          Changing the font size
        • Lecture9.7
          Applying the bold effect
        • Lecture9.8
          Applying the italic effect
        • Lecture9.9
          Applying the underline or double underline effect
        • Lecture9.10
          Hiding and unhiding columns or rows
        • Lecture9.11
          Changing the fill color of cells or the font color of text
        • Lecture9.12
          Creating a custom fill color for cells or a custom font color for text
        • Lecture9.13
          Applying borders to a cell or range
        • Lecture9.14
          Applying borders using the Draw Border option
        • Lecture9.15
          Applying borders using the Border dialog box
        • Lecture9.16
          Using the Mini toolbar to format your data and cells
      • Essential keyboard shortcuts 4

        • Lecture10.1
          Essential keyboard shortcuts for selecting cells
        • Lecture10.2
          Essential keyboard shortcuts for entering data
        • Lecture10.3
          Essential keyboard shortcuts for working with rows and columns
        • Lecture10.4
          Essential keyboard shortcuts for formatting your data

        Inserting a new worksheet

        Prev Inserting new cells using right click on the mouse
        Next Renaming a worksheet

        Leave A Reply Cancel reply

        Your email address will not be published. Required fields are marked *

        All Courses

        • Adobe
        • IT & Software
        • Microsoft
        • Popular
        • Social Media

        Latest Courses

        Microsoft Excel 2016 Intermediate Level 1

        Microsoft Excel 2016 Intermediate Level 1

        Free
        Microsoft Excel Macros & VBA Beginner Level 3

        Microsoft Excel Macros & VBA Beginner Level 3

        Free
        Microsoft Excel Macros & VBA Beginner Level 2

        Microsoft Excel Macros & VBA Beginner Level 2

        Free

        Copyright 2020 ontrackTV - A division of Quizam Media Corporation

        • Sign in

        Forgot your password?

        Lost your password? Please enter your email address. You will receive mail with link to set new password.

        Back to login

        Login with your site account

        Lost your password?