Duration
3 Days
Microsoft Office 2010
Course Objective:
The core-level Microsoft Office Excel 2010 user should be able to navigate Microsoft Office Excel 2010, Microsoft Office PowerPoint 2010 and Microsoft Office Word 2010 software at the feature and functional level. They should be familiar with and know how to use at least 80 percent of the features and capabilities of the Software.
Target Audience:
Users would include people from a wide variety of job roles from almost all areas of professional, student and personal life.
Managing the worksheet environment
- Navigate through a worksheet
- Print a worksheet or workbook
- Personalize environment by using Backstage
Creating cell data
- Construct cell data
- Apply AutoFill
- Apply and manipulate hyperlinks
Formatting cells and worksheets
- Apply and modify cell formats
- Merge or split cells
- Create row and column titles
- Hide and unhide rows and columns
- Manipulate page setup options for worksheets
- Create and apply cell styles
Managing worksheets and workbooks
- Create and format worksheets
- Manipulate window views
- Manipulate workbook views
Applying formulas and functions
- Create formulas
- Enforce precedence
- Apply cell references in formulas
- Apply conditional logic in a formula
- Apply named ranges in formulas
- Apply cell ranges in formulas
Presenting data visually
- Create charts based on worksheet data
- Apply and manipulate illustrations
- Create and modify images by using the Image Editor
- Apply Sparklines
Sharing worksheet data with other users
- Share spreadsheets by using Backstage
- Manage comments
Analysing and organising data
- Filter data
- Sort data
- Apply conditional formatting
Manage the PowerPoint environment
- Adjust views
- Manipulate the PowerPoint window
- Configure the Quick Access Toolbar (QAT)
- Configure PowerPoint file options
Create a slide presentation
- Construct and edit photo albums
- Apply slide size and orientation settings
- Add and remove slides
- Format slides
- Enter and format text
- Format text boxes
Work with graphical and multimedia elements
- Manipulate graphical elements
- Manipulate images
- Modify WordArt and shapes
- Manipulate SmartArt
- Edit video and audio content
Create charts and tables
- Construct and modify tables
- Insert and modify charts
- Apply chart elements
- Manipulate chart layouts
- Manipulate chart elements
Apply transitions and animations
- Apply built-in and custom animations
- Apply effect and path options
- Apply and modify transitions between slides
- Manipulate animations
Collaborate on presentations
- Manage comments in presentations
- Apply proofing tools
Prepare presentations for delivery
- Save presentations
- Share presentations
- Print presentations
- Protect presentations
Deliver presentations
- Apply presentation tools
- Set up slide shows
- Set presentation timing
- Record presentations
Sharing and maintaining documents
- Apply different views to a document
- Apply protection to a document
- Manage document versions
- Share documents
- Save a document
- Apply a template to a document
Formatting content
- Apply font and paragraph attributes
- Navigate and search through a document
- Apply indentation and tab settings to paragraphs
- Apply spacing settings to text and paragraphs
- Create tables
- Manipulate tables in a document
- Apply bullets to a document
Formatting content
- Apply font and paragraph attributes
- Navigate and search through a document
- Apply indentation and tab settings to paragraphs
- Apply spacing settings to text and paragraphs
- Create tables
- Manipulate tables in a document
- Apply bullets to a document
Applying page layout and reusable content
- Apply and manipulate page setup settings
- Apply themes
- Construct content in a document by using the Quick Parts tool
- Create and manipulate page backgrounds
- Create and modify headers and footers
Including illustrations and graphics in a document
- Insert and format pictures in a document
- Insert and format shapes, WordArt and SmartArt
- Insert and format Clip Art
- Apply and manipulate text boxes
Proofreading documents
- Validate content by using spelling and grammar checking options
- Configure AutoCorrect settings
- Insert and modify comments in a document
Applying references and hyperlinks
- Apply a hyperlink
- Create endnotes and footnotes in a document
- Create a table of contents in a document
Performing mail merge operations
- Set up mail merge
- Execute mail merge
Programme scope, delivery arrangements and suitability are confirmed during enquiry.