Excel for Beginners

Module 1 – Getting to know Microsoft Office Excel
[private]

• Excel Working environment: Ribbon, Tabs and Groups.
• Definition of workbook, worksheet, column, row, and cell
• Creating a new workbook
• Enter data
• Changing row height, column width
• Save a workbook
• Open an existing workbook

[/private]
Module 2 – Create worksheets and workbooks
[private]

• Creating new blank workbooks
• Creating new workbooks using templates
• Adding worksheets to existing workbooks
• Copying and moving worksheets

[/private]
Module 3 – Formatting Text in a worksheet
[private]

• Apply bold, change font size, font, italic, underline
• Apply borders, fill color
• Text alignment
• Special data formats: currency, social security number, phone number, zip code
• Insert pictures
• Change a worksheet background

[/private]
Module 4 – Format worksheets and workbooks
[private]

• Changing worksheet tab color
• Changing worksheet order
• Modifying page setup
• Inserting and deleting columns and rows
• Changing workbook themes
• Adjusting row height and column width
• Inserting headers and footers

[/private]
Module 5 – Customize options and views for worksheets and workbooks
[private]

• Hiding worksheets; hiding columns and rows
• Customizing the Quick Access toolbar
• Customizing the Ribbon
• Changing workbook views
• Using zoom
• Freezing panes
• Splitting the window

[/private]
Module 6 – Configure worksheets and workbooks to print or save
[private]

• Setting a print area
• Printing individual worksheets
• Setting print scaling
• Repeating headers and footers
• Configuring workbooks to print

[/private]
Module 7 – Insert data in cells and ranges
[private]

• Appending data to worksheets
• Finding and replacing data
• Copying and pasting data
• Using AutoFill, FillSeries, AutoComplete tool
• Expanding data across columns
• Inserting and deleting cells

[/private]
Module 8 – Format cells and ranges
[private]

• Merging cells
• Modifying cell alignment and indentation
• Changing font and font styles
• Using Format Painter
• Wrapping text within cells
• Applying highlighting
• Applying cell styles
• Changing text to wordart

[/private]
Module 9 – Create a chart
[private]

• Creating charts and graphs
• Adding additional data series
• Switching between rows and columns in source data
• Using Quick Analysis

[/private]
Module 10 – Format a chart
[private]

• Adding legends
• Resizing charts and graphs
• Modifying chart and graph parameters
• Applying chart layouts and styles
• Positioning charts and graphs

[/private]