Microsoft Office Bootcamp: Excel, Word and PowerPoint. From Basics to Advanced practical usage
Analyze and Improve Inc.
Course description
Microsoft Office Bootcamp: Excel, Word and PowerPoint. From Basics to Advanced practical usage
Organizations assume that all of their employees have a solid understanding of Microsoft Office programs, namely Excel, Word and PowerPoint. Unfortunately, the reality is that many people were never given the opportunity to properly learn this software beyond some of the basic functions.
The purpose of this course is to provide a user-friendly and interactive journey to getting a strong and practical understanding of Excel, Word and PowerPoint.
Who should attend?
This course is designed for people who have been hired on or promoted into roles that require a healthy understanding of Microsoft Office suite of programs: Excel, Word and PowerPoint. The idea is to take the participants on a journey through all 3 levels, to ensure that there are no gaps.
- The opening “Basics” section focus on introducing the software and review of basic options.
- The next “Intermediate” section builds on basic knowledge and increase overall understanding.
- The final “Advanced” section targets more complex problems or usage of the software.
Training content
DAY 1 - Morning (Word)
- Word Basics: Demonstration of basic capabilities of Word, with simple examples (1 hour).
- ‘File’: Open, Close, Save.
- ‘Home’: Copy, Cut, Paste. Font, Paragraph, Editing.
- Word Intermediate: Deeper demonstration of Word (1.5 hours).
- ‘Insert’: Page Break, Pictures, Tables, Header/Footer.
- ‘Review’: Spelling, Language, Comments, Track Changes
- Word Advanced: Deeper demonstration of Word and customized based on participant feedback (1.5 hours).
- Hyperlinks
- Table of Contents; creating specific documents and memos
- Mail Merge
- Formats; titles; review and comments
DAY 1 - Afternoon (Excel)
- Excel Basics: Demonstration of basic capabilities of Excel, with simple examples (1 hour).
- ‘File’: Open, Close, Save.
- Columns and Rows. Simple math options. Simple examples.
- ‘Home’: Copy, Cut, Paste. Font. Alignment. Numbers. Editing.
- Excel Intermediate: Deeper demonstration of Excel (1.5 hours).
- ‘Insert’: Charts
- ‘Data’: Sort; Filter
- ‘View’: Freeze
- Formulas and Functions
- Excel Advanced: Deeper demonstration of Excel and customized based on participant feedback (1.5 hours).
- Advanced functions and formulas
- Conditional formatting
- Vlookup and formulas
- Pivot Tables
- Macros
DAY 2 - Morning (PowerPoint)
- PowerPoint Basics: Demonstration of basic capabilities of PowerPoint, with simple examples (1 hour).
- ‘File’: Open / Close / Save.
- ‘Home’: Copy, Cut, Paste. Font, Paragraph, Editing.
- Typing / making slides. Simple examples. Notes.
- PowerPoint Intermediate: Deeper demonstration of PowerPoint (1.5 hours).
- ‘Insert’: Pictures, Tables, Shapes. SmartArt.
- ‘Slide Show’ and ‘View’
- PowerPoint Advanced: Deeper demonstration of PowerPoint and customized based on participant feedback (1.5 hours).
- Hyperlinks; Master / Templates
- Animations
- Transitions
- Music and Timing
- Coaching Session: Individual and/or group session, as required.
Course delivery details
This is a 1.5 day interactive series of sessions. Training will deliver a foundation of Word, Excel and PowerPoint, with practical examples and problem solving throughout the course.
Costs
$995 CAD + 13% GST
Why choose A+I?
Courses taught by experienced industry professionals
Instructors with proven experience applying the topics in the real world
Since our start in 2014, we have provided Teaching, Coaching and Project support to over 30 companies
About A+I
Analyze and Improve Inc.
The name of our company says it all – we analyze problems and opportunities, improve on the present state and drive towards accelerated results. Our company philosophy is "Stability before Capability and only then Capital". Since our inception in 2014,...
Contact this provider
Contact info
Analyze and Improve Inc.
Reviews
Average rating 4.6
Based on 9 reviews.
Have a question about this course? Fill out this form and the provider will get in touch with you shortly
I have been using Excel and PowerPoint for more than 20 years now and consider myself to be proficient enough. I found the course really helpful even for a long time Microsoft office user like me. The course helped me understand that excel and PowerPoint can do a lot more than what I use to do. The short cuts, pivot table etc. will greatly red...