Excel - Beginners & Intermediate
Microsoft Excel is a powerful tool for analyzing data, and for making more informed business decisions. Specifically, Excel can track data, build models for data analysis, write formulas for performing calculations, pivot the data in numerous ways, and present the results in a variety of professional looking charts. In this workshop, you will learn to build a complete Excel application to expand your skills and enrich your resume.
EXCEL TRAINING VANCOUVER OVERVIEW
Confidential until registration: in our office in Kitsilano, Vancouver (BC) or in a meeting room located Downtown Vancouver (BC), depending on the number of attendees.
A step-by step workshop, featuring exclusive videos to help you develop your own application with MS Excel.
This intuitive and logical hands-on workshop will help you increase your overall understanding of MS Excel and create proper business reports, do sales tracking, perform calculations and more.
10 essential tools and more than 20 Excel functions.
This 2-day intensive course will provide concrete and practical exercises to help you build your own application, and apply your knowledge to your daily work with Ms Excel.
For instance, you will learn how to construct spreadsheets that refer to fixed cells containing constant values, such as sales tax or interest rate.
You will identify values exceeding a threshold; locate duplicates; highlight the current date in a calendar and apply coloring to alternating rows. You will also study how sorting products in ascending order based on units sold, filtering a list of clients by specific age groups.
The syllabus comprises 10 Excel essential tools:
1. Absolute and relative references
- Copy formulas by storing a fixed reference
2. Naming in Excel / Dynamic Named Ranges
- Improve the readability of formulas by using descriptive names
- Rapidly copy lists and formulas
4. Conditional Formatting
- Highlight unusual or important data by formatting cells based on their value
5. Formula Auditing
- Trace precedent and dependent cells
6. List Management
- View, filter, sort and perform an initial analysis of a database
7. Data Validation
- Provide validation criteria for data input
8. Tables (for Excel 2007-2016)
- Manage data lists in a more intuitive manner - includes formatting
9. Intro to Pivot Table
- Create an interactive and condensed summary of database
- Add new functionalities to Excel
More than 20 Excel functions
Classics: SUM, SUMIF, AVERAGE, MAX, MIN, INDEX
Logical: IF, AND, OR, NOT, TRUE, FALSE
Text: LEFT, RIGHT, TEXT, MID, CONCATENATE
Time: YEAR, DAY, MONTH, TODAY, NOW, DATE
ABOUT THE SPEAKER
Gaëtan has a PhD in Management of Information Systems from Paris Dauphine University and Georgia State University. He has been teaching VBA, reporting and advanced use of MS Excel at undergraduate and graduate levels (Georgia State University, Strasbourg University...).
Gaëtan has developed over 70 applications for MS Excel for various industries (e.g. insurance, bank, textile) and domains (e.g. marketing, management, finance).
Time: 2-day workshop ( 9am - 5pm)
You will need to bring your own computer, with MS Excel installed. All the versions of MS Excel from Excel 2007 to 2016 are acceptable. We recommend Windows, but other operating systems are also welcome.
Contact Gaetan Mourmant, at firstname.lastname@example.org or 604 781 9698