Warning: Declaration of ET_Theme_Builder_Woocommerce_Product_Variable_Placeholder::get_available_variations() should be compatible with WC_Product_Variable::get_available_variations($return = 'array') in /home/customer/www/cheltenhamcourseware.com.au/public_html/wp-content/themes/Divi/includes/builder/frontend-builder/theme-builder/WoocommerceProductVariablePlaceholder.php on line 8
Microsoft Excel 2010 Intermediate Training Courseware

Microsoft Excel 2010 Intermediate Training Materials

Courseware Training Materials

Training Course Outline

Setup & Printing Issues

  • Worksheet Margins
  • Worksheet Orientation
  • Worksheet Page Size
  • Headers and Footers
  • Header and Footer Fields
  • Scaling Your Worksheet to Fit a Page(s)
  • Printing Titles On Every Page
  • Printing the Row and Column Headings
  • Spell Checking
  • Previewing a Worksheet
  • Viewing Workbooks Side By Side
  • Printing Options

Functions and Formulas

  • Getting Help With Functions.
  • Nested Functions.
  • Consolidating Data using a 3-D Reference Sum Function.
  • Mixed References within Formulas.

Time & Date Functions

  • TODAY.
  • NOW.
  • DAY.
  • MONTH.
  • YEAR.

Mathematical Functions

  • ROUND.
  • ROUNDDOWN.
  • ROUNDUP.

Logical Functions

  • IF.
  • AND.
  • OR.

Mathematical Functions

  • SUMIF.

Statistical Functions

  • COUNT.
  • COUNTA.
  • COUNTIF.
  • COUNTBLANK.
  • RANK.

Text Functions

  • LEFT.
  • RIGHT.
  • MID.
  • TRIM.
  • CONCATENATE.

Financial Functions

  • FV.
  • PV.
  • NPV.
  • RATE.
  • PMT.

Lookup Functions

  • VLOOKUP.
  • HLOOKUP.

Database Functions

  • DSUM.
  • DMIN.
  • DMAX.
  • DCOUNT.
  • DAVERAGE

Named Ranges

  • Naming Cell Ranges.
  • Removing a Named Range.
  • Named Cell Ranges and Functions.

Cell Formatting

  • Applying Styles to a Range.
  • Conditional Formatting.
  • Custom Number Formats.

Manipulating Worksheets

  • Copying or Moving Worksheets
  • Splitting a Window.
  • Hiding Rows, Columns & Worksheets.

Templates

  • Creating Excel Templates.
  • Editing Excel Templates

Paste Special Options.

  • Using Paste Special to Add, Subtract, Multiply & Divide.
  • Using Paste Special ‘Values’.
  • Using Paste Special Transpose Option.

 

Call Now Button