Training PC Applications Series: Spreadsheets – 2 days

Class overview :

After taking this course, the learner will be able to work with a spreadsheet application to insert and manipulate data. The learner will also be able to create formulas and functions, format and print a spreadsheet, import objects, and create and adjust charts.

Class goals :

  • Open, revise, close, and print a spreadsheet
  • Insert, select, copy, move, and delete data
  • Search, replace, sort, and format data
  • Use, create, and copy both formulas and functions (e.g., SUM, AVERAGE, and IF)
  • Import an object and text file into a spreadsheet
  • Create, adjust, move, and delete a chart

Content of PC Applications Series: Spreadsheets

  • Opening and closing spreadsheets
  • Creating and saving spreadsheets
  • Using help
  • Adjusting settings
  • Cells
  • Rows and columns
  • Editing data
  • Copying data
  • Moving and deleting data
  • Find and replace
  • Sorting data
  • Handling worksheets
  • Working with formulas
  • Cell referencing
  • Working with functions
  • The IF function
  • Formatting numbers and dates
  • Formatting cell contents
  • Working with alignments and border effects
  • Creating charts and graphs
  • Editing charts and graphs
  • Worksheet setup
  • Printing worksheets
PC Applications Series
Training PC Applications Series

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s