Lamiae
Cours Microsoft Excel 2010, tutoriel et guide complet Excel pdf.
Workshop Information
Learning Outcomes
Format
Additional Resources
Help
Feedback
3D Referencing
Create a 3D Reference
Exercise Data Tables – One Input tables
Named Ranges
Creating named ranges using the name box
Naming a selected range
Creating multiple names from a selection
Moving to a name
Inserting a name into a Formula
Make a name refer to a value
Named ranges exercise
Sub Totals
Sub totalling data
Exercise Subtotals
Text Functions
Manipulate text
Exercise text manipulation
Exercise concatenation
Data Tables
One-variable data table
Two variable data table
Exercise – One input table
Exercise – Two input table
Data Form
Add Form button
Using data forms
The Form Window
Exercise – Data Forms
Consolidation
Consolidate Multiple Ranges
Exercise consolidation
Formula Auditing
Formula auditing tools
Comments
Evaluate formula
Watch window
Goal Seek
Goal seek introduction
Using goal seek
Exercise Goal Seek
Group and Outline Data
Group and outline introduction
Auto Outline
Group
Exercise Auto Outline
Exercise Manual Outline
Scenarios
Creating Scenarios
Editing Scenarios
Creating Scenario Reports
Using Scenario Manager
Exercise Scenarios
Lookup – Vlookup
Using VLookup
More Information on Vlookup
Exercise Vlookup
Exercise 2 Vlookup
……..
