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
()
Control inputs with Data Validation
()
2. Formatting Tips
Distinguish information with custom formatting
()
Interact with the web using hyperlinks
()
Identify standouts with conditional formatting
()
3. Customizing Workbooks
File naming on the fly
()
Get organized by customizing tabs
()
4. Working with Charts and PivotTables
Create PivotTables in just a few clicks
()
Create PivotCharts in just a few clicks
()
5. Collaborating with Excel for the Web
Engage with collaborators by assigning tasks
()
Customize your view of a file with Sheet View
()
Share files with collaborators
()
Protect your work by setting permissions
()
Coauthor in real time
()
6. 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
()
7. Using Advanced Features
Unlock the power of AI using Excel Ideas
()
Find out even more with Workbook Statistics
()
Save time with scripts
()
Conclusion
Put your learnings into action
()
Ex_Files_Excel_for_the_Web_Tips_and_Tricks.zip
(204 KB)