Course Code: eximfhr
Duration: 14 hours
Prerequisites:

Knowledge of the Windows system and the basics of the Ms Program Excel

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

HR:

  • Vlookup and xlookup between sheets, files and on the same sheet,
  • Right, Left,
  • Cell Formating – Data, Number, General, Text,
  • Remove Duplicates,
  • Find and Replace,
  • Copy Formulas, Past as Text, Paste Vertical,
  • Pivot Tables,
  • Sorting by Colors, Headers, etc
  • Freeze Panes,  
  • Group,
  • Format Painter,
  • Excel Shortcuts,
  • Excel Arrays,
  • Copying and pasting,
  • Hiding Columns and Rows