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
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, …
Training-brussels - business training center in Brussels 