Excel 2013 Tips and Tricks

Learn how to get more out of Excel for the web (also known as Excel Online), the browser version of the spreadsheet app from Microsoft.

Introduction

• Be more productive with Excel for the web
• Exercise files

1. Working with Data

• Get started with data
• Data cleanse using Remove Duplicates
• Add data quickly with Flash Fill
• Simplify views with Groupings
• Think ahead by using Tables

2. Doing even more with Data

• Control inputs with Data Validation
• Become more efficient with Excel functions
• Create data from a picture
• Convert unstructured text to columns
• Apply Custom Sorting
• Work with styles

3. Formatting Tips

• Distinguish information with custom formatting
• Interact with the web using hyperlinks
• Identify standouts with conditional formatting

4. Customizing Workbooks

• File naming on the fly
• Get organized by customizing tabs
• Achieve the perfect pagination

5. Working with Charts and PivotTables

• Create PivotTables in just a few clicks
• Create PivotCharts in just a few clicks
• Refresh data
• Create and optimize standard Excel visuals

6. Collaborating with Excel for the Web

• Engage with collaborators by assigning tasks
• Coauthor in real time

7. When to Work in Excel Desktop

• Use Excel desktop to enhance charts
• Use Excel desktop to add slicers to PivotCharts
• Set up range names in Excel desktop

8. Using Advanced Features

• Find out even more with Workbook Statistics
• Assess workbook performance
• Save time with scripts

Conclusion

• Put your learnings into action