This course will introduce you to spreadsheets and the foundation concepts of Microsoft Excel. Learn these features of Microsoft Excel and get more done quickly.

Objectives: You will learn how to: quickly set up workbooks, enter data, and format it for easier viewing, Perform calculations and find and correct errors, Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps and Print worksheets and charts

In This Course, Learn About: Calculations, Charts, Create workbooks, Enter and revise data, Excel Mobile Apps,Excel Online, Find and replace data, Formatting, Formulas, Graphics, Modify workbooks, worksheets, Printing, Set up a workbook, Sparklines.

Excel Versions That Can Attend: Excel 2019, 365, 2016, & 2013 (Microsoft Windows PC)

Course Taught With: Excel version 2016 (Microsoft Windows PC) Software.

Section 1:

  • Set up a workbook
  • Explore the editions of Excel 2016
  • Excel Mobile Apps
  • Become familiar with new features in Excel 2016
  • Create workbooks
  • Modify workbooks
  • Modify worksheets
  • Merge and unmerge cells
  • Customize the Excel 2016 app window
  • Zoom in on a worksheet
  • Arrange multiple workbook windows
  • Add buttons to the Quick Access Toolbar
  • Customize the ribbon
  • Skills review
  • Practice tasks

Section 2:

  • Work with data and Excel tables
  • Enter and revise data
  • Manage data by using Flash Fill
  • Move data within a workbook
  • Find and replace data
  • Correct and expand upon data
  • Define Excel tables
  • Skills review
  • Practice tasks

Section 3:

  • Perform calculations on data
  • Name groups of data
  • Create formulas to calculate values
  • Sidebar: Operators and Precedence

Section 4:

  • Change workbook appearance
  • Format cells
  • Define styles
  • Apply workbook themes and Excel table styles
  • Make numbers easier to read
  • Change the appearance of data based on its value
  • Add images to worksheets
  • Skills review
  • Practice tasks 143

Section 5:

  • Create charts and graphics
  • Create charts
  • Create new types of charts
  • Customize chart appearance
  • Find trends in your data
  • Create dual-axis charts
  • Summarize your data by using sparklines.
  • Create diagrams by using SmartArt
  • Create shapes and mathematical equations
  • Skills review
  • Practice tasks

Section 6:

  • Print worksheets and charts
  • Add headers and footers to printed pages
  • Prepare worksheets for printing
  • Fit your worksheet contents to the printed page
  • Change page breaks in a worksheet
  • Change the page printing order for worksheets
  • Print worksheets 337
    Print parts of worksheets
  • Print charts
  • Skills review