Microsoft Excel 2013 / 2010: Level 1
Microsoft Excel 2013 / 2010 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.
With our extensive knowledge of the different software currently on the market, including all Microsoft and Adobe applications, ON-TRACK Corporate Training Ltd. has a diverse and flexible schedule that can be customized to your needs – we offer group course (both public and corporate), one-on-one training, and on-site training options. We also have easily accessible on-line training videos available.
Duration: 1 Day
Objectives
- 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
Prerequisites
- A thorough understanding of the Windows operating environment
- Strong mouse and keyboard ability
Outline
- Excel Essentials
- Starting Excel
- What is a Worksheet?
- What is a Workbook?
- Identifying Parts of the Screen
- Identifying the ribbon Components
- Getting Help
- Using Selection Techniques
- Selecting a Range of Cells
- Selecting Nonadjacent Cells and Ranges
- Selecting an Entire Worksheet
- Entering Data
- Entering Text Data into a Cell
- Entering Values
- Entering Data into a Range
- Quickly Adjusting a Column Width
- Finishing a Workbook
- Saving a Named Workbook
- Saving the Workbook in HTML Format
- Printing a Worksheet
- Closing a Workbook and Exiting from Excel
- Formatting Text & Printing a Document
- Opening a Workbook
- Creating a New Workbook
- Opening a Recently Used Workbook
- Creating Simple Formulas
- Creating a Formula by Pointing
- Using Functions
- Using the AutoSum Button
- Using the Formula Palette
- Editing Data on the Worksheet
- Editing the Data in a Cell
- Editing a Formula
- Clearing the Contents from a Cell or Range
- Using Undo and Redo
- 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
- Performing a Simple Sort
- Creating and Using Named Ranges
- Automatically Naming Ranges
- Navigating with Named Ranges
- Using Range Names in Formulas
- Pasting a List of Named Ranges
- Deleting and Editing Range Names
- Creating Named Constants
- Formatting the Worksheet
- Moving and Copying Data
- Copying Data
- Copying Data with AutoFill
- Creating a Series with AutoFill
- Defining Relative, Mixed, and Absolute References
- Copying Formulas
- 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