Limited space is still available for the December 13 session. Please call Leila at 613-234-2020 ext. 18 to check availability and to register.
Please note new location for this course.
Microsoft Excel is the preferred spreadsheet software for many individuals and businesses to manage their data and reporting. Yet most are only using 20% of the features of this powerful productivity tool.
During this intermediate program you will learn and practice higher level Excel functionality to further make sense of spreadsheets and larger data sets. By using hands-on practical techniques you will be able to analyze complex data sets, organize and visualize data in simple meaningful terms, faster data list management and querying and working with corporate and personal templates.
This is a one-day workshop in Ottawa.
Space is still available for all course dates listed, unless otherwise noted.
By the end of this seminar, you will be able to:
Build on basic skills to manipulate data ranges, in worksheets and formulas
Create, manage and work with templates to reduce repetitive work
Apply advanced formatting techniques to workbooks an worksheets
Work with data to sort, analyze, query and link data
Design effective visuals for immediate effect
Protect and share your workbook with others
Please follow and like us:
Using ranges in formulas
Working with Excel templates
Saving, using and changing templates
Advanced Excel Formatting
Advanced worksheet formatting
Sorting and Querying Data
Understanding data through sorting
Understanding data using query
Organizing data across multiple worksheets
Creating summary views
Working with chart types
Creating, using and saving charting templates
Collaborate on Workbooks in New Ways
Improved Excel services
Protection and Sharing
Protection of workbooks and worksheets
Sharing of workbooks with individuals and groups
Register for this workshop
Once you register the first attendee, you’ll have the ability to add additional attendees or purchase other workshops