• 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

      Microsoft Excel 2016 Beginner

      User Avatar
      Sarah
      IT & Software, Microsoft, Popular
      (0 review)
      Free
      Register for an account
      • Curriculum
      • Instructor
      • Reviews
      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
      author avatar
      Sarah
      Sarah has been teaching for over two decades in all areas spanning IT with a particular focus on data management and business intelligence. She is one of the most demanded instructors in the nation, and is reputed for her ability to share her deep knowledge in a clear, thorough, and engaging format. We promise you'll love her videos which students have evaluated as some of the best ones online!

      Reviews

      Average Rating

      0
      0 rating

      Detailed Rating

      5 Star
      0%
      4 Star
      0%
      3 Star
      0%
      2 Star
      0%
      1 Star
      0%
      • Share:

      You May Like

      Building Your Social Media Presence – Instagram Read More
      Georgia

      Building Your Social Media Presence - Instagram

      129
      0
      Free
      Build a Great Presentation in Microsoft PowerPoint Read More
      Dave

      Build a Great Presentation in Microsoft PowerPoint

      221
      0
      Free
      Conditional Analysis for Power Excel Users Read More
      Dave

      Conditional Analysis for Power Excel Users

      218
      0
      Free
      What-If Analysis for Power Excel Users Read More
      Dave

      What-If Analysis for Power Excel Users

      276
      0
      Free
      Lists and Pivot Tables for Power Excel Users Read More
      Dave

      Lists and Pivot Tables for Power Excel Users

      307
      1
      Free

      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?