Course Objectives
After completing this course, students will be able to:
- Identify basic worksheet and workbook concepts and terms
- Enter & edit data
- Modify the worksheet
- Use functions to calculate and return values
- Format cells to enhance the appearance of your worksheet
- Use drawing features and other enhancements
- Change the page set-up to define how the printed worksheet appears
Who Should Attend?
Microsoft Excel 2019 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.
Pre-requisite
Delegates should have an understanding of any of the following operating systems: Windows 98/NT/2000/XP/VISTA/WINDOWS 8.
Course Outlines
- Getting Started
- Creating a New Workbook
- Parts of a Workbook
- Saving a Workbook
- Opening a Workbook
- Selecting Data
- Entering and Deleting Data
- Using Undo and Redo
- Using Cut, Copy, and Paste
- Inserting Rows and Columns
- Merging and Splitting Cells
- Moving Cells
- Using Paste Special
- Using Find and Replace
- Hiding and Unhiding Cells
- Understanding Cell References and Formulas
- Using Basic Formulas
- Using Basic Functions
- Using Advanced Functions
- Using Spell Check
- Using AutoFill
- Using Flash Fill
- Using AutoSum
- Using AutoComplete
- Using AutoCalculate
- Changing the Font Face, Size, and Color
- Applying Text Effects
- Applying Borders and Fill
- Using the Font Tab of the Format Cells Dialog
- Clearing Formatting
- Wrapping Text
- Changing the Size of Rows and Columns
- Adjusting Cell Alignment
- Changing Text Direction
- Changing Number Format
- Using Cell Styles
- Formatting Data as a Table
- Changing the Theme
- Inserting Page Breaks
- Adding a Background
- Using Views
- Saving a Workbook as PDF or XPS
- Printing a Workbook
- E-Mailing a Workbook
- Changing Ribbon Display Options
- Customizing the Quick Access Toolbar
- Hiding and Showing Ribbon Tabs
- Creating Custom Ribbon Tabs
- Resetting Interface Changes