Microsoft Office Intermediate Bootcamp
- Format
- Live or Self-paced
Choose how you learn
Compare formats, then explore the details for your choice.
Book directly on nobledesktop.com. Opens in a new tab.
Book live on Noble DesktopSummary
This five-day bootcamp is built for anyone ready to move beyond the basics and get serious about Microsoft Office, bundling intermediate and advanced Excel, advanced PowerPoint, Word, and Outlook into one discounted package. In Excel, you'll learn how to summarize data with PivotTables, write advanced functions like VLOOKUP, and pick up techniques that speed up your workflow, including how to make functions more flexible and automate repetitive tasks with macros. PowerPoint goes deep on the features that make presentations truly polished, covering how to build reusable templates, import charts from Excel, work with multimedia and layered objects, and record a slideshow for easy delivery.
Word focuses on the tools that save time and improve consistency across your whole team, including mail merge automation, recorded tasks, macros, and building custom document styles and templates. Outlook rounds out the bootcamp with a set of skills that make managing a busy inbox and calendar much more manageable, from configuring mail accounts and performing advanced searches to controlling spam with filters, automating tasks with rules, and handling advanced calendar and contact management. By the end of the five days, you'll have a genuinely advanced command of all four applications.
Prerequisites
Knowledge of Microsoft Office equivalent to our Microsoft Office Fundamentals Bootcamp is required.
Curriculum
What you'll learn
- Excel Level II and III
- PowerPoint Level II
- Word Level II
- Outlook Level II
Course outline
-
Excel Level II: Intermediate 6 hours
Learn intermediate Excel functions like VLOOKUP and SUMIFS, and how to summarize data with Pivot Tables, Sort & Filter databases, and split and join text. Gain the skills needed to utilize complex Excel functions and prepare for more advanced training.
- Navigate worksheets more efficiently using keyboard shortcuts and Excel tools that speed up movement within and between cells.
- Work with formulas and text by reviewing calculation methods, splitting text with Text to Columns, and joining text with CONCAT and the ampersand.
- Manage cell ranges with Paste Special, Paste Special Values, and named ranges to format data, hardcode results, and simplify references in calculations.
- Use database tools such as VLOOKUP, XLOOKUP, Sort & Filter, and Remove Duplicates to find, organize, and clean large sets of data.
- Build PivotTables to summarize large databases, group data within PivotTables, and create multiple PivotTables on a single worksheet.
- Apply logical, math, and statistical functions including IF, AND, OR, SUBTOTAL, SUMIFS, and COUNTIFS to analyze data based on conditions and filtered results.
- Improve data quality with Data Validation and reinforce key course concepts by completing an end-of-class project.
-
Excel Level III: Advanced 6 hours
Learn advanced Excel functions, macros, and data analysis to improve efficiency and manage complex data in any job setting. This advanced course is ideal for Excel power-users.
- Use advanced navigation tools, Autofill techniques, Hot Keys, and Go To Special to move through worksheets and work more efficiently.
- Build stronger formulas with mixed references, cell auditing tools, date functions, and custom number formats.
- Create advanced logic with nested IF statements and IF formulas that incorporate AND/OR criteria for more flexible results.
- Perform What-If Analysis with Goal Seek and Data Tables to test variables and evaluate possible outcomes.
- Analyze data with advanced PivotTable tools, including base fields and sets, calculated fields, and Pivot Charts.
- Use XMATCH, INDEX-MATCH, macros, and dynamic arrays to create powerful lookups, automate tasks, and complete an end-of-class project reviewing key concepts.
-
Microsoft Word Level II 6 hours
Take your Microsoft Word skills to the next level with our advanced training course. Learn how to automate tasks, create custom styles and templates, and efficiently work with long documents. By the end of this course, you'll be able to expedite your workflow and become more productive in your everyday Word usage.
- Manage and work with multiple documents efficiently
- Track changes and collaborate using comments and revision tools
- Apply advanced formatting techniques for professional documents
- Create and manage reference tables, including tables of contents and indexes
- Design forms and use mail merge to automate personalized communications
- Build and apply custom style sets and templates for consistent formatting
-
PowerPoint Level II 6 hours
In this advanced PowerPoint class, you’ll learn how to create reusable PowerPoint themes and templates to control the design of entire presentations using Slide Master. Add excitement to your presentations with animations, gain greater control over charts and tables, and much more.
- Create and manage Slide Master layouts to ensure consistent branding across entire presentations
- Design custom PowerPoint themes, including personalized color palettes, fonts, and reusable backgrounds
- Animate bullet points, charts, and objects using entrance, emphasis, and exit effects, and explore the Morph transition
- Integrate video, hyperlinks, and dynamic charts and tables imported from Excel for interactive presentations
- Customize presentation workflows with hidden slides, custom shows, sections, and the Quick Access Toolbar
- Collaborate and finalize projects with built-in commenting tools, PDF export options, and optimized printing settings
-
Microsoft Outlook Level II 6 hours
In this course, learn how to configure mail accounts, perform advanced searches, control spam with filters, automate tasks with rules, and develop advanced calendar and contact management skills. Customize your communication system to suit your work style.
- Modify Messages & set Global Options
- Calendar Settings
- Organize & Search Messages
- Contacts & Groups
- Manage Mailboxes
- Manage Activities
- Automate Message Management
- Share Workspaces
What's included
- Microsoft Office
- Free course retake within one year to refresh the material and gain practice.
- Class recordings
Stated by the provider. Confirm what your tuition covers before enrolling.
Live classes
Choose dates and book your instructor-led class on nobledesktop.com.
-
–
In-person or live online
Tue, Wed, Fri
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Wed, Thu, Fri
10:00–17:00 · America/New_York (EST/EDT)
-
–
In-person or live online
Wed, Thu, Fri
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Wed, Thu, Fri
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Wed, Thu, Mon
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Tue, Wed, Fri, Thu
10:00–17:00 · America/New_York (EDT/EST)
Confirm current dates and availability on Noble Desktop before booking.
Self-paced course
Learn through recorded lessons on your own schedule.
This program is available for 150 days. You can choose when to start your access period. Once you activate, you will have 150 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
- Tuition
- $949
- Course length
- 30 hours
- Schedule
- On your schedule
In this self-paced course, you’ll master intermediate and advanced functions of Microsoft Office programs, including Excel, PowerPoint, Word, and Outlook. This comprehensive training package covers essential skills and time-saving techniques, with a focus on improving productivity and streamlining your workflow. You’ll dive into advanced Excel functions like Pivot Tables, VLOOKUP, and macros, while also learning how to automate tasks and summarize data effectively.
You’ll also enhance your PowerPoint skills by creating reusable templates, importing Excel charts, and designing multimedia-rich presentations. In Word, you’ll learn to automate tasks like mail merge, create custom styles and templates, and write macros to boost efficiency. Finally, you’ll gain advanced Outlook skills, including configuring mail accounts, performing complex searches, managing spam, and optimizing calendar and contact management. By the end, you’ll have the skills to use Microsoft Office more effectively and efficiently in your daily work.
Self-paced curriculum
What you'll learn self-paced
- Excel Level II and III: Dive deeper into advanced Excel features, including Pivot Tables, complex formulas, data analysis techniques, and automation with macros to streamline your workflow.
- PowerPoint Level II: Learn to create dynamic, professional presentations by mastering advanced features such as reusable templates, importing data from Excel, and incorporating multimedia elements.
- Word Level II: Master advanced document formatting, automation techniques like mail merge, and time-saving tools such as macros and custom styles to improve team productivity.
- Outlook Level II: Enhance your email management with advanced features like configuring mail accounts, setting up rules for automation, performing complex searches, and optimizing calendar and contact management.
Self-paced course outline
-
Excel Level II: Intermediate Course Online (Self-Paced) 6 hours
Learn intermediate Excel functions like VLOOKUP and SUMIFS, and how to summarize data with Pivot Tables, Sort & Filter databases, and split and join text. Gain the skills needed to utilize complex Excel functions and prepare for more advanced training.
- Learn to split and join text, apply data validation, and create named ranges
- Use database functions such as VLOOKUP and HLOOKUP
- Write logical formulas using AND, OR, and IF functions
- Create Pivot Tables to efficiently summarize and analyze large datasets
- Apply statistical functions such as RANK, COUNTIFS, and SUMIFS
- Build advanced combo charts by combining multiple chart types
- Reinforce key concepts through a guided final project
-
Excel Level III: Advanced Course Online (Self-Paced) 6 hours
Learn advanced Excel functions, macros, and data analysis to improve efficiency and manage complex data in any job setting. This advanced course is ideal for Excel power-users.
- Cell management, including cell locking, auditing, and hot keys
- Special formatting for calculating dates
- Use advanced functions such as nested IF statements
- Learn advanced analytical tools for data consolidation, conditions to exclude data, and pivot charts
- Use advanced database functions including MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH
- Record macros and relative reference macros for ad hoc reporting
- Create a project that applies key concepts from the class
-
Microsoft Word Level II (Self-Paced) 6 hours
Enhance your Microsoft Word abilities with this self-paced training. Discover how to automate repetitive tasks, design custom styles and templates, and manage lengthy documents effectively. This course will help you improve your efficiency and streamline your work processes.
- Efficiently manage and work with multiple documents
- Track changes and collaborate using comments and revision tools
- Apply advanced formatting techniques for polished, professional documents
- Create and manage reference tables, including tables of contents and indexes
- Design forms and utilize mail merge to automate personalized communications
- Develop and apply custom style sets and templates for consistent formatting
-
PowerPoint Level II (Self-Paced) 6 hours
Explore the fundamentals of PowerPoint at your own pace in this introductory course. Learn to build dynamic presentations with text, images, shapes, transitions, and more. Ideal for beginners or those looking to enhance their presentation skills and efficiency.
- Create presentations from templates and customize layouts, themes, and content structure
- Edit text, bullets, and numbered lists with Outline View and advanced formatting tools
- Insert and enhance images, SmartArt, and shapes using effects, cropping, and alignment options
- Format tables, add connector lines, and import Excel charts to display data
- Apply transitions, manage presenter notes, and use tools for live or virtual presentations
- Save, print, and export presentations to PDF with professional-use options
-
Microsoft Outlook Level II (Self-Paced) 6 hours
This self-paced course covers everything you need to know to configure your mail accounts, perform advanced searches, control spam using filters, automate tasks with rules, and master calendar and contact management. Customize your Outlook setup to suit your unique workflow.
- Edit messages and configure global settings
- Customize calendar settings
- Organize and search for messages
- Manage contacts and groups
- Handle mailboxes efficiently
- Manage tasks and activities
- Automate message management
- Share workspaces and collaborate effectively
What's included with self-paced
- Microsoft Office
- Self-paced video lessons
Self-paced lessons
Watch free previews and explore the lessons included with enrollment at Noble Desktop.
Excel Level II: Intermediate Course Online (Self-Paced)
-
Enrollment required
Tips and Fundamentals
Lesson 5: Workbook Management
10:24
Review and apply Excel's autosum functions and formula auditing tools to calculate totals, averages, and high scores, detect and fix errors, and ensure correct formula dependencies.
View enrollment options at Noble Desktop -
Navigation
Lesson 1: Worksheet Management
6:58
Navigate and select cells in a spreadsheet using keyboard shortcuts like arrow keys, control, shift, and page up/down for efficient data management.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Paste Special
Lesson 2: Working with Text
8:55
Use paste special in Excel to apply formats, perform calculations, and change data orientation.
View enrollment options at Noble Desktop -
Enrollment required
Paste Special Values
Lesson 2: Working with Text
3:14
Use "paste special values" to copy and paste only the results of formulas as text without including the formulas themselves.
View enrollment options at Noble Desktop -
Enrollment required
Splitting Text
Lesson 2: Working with Text
5:08
Use text-to-columns to split data in a spreadsheet into separate columns based on delimiters like commas or spaces.
View enrollment options at Noble Desktop -
Enrollment required
Joining Text
Lesson 2: Working with Text
5:06
Join text using either the concatenate function or the ampersand method to combine cells with specified separators like spaces or dashes.
View enrollment options at Noble Desktop -
Enrollment required
Named Ranges
Lesson 3: Cell Ranges
3:56
Create named ranges for assets, liabilities, and equity to simplify referencing them in calculations.
View enrollment options at Noble Desktop -
Data Validation
Lesson 4: Database Functions
7:35
Use data validation in Excel to create drop-down lists that restrict cell input to specified numerical or text values, with options to customize error alerts and input messages.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Remove Duplicates
Lesson 4: Database Functions
3:51
Remove duplicates by selecting a cell in the data, going to the Data tab, clicking Remove Duplicates, and confirming the selection.
View enrollment options at Noble Desktop -
Enrollment required
VLOOKUP
Lesson 4: Database Functions
10:06
Use VLOOKUP to find information in a table by specifying a lookup value, table array, column index number, and choose between exact or approximate match.
View enrollment options at Noble Desktop -
Enrollment required
HLOOKUP
Lesson 4: Database Functions
2:58
Use HLOOKUP to find a lookup value horizontally in a row by selecting the row index number instead of the column index number.
View enrollment options at Noble Desktop -
Enrollment required
Sort and Filter
Lesson 4: Database Functions
15:53
Sort and filter data using Excel's home or data tab, create subtotals for grouped data, and practice these skills through specific tasks like multi-level sorting, filtering, and applying subtotals.
View enrollment options at Noble Desktop -
Pivot Tables New
Lesson 5: Pivot Tables
10:00
Create a basic pivot table by converting your data into an Excel table, then use the pivot table options to summarize and filter the data, remembering to refresh for updates.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Pivot Grouping Timelines
Lesson 5: Pivot Tables
5:16
Group and filter pivot table data by time periods using the group and insert timeline features.
View enrollment options at Noble Desktop -
Enrollment required
Multiple Pivot Tables
Lesson 5: Pivot Tables
11:40
Explore pivot tables by inserting fields multiple times, using value field settings for different calculations, employing slicers for easy filtering, and connecting slicers to multiple pivot tables for synchronized filtering.
View enrollment options at Noble Desktop -
If Statements
Lesson 6: Logical Functions
8:30
Explain how to use if statements and if error functions in Excel for logical testing and error handling.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
And Or
Lesson 6: Logical Functions
6:17
Use AND to ensure all criteria are true and OR to check if at least one criterion is true when evaluating conditions.
View enrollment options at Noble Desktop -
COUNTIFS and SUMIFS
Lesson 7: Statistical Functions
9:46
Count and sum data based on conditions using COUNTIFS and SUMIFS functions in Excel, which act as filters for specified criteria across multiple columns.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Combo Charts
Lesson 8: Advanced Charts
5:01
Create a combo chart with a secondary axis for better comparison, and format it by adjusting bar colors, background, border, and adding effects.
View enrollment options at Noble Desktop
Excel Level III: Advanced Course Online (Self-Paced)
-
Advanced Cell Lock
Lesson 1: Cell Management
10:00
Lock cells in Excel by using mixed referencing to maintain specific row or column values when autofilling formulas.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Hot Keys
Lesson 1: Cell Management
7:14
Utilize the Alt key on a PC to access Excel's ribbon commands and create custom keyboard shortcuts for efficient navigation and task execution.
View enrollment options at Noble Desktop -
Enrollment required
Go To Special
Lesson 1: Cell Management
8:51
Use "Go To Special" in Excel to quickly select specific cell types, such as constants, blanks, or visible cells, for efficient data management and editing.
View enrollment options at Noble Desktop -
Date Functions
Lesson 2: Special Formatting
7:29
Calculate future dates, days between dates, workdays, week numbers, and month ends using Excel's DAYS, NETWORKDAYS, WEEKNUM, EOMONTH, and EDATE functions.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Adv Conditional Formatting
Lesson 2: Special Formatting
9:35
Apply advanced conditional formatting using formulas to format cells based on criteria in different columns.
View enrollment options at Noble Desktop -
Enrollment required
Nested IFs
Lesson 2: Special Formatting
9:37
Nest multiple if statements to evaluate more conditions and provide different responses based on the evaluated criteria.
View enrollment options at Noble Desktop -
If AND OR
Lesson 3: Advanced Functions
7:43
Combine the IF statement with AND or OR functions to evaluate multiple conditions and return specific results based on whether those conditions are true or false.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Goal Seek
Lesson 4: What If Analysis
4:18
Use Goal Seek in Excel to determine the required growth rate or exam score needed to reach a specific target value by adjusting a related variable.
View enrollment options at Noble Desktop -
Enrollment required
Data Tables
Lesson 4: What If Analysis
7:32
Create data tables in Excel to analyze the impact of different variables on a formula.
View enrollment options at Noble Desktop -
Conditional Sumproduct
Lesson 5: Advanced Analytical Tools
9:48
Use conditional sum product to calculate totals or averages by applying criteria to filter specific data subsets.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Pivot Table Variances
Lesson 5: Advanced Analytical Tools
6:17
Create a pivot table, group data by quarters and years, and use "difference from" and "percentage difference from" calculations to show variances between years.
View enrollment options at Noble Desktop -
Enrollment required
Pivot Calculations
Lesson 5: Advanced Analytical Tools
10:22
Perform calculations within pivot tables using calculated fields and items for efficient data analysis.
View enrollment options at Noble Desktop -
Enrollment required
Pivot Charts
Lesson 5: Advanced Analytical Tools
6:05
Create dynamic graphical representations of pivot table data using pivot charts in Excel.
View enrollment options at Noble Desktop -
Match Function
Lesson 6: Advanced Database Functions
4:25
Find the relative position of a lookup value within a single column or row using the match function.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Vlookup Match
Lesson 6: Advanced Database Functions
8:08
Enhance VLOOKUP accuracy by using the MATCH function to dynamically determine the column index number, allowing for more efficient data retrieval with mixed referencing.
View enrollment options at Noble Desktop -
Enrollment required
Index Match
Lesson 6: Advanced Database Functions
7:02
Combine INDEX and MATCH functions to efficiently locate a value in a row or column, allowing lookups in either direction.
View enrollment options at Noble Desktop -
Enrollment required
Index Double Match
Lesson 6: Advanced Database Functions
7:07
Utilize the Index Double Match function to perform a two-way lookup by identifying both row and column positions for retrieving specific data from a table.
View enrollment options at Noble Desktop -
Enrollment required
Windows
Lesson 6: Advanced Database Functions
6:56
Learn to use keyboard shortcuts and commands in Windows to efficiently navigate and arrange Excel windows for better multitasking.
View enrollment options at Noble Desktop -
Enrollment required
Working Across Sheets
Lesson 6: Advanced Database Functions
4:38
Apply formatting and summarize calculations across multiple sheets by selecting ranges while holding the shift key and using functions like SUM and autofill for common cells.
View enrollment options at Noble Desktop -
Macros
Lesson 7: Introduction to Macros
8:29
Automate Excel tasks by creating and running macros using the developer tab, keyboard shortcuts, buttons, and the quick access toolbar to efficiently repeat actions like entering data.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
MacrosReport
Lesson 7: Introduction to Macros
6:14
Create a macro to automate daily report formatting tasks, reducing a two-minute manual process to under a second.
View enrollment options at Noble Desktop -
Enrollment required
Consolidation
Lesson 8: Dynamic Arrays
5:10
Use the consolidate function to sum values across multiple sheets into a summary worksheet and enable automatic updates when source data changes.
View enrollment options at Noble Desktop