Overview:

Having trouble sorting columns or extracting specific data from columns in Excel?

Data can be sorted four different ways so dive into all of the options for sorting data the way you want to see it sorted. Learn to extract different data sets from a list and hide everything else. Use Outlining to hide or show different levels of data in columns and save them as Views to be pulled up quickly as needed.

This is an Online, Live presentation using Excel Office 365.

Why you should Attend: Unlock the power of Excel! If you are intimidated by spreadsheets or are struggling with how to get started, learning the basics of how Excel works will help ease that anxiety. Excel is used in marketing, sales, finance, or other relevant fields so once you can confidently set up columns and rows of data, you can then learn to analyze that data, create compelling spreadsheets, and automating tasks. Knowing how to use Excel to create dynamic spreadsheets will help boost your business and career to new heights.

Areas Covered in the Session:

• Sort data alphabetically, numerically, or by date
• Custom sorts
• Filtering data
• Creating Outlines
• Creating and saving Custom Views

Who Will Benefit:

• New Excel Users
• Anyone who has never had any formal training
• Anyone wanting to learn how a good foundation for creating nice looking professional spreadsheets