Course Outline

Basic information about the program Excel

  • Data Types Excela – How Excel treats date and time
  • Searching for values in a spreadsheet - Find and select
  • Sheet protection
  • Data correctness
  • Creating a data series
  • Autocorrect
  • Instant filling
  • Go to special
  • Paste specially
  • Text as columns
  • Quick access bar
  • Good practices for creating sheets
  • Keyboard shortcuts
  • Format a cell
  • Conditional formatting

Creating formulas

  • Inserting functions
  • Edit formulas
  • Logical functions
  • Mathematical functions
  • Search Functions
  • Text functions
  • Date and time functions
  • Sum the contents of cells using the AutoSum button
  • Adding features using the dialog box
  • Estimating a formula
  • Determining the location of values
  • Naming the scope
  • Modify named ranges
  • Using named ranges in formulas

Creating a pivot table

  • Basic information about pivot tables
  • Overview of PivotTable report fields

Creating charts and pivot charts

  • Creating pivot charts
  • Changing the chart type

Requirements

Knowledge of Windows and the basics of MS Excel

  14 Hours

Testimonials (7)

Related Courses

Related Categories