BluescreenIT

Call us on +44 (0) 1752 724 000

Logo Excel2013

Course Duration

Each level is a One Day Course

 

Introduction Course Content - 1 Day

  • Add numbers in Excel 2010
  • Basic math in Excel
  • Create a chart
  • Create your first Excel 2010 workbook
  • Freeze or lock panes
  • Understand and use cell references
  • Use AutoFill and Flash Fill

 

Intermedia Course Content - 1 Day

  • Add or subtract time
  • Average a group of numbers
  • Insert headers and footers
  • Make the switch to Excel 2010
  • Sort and filter data
  • Take conditional formatting to the next level
  • Use conditional formatting
  • VLOOKUP: When and how to use it

 

Advanced Course Content - 1 Day

  • Advanced IF functions
  • Array formulas
  • Create and manage drop-down lists
  • Create a PivotTable and analyze your data
  • Password protect workbooks and worksheets
  • Print worksheets and workbooks
  • Work with macros

 

microsoft office

 

Excel 2010

Excel 2010

 

 

 

 

 

 

LeftSideLogo1

RightSideLogo1