MS Excel (2016, 2019, 365) – Level 2 (P250)

Effective Techniques to Manage Information with Excel (2016, 2019, 365)

This course will be delivered as a live, instructor-led session online – click here.

Microsoft Excel (2016, 2019, 365) 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 professional templates.

This is a one-day workshop in Ottawa.

Space is still available for all course dates listed, unless otherwise noted.

Learning Outcomes

By the end of this seminar, you will be able to:

  • Build on basic skills to manipulate data ranges
  • Use more advanced formulas and understand absolute referencing
  • Apply advanced formatting
  • Work with data to sort, analyze, filter and sub-total
  • Create charts
  • Protect worksheets

Print Friendly

Workshop Topics

Manipulating Data

  • Creating names
  • Using names in formulas

Advanced Excel Formatting

  • Advanced worksheet formatting
  • Conditional formatting

Querying Data

  • Table structure and data validation
  • Understanding data through sorting and filtering
  • Sub-totals

Linking Data

  • Organizing data across multiple worksheets
  • Creating summary views

Creating Visuals

  • Creating charts
  • Working with chart types
  • Creating, using and saving charting templates
  • Sparklines and Slicers

Protection and Sharing

  • Protection of workbooks and worksheets
  • Sharing of workbooks with individuals and groups

More Advanced Functions

  • Logical, statistical, date and time and percentages

Who Should Attend This Course?

Experienced MS Excel users who are frustrated by working with simple spreadsheets and charts and want to increase both their comfort and productivity with this versatile and powerful spreadsheet tool.

Does This Course Address Your Competency Development Needs?

This training workshop addresses:

• Achievement / Results Orientation
• Computer and Digital Technology
• Document Use
• Planning / Organizing
• Working with Data and Numbers