Get in Touch
 Duration 14 hours

Course Outline

Editing Spreadsheets

  • Modifying cell contents
  • Inserting and deleting cells
  • Duplicating cells
  • Using Copy and Paste commands
  • Utilizing the fill handle
  • The Fill command
  • Series data and the Autofill option
  • Duplicating formulas
  • Relative and absolute references
  • Mixed references
  • Relocating cells
  • The Office Clipboard
  • Recalling, repeating, and redoing operations

Managing Workbooks

  • Excel file management
  • Spreadsheet workbooks
  • Windows workbook integration
  • Saving files to disk
  • Opening existing workbooks

Applying Functions in Formulas

  • Introduction to functions
  • Structure of formulas
  • Function arguments
  • Inserting functions
  • Mathematical and trigonometric functions
  • Statistical functions
  • Logical functions
  • Lookup and reference functions
  • Information functions
  • Date and Time functions
  • Text functions

Cell Formatting

  • Number formatting
  • Alignment options
  • Font styling
  • Border configuration
  • Cell shading
  • Styles
  • Conditional formatting
  • Using the Format Painter
  • Optimizing column width and row height
  • AutoFit settings
  • AutoFormat tools
  • Clearing cell formatting

Handling Graphic Objects

  • Graphical elements
  • Using the Drawing toolbar
  • Creating drawing objects
  • Inserting images
  • Manipulating graphics
  • Arranging the order of graphic objects

Chart Creation

  • Understanding charts
  • The Chart wizard
  • Chart source data
  • Data series and data points
  • Chart components
  • Varying chart types
  • Chart options
  • Chart titles
  • Axes
  • Gridlines
  • Legend placement
  • Data labels
  • Adding data tables

Printing

  • Printing process
  • Page Setup dialog
  • Print preview
  • Printing dialog box

Leveraging Lists

  • Working with lists
  • Converting list ranges
  • Creating form applications
  • AutoFilter functionality
  • Advanced filters
  • Data sorting
  • Subtotals
  • Database functions

Pivot Tables

  • Creating and modifying PivotTables
  • Calculated fields and members

Requirements

Familiarity with Windows

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories