Getting the Most From Microsoft Excel

• Navigate the Excel interface — the Quick Access Toolbar, ribbon, formula bar, editing area and status bar
• Recognize the three unbreakable rules of worksheets
• Master the three essential elements needed for effective workbook creation
• Utilize Excel’s updated help system to find answers and solutions more easily

• Triple your speed with essential keyboard shortcuts for data entry
• Ensure a consistent look within your workbook by standardizing with built-in cell styles
• Solve common printing problems
• Create custom views to preserve print settings — so you don’t have to reformat worksheets every time you print
• Generate a well-structured, scalable and sustainable workbook

• Learn the must-know shortcuts and functions for power users
• Get work done faster using keyboard shortcuts and speed keys
• Expand your skills with CONVERT, COUNTIFS and SUMIFS
• Analyze data by consolidating data sets from different sheets
• Construct PivotTable reports from tabular data

• Select the best chart type for your data
• Understand the fastest way to build a chart
• Customize standard charts with trendlines and custom settings
• Use sparklines to make your workbook data more visual
• Apply custom number formatting and conditional formatting to data visualizations

You’ll also receive the Microsoft Excel for Office 365 Tool Kit, a robust reference guide containing helpful shortcuts and a glossary of Excel terms.