Basic Microsoft Excel

COURSE OBJECTIVES
You Will Learn How To:

• Summarize data with Excel by incorporating formulas, formatting, and charts and graphs
• Optimize your worksheets using templates, graphs and formulas
• Design simple to complex formulas by nesting Excel functions
• Import, fine-tune and share Excel data
• Create, manage and launch macros

COURSE CONTENT
Introduction to Microsoft Excel
The spreadsheet model
• Worksheets and their contents
• Differentiating workbooks and worksheets
Navigating the interface
• The Ribbon
• Customizing the interface
• Managing large spreadsheets by zooming
• Identifying worksheet tabs by color
• Changing worksheet views
Basic data editing
• Modifying cell contents and formats
• Inserting data with AutoFill
• Knowing when to use Paste Special
Acquiring and Conforming Data
Importing data from outside sources
• Integrating data from other Excel sheets
• Utilizing data from servers
• Managing external links
• Finding and removing duplicates
Excel tables and lists
• How Excel tables work
• Converting text to columns
• Sorting and grouping table data
• Adding data in a table or list
Worksheet Formatting and Presentation
Initial formatting
• Configuring cell numeric formats
• Aligning data within cells
• Fitting cells to data size
• Naming cells and cell ranges
Worksheet presentation
• Freezing worksheet areas
• Hiding content in worksheets
• Editing, modifying and saving templates
Innovative formatting
• Styling cells and sheets with prebuilt styles
• Conditionally formatting cells and data
• Rotating and wrapping text
Leveraging Formulas and Functions
Formula basics
• Performing simple calculations
• Specifying relative and absolute cell references
• Examining formulas with the auditing tools
• Concatenating text with the & operator
• Introducing functions with the Wizard and Formula tabs
• Working with statistical functions: SUM, MAX, MIN, COUNT and COUNTA
Cleaning up data and manipulating data further
• Utilizing TRIM, UPPER, LOWER LEFT and RIGHT MID functions
• Manipulating dates with YEAR, MONTH, DAY and TEXT functions
• Nesting formulas to perform multiple functions
• Defining and utilizing names in formulas
• Working with data in advanced formulas
Creating a Visual Presentation of Data
Charting your data
• Determining when charts are required
• Creating and modifying charts with wizards
• Adjusting chart layouts, title and labels
Printing workbooks
• Setting options on the Page Layout tab
• Viewing and adjusting page breaks
• Developing appropriate headers and footers
Introducing Advanced Excel Features
PivotTable basics
• Creating a PivotTable with wizards
• Pivoting existing PivotTable data
Final workbook touches
• Reviewing and adding comments on worksheets
• Protecting and sharing worksheets
• Tracking shared worksheet changes
Creating and managing macros
• Macro basics and when to use a macro
• Recording effective macros
• Launching macros from buttons