Microsoft Excel 365 / 2019 / 2016 Level 1
Microsoft Excel 365 / 2019 / 2016 combines a powerful spreadsheet application with the user-friendly atmosphere of Windows. Delegates will learn the basics of creating, editing, and saving worksheets in our Essentials level class. They will work with formulas and functions to calculate and return values. Delegates will learn to change the appearance of a page, including adding headers and footers, format data and create charts.
Duration: 1 Day
Objectives
- Identifying basic worksheet and workbook concepts and terms
- Entering and editing data
- Modifying the worksheet
- Using formulas and functions to calculate and return values
- Formatting cells to enhance the appearance of your worksheet
- Changing the page set-up to define how the printed worksheet appears
Prerequisites
- Comfortable using a computer running a Windows operating system
- Strong mouse and keyboard ability
Outline
- Excel Essentials
- Starting Excel
- What is a Worksheet?
- What is a Workbook?
- Identifying Parts of the Screen (Ribbon, Quick Access Toolbar, Status Bar)
- Getting Help
- Using Selection Techniques
- Selecting a Range of Cells
- Selecting Nonadjacent Cells and Ranges
- Selecting an Entire Worksheet
- Entering Data (Text, Numbers, Dates, Percentages)
- Entering Data into a Range
- Quickly Adjusting a Column Width
- Editing Data on the Worksheet
- Editing the Data in a Cell
- Clearing the Contents from a Cell or Range
- Using Undo and Redo
- Saving a Workbook
- Opening a Workbook
- Creating a New Workbook
- Opening a Recently Used Workbook
- Closing a Workbook and Exiting from Excel
- Managing the Worksheet
- Navigating in a Worksheet
- Using the Scroll Bars and Boxes
- Changing Worksheets
- Using Go To
- Changing the Worksheet Structure
- Deleting Cells, Rows, and Columns
- Moving and Copying Data
- Copying Data
- Copying Data with AutoFill
- Creating a Series with AutoFill
- Understanding Formulas and Functions
- Creating Simple Formulas
- Editing a Formula
- Using Functions
- Using AutoSum
- Using the Formula Palette
- Defining Relative, Mixed, and Absolute References
- Copying Formulas
- Formatting the Worksheet
- Changing the Appearance of Data
- Changing Row Height
- Applying Fonts
- Adding Enhancements
- Aligning Data in Cells
- Merging and Centering Cells
- Rotating and Indenting Text
- Adding Borders and Shading
- Using Drawing Tools
- Creating Graphic Objects
- Editing a Graphic Object
- Creating and Editing 3-D Objects
- Using Other Drawing Tool
- Printing the Worksheet/book
- Printing a Single Worksheet
- Using Print Preview
- Creating Headers and Footers
- Removing the Grid
- Printing a Selection
- Printing a Selection
- Using Print Areas
- Using Advanced Printing Techniques
- Aligning the Printout
- Fitting a Document onto a Desired Number of Pages
- Working with Page Breaks
- Working with Page Breaks in Normal View
- Setting Print Titles
- Removing Print Titles