Excel Essentials Part 2
On-Track is excited to offer LIVE virtual training classes to our beloved students. Enjoy all the benefits a live expert instructor from the comfort of your own home or office computer.
Please contact us at learn@on-track.com to receive additional information about our virtual classes and training platform.
Duration: Half Day (3.5 hours)
COURSE OUTLINE
- Discovering the Power of AutoFill
- Copying Data with AutoFill
- Creating a Series with AutoFill
- Understanding Formulas and Functions
- Mathematical Precedence in Excel
- Creating Simple Formulas
- Editing a Formula
- What is a Function?
- Understanding Function Syntax
- Using the SUM Function
- Using AUTOSUM
- Copying Formulas
- Defining Relative and Absolute Referencing
- Naming Ranges
- Creating a Named Range
- Navigating with Named Ranges
- Using Named Ranges in Formulas
- Editing or Deleting Named Ranges
- Pasting a List of Named Ranges
- Linking Data
- Copying Data VS Linking Data
- Linking Data Between Worksheets
- Linking Data Between Workbooks
- Using Comments
- Adding Comments to a Worksheet
- Reviewing, Showing, and Hiding Comments
- Deleting Comments
- Printing
- Changing Orientation
- Scaling to Fit
- Selecting Paper Size and Print Quality
- Changing Margins and Alignment
- Adding a Header and Footer
- Using Print Areas
- Setting Print Titles
- Printing Gridlines, Row & Column Headings
- Printing Comments
- Adjusting Page Order
- Working with Page Breaks