Microsoft Excel 501 – Microsoft Excel Bootcamp

In this 3-day comprehensive Bootcamp, Students will grasp:

• Creating and modifying workbooks and worksheets
• Working with data and Excel tables
• Managing worksheet data
• Reordering and summarizing data
• Combining data from multiple sources
• Analyzing alternative data sets
• Creating charts and graphics
• Understanding Pivot Tables
• Printing and sharing workbook
• Using formulas that span multiple worksheets
• Consolidating data
• Enabling iterative calculations
• What-if analyses
• Using the Scenario Manager
• Use financial functions
• Removing duplicates, sorting data, filtering data, adding subtotals to a list, grouping and ungrouping data in a list
• Working with clip art, SmartArt, and shapes
• Creating a Custom Chart Template
• Inserting Charts
• Insert a text box and objects
• Format data as a table
• Moving between tables and ranges
• Defining titles
• Applying conditional formatting
• Working with styles
• Creating and modifying templates
• Using the chart and analysis tools
• Creating pivot tables and charts
• Working with pivot tables and advanced functionality
• Auditing worksheets
• Tracing precedents and dependents
• Audit formulas
• Linking to external data
• Consolidating data
• Protecting Students data, passwords, and other security options
• Tracking and accepting changes
• Recording, running and editing macros
• Integration with Word and exporting data