Our training
Trainer's video
Coming soon
Excel 2010
Excel is a spreadsheet program that allows you to create and print tables, make automatic calculations, analyze data and produce graphics.
After this training, participants will be able to build and format tables, use formulas and make simulations, format data, databases and dynamic cross tables, use pre-programmed commands and utilities, protect and conceal data, create and manage a multi-page workbook and a database, use the management tools, analyze data from large sheets of calculations, use graphics, customize layouts and more.
Objectives
Here are all of the themes encompassing the whole training. For a 3-hour bloc, 4-5 themes can be viewed.
Excel 2010 environment
-
- Work Environment
- Configuring Windows
- Training Files
- Spreadsheet
- Microsoft Excel 2010
- Launch Excel 2010
- Screen Excel 2010
- Toolbar customized Quick Access
- Personalized Ribbon
- Keyboard Shortcuts
- Help
Getting started with Excel
-
- Content of a cell
- Direction of movement of the pointer
- Data Entry
- Managing Documents
- Travel in the active sheet
- Zoom Display
- Selecting Cells
- Editing data
- Cancellation and return an operation
- Copying and moving
- Office Clipboard
- Automation of entries
- Incremented Series
- Custom List
Formulas
-
- Example Binder
- Structure of a leaf
- Entering a formula
- Identification of cells linked to a formula
- Priorities calculation
- Types Reference
- Automatic Adding Formulas
- Removing zero values
- Display formulas
- Copy of the outcome of formulas
- Report the contents of a cell
- Comment
Formatting data
-
- Example Binder
- Tools formatting
- Fonts and attributes
- Border
- Filling
- Alignment
- Repeat the contents of a cell
- Rotation of a given
- Display Format numbers
- Column Width
- Inserting and deleting cells, rows or columns
- Row Height
- Conditional Formatting
- Styles
- Reproduction of the formatting
- Privacy
- Hiding the wording of a formula
- Hiding rows and columns
Layout and Printing
-
- Example Binder
- Print Preview
- Display Modes
- Margins
- Centering the page
- Orientation
- Paper Size
- Print Area
- Page Breaks
- Background
- Print Titles
- Scaling
- View and / or print the grid
- View and / or print titles
- Header or Footer
- Printing
- Printing comments
Statistical functions, date & time
-
- Example Binder
- Function Syntax
- Statistical functions
- Functions Date & Time
- Track name
Financial Functions
-
- Example Binder
- Financial Functions
- Periodic reimbursement for a loan
- Interest paid on a specific payment
- Principal paid on a specific payment
- Future value of a periodic investment
- Future value of a single investment
- Current value of a series of future payments
- Number of Payments to repay a debt
- Total deposits to accumulate an amount
- Number of times to achieve the desired value
Logic and research
-
- Logic SI
- Example Binder
- Comparison operators and logical functions
- Search function VLOOKUP
- Example Binder
Data List
-
- Example Binder
- Organization of a data list
- Sorting
- Filter
- Advanced Filter
- Functions Database
- Calculations by dataset
Tools
-
- Example Binder
- Formula Auditing
- Example Binder
- Display cabinet
- Window Management
- congealing shutters
- Splitting a window
- Example Binder
- Distribution of cell contents
- Remove duplicate
- Data Validation
- Scenario Manager
- Target Value
- Data Table
- Exchange of data
Multi-sheet workbooks
-
- Example Binder
- Management of sheets in a workbook
- Consolidation
- Dynamic Data Link
- Workspace
Graphics
-
- Example Binder
- Graphics
- Formatting graphic
- Chart Sparkline
- PivotTable
- PivotChart
Graphic objects
-
- Example Binder
- Graphic Objects
- Insert Image
- Smart Art Graphic
- Hypertext links
- Text Box
- WordArt Object
- Symbol / Special Characters
- Organizing objects
- Rotate or flip objects
- Size of the object
-
Learners
-
The courses are for all individuals and businesses.
Trainer
Ghazi Jait is a trainer with more than 10 years experience in administrative and graphique design softwares either as a user or as a trainer.
He offers group and private courses to people and companies in many field but most happens to be in the field of print and web communications. He also collaborated with other training centers.
After completed his training at LaSalle College in graphic design and multimedia, he started to work as a graphic designer for various companies. From there, his passion for training took over and he is offering his courses either in company, in our public sessions where all are welcome to attend or via videoconferences where distance is not a problem.
Finally, M. Jait continuously keeps his knowledge up to date by taking refresher courses offered by the software producers or by doing Internet search to complete the various mandates that he undertake.
Languages
Training is available in French only.
How can you take this training?
1
Public session*
This training will not be available for Winter-Spring 2018.
2
Webinar
Some of our courses are available online. This course will not be available for Winter-Spring of 2018.
3
In your business
Our teachers can train at your place of business. For more information, contact us* Thank you for considering our trainings. We wish to inform you that public courses require a minimum number of participants which may vary according to the training. If this number is not reached, the course may be cancelled or postponed to a later date. Moreover, the training location could be modified. If such a change were to occur, you would be notified at least 48 hours in advance.
Other training offered by the same trainer
- - 3D Studio Max
- Adobe Premiere - - After Effect
- - Dreamweaver
- - Excel 2010
- - Fireworks
- - Flash
- - Illustrator
- - In Design
- - Outlook
- - Photoshop
- - Power Point
- - Word 2010
All our training can be tailored to your specific needs
If our regular training does not fit your corporate needs, we can adapt our offering to meet your objectives or elaborate a personalized training plan. Do not hesitate to contact us to let us know about your requirements.