Sorting, Filtering and Outlining in Excel
Cindy McGuckin
Live: One Dial-in One Attendee
Corporate Live: Any number of participants
Recorded: Access recorded version, only for one participant unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)
Corporate Recorded: Access recorded version, Any number of participants unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)
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
Over her 15+ years of teaching software courses, Cindy has taught many large groups in classroom settings and remotely. She also works with individuals who need a little more of a personal touch. Her experience has helped her develop a unique ability to connect with her students and quickly assess their needs in order to customize their QuickBooks company file. She can tell very quickly which features of QuickBooks the she really needs to focus on, then gets the job done quickly and very efficiently.