Microsoft Office Fundamentals 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 beginner-friendly bootcamp is a great way to get up and running with the Microsoft Office suite, covering Excel, PowerPoint, Word, and Outlook together at a 15% discount. You'll build a solid foundation in each application, picking up the essential skills and management tools you need to work more confidently and efficiently. In Excel, you'll learn formatting techniques, how to create line, column, and pie charts, and tips for workbook management that save time on everyday tasks. The Word course covers the essentials of document formatting, text and paragraph styling, tables, lists, citations, and endnotes for clean, professional documents.
PowerPoint walks you through building presentations using slide layouts, text, images, SmartArt, tables, and charts, and also covers transitions, shape alignment, and running a slideshow. Outlook rounds out the bootcamp with a focus on productivity, teaching you email automation, calendar management, contact organization, complex scheduling, and how to stay on top of a high volume of email. It's a well-rounded package that gives you practical, working knowledge across all four applications right from the start.
Curriculum
What you'll learn
- Excel Level I, II, and III
- PowerPoint Level I and II
- Word Level I and II
- Outlook Level I and II
Course outline
-
Excel Level I: Fundamentals 6 hours
Join us for a beginner Excel workshop where you'll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This comprehensive course is perfect for those with limited experience looking to expand their proficiency.
- Get comfortable with the Excel interface and learn multiple ways to enter and organize data in a worksheet.
- Work with rows, columns, and worksheets by inserting, deleting, hiding, grouping, and managing spreadsheet elements.
- Build foundational Excel skills with Autofill, basic calculations, AutoSum, and essential functions such as SUM, AVERAGE, MAX, MIN, and COUNT.
- Use formulas more effectively with absolute references, logical true/false tests, text functions, and multi-input functions.
- Format spreadsheets for clarity with cell formatting and conditional formatting that highlights data based on specific rules.
- Create visual reports with column charts, line charts, pie charts, sparklines, and Excel Tables.
- Manage workbooks more efficiently using Freeze Panes, printing tools, display options, templates, and essential keyboard shortcuts and Excel tips.
- Reinforce key concepts through end-of-class projects designed to review what you learned.
-
PowerPoint Level I 6 hours
Learn the essentials of PowerPoint in this introductory course. Create dynamic presentations, add text, images, shapes, transitions, and more. Suitable for beginners or those looking to enhance their skills. Become a more effective PowerPoint user.
- Build new presentations from templates and customize layouts, themes, and content structure
- Add and edit text, bullets, and numbered lists using Outline View and various formatting tools
- Insert and enhance photos, SmartArt, and shapes with effects, cropping, and alignment options
- Create and format tables, add connector lines, and import charts from Excel to display data
- Apply transitions, manage presenter notes, and use presentation tools for live or virtual delivery
- Save, print, and export presentations to PDF, with options tailored for professional use
-
Microsoft Word Level I 6 hours
Learn essential shortcuts and techniques in this hands-on Microsoft Word class. Gain skills for improving productivity and efficiency, including mass emails, formatting fixes, and time-saving shortcuts. No prior Word experience needed.
- Navigating through documents
- How to format documents
- Working with text and paragraphs
- Tables in Word
- Lists
- Endnotes, footnotes, and citations
- Adding images to Word documents
-
Microsoft Outlook Level I 6 hours
Learn how to customize Outlook settings, automate tasks, search for items, manage messages, format messages, create and manage calendars, appointments, meetings, and events, create and manage notes, tasks, and journals, and manage contacts and groups in this beginner Outlook class.
- Outlook settings
- Working with messages
- Calendar management
- Notes, tasks, and journals
- Contacts and groups
What's included
- 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
Thu, Fri, Mon
10:00–17:00 · America/New_York (EDT/EST)
-
–
In-person or live online
Mon, Thu, Tue
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Thu, Tue, Mon, Wed
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Mon, Wed, Thu
10:00–17:00 · America/New_York (EST)
-
–
In-person or live online
Tue, Thu, Wed
10:00–17:00 · America/New_York (EST/EDT)
-
–
In-person or live online
Tue, Thu, Wed
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Tue, Thu, Wed
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Tue, Fri, Wed
10:00–17:00 · America/New_York (EDT)
-
–
In-person or live online
Mon, Thu, Wed
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 120 days. You can choose when to start your access period. Once you activate, you will have 120 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
- $749
- Course length
- 24 hours
- Schedule
- On your schedule
If you're just getting started with Microsoft Office, this beginner bootcamp is a friendly way to find your footing across Excel, PowerPoint, Word, and Outlook, all bundled together at a 15% discount. You'll build a strong foundation in each app, picking up the core skills and management tools that'll help you work with more confidence and less wasted time. The Excel portion walks you through formatting techniques, how to create line, column, and pie charts, and handy workbook management tips that shave minutes off your daily tasks. The Word course digs into document formatting, text and paragraph styling, tables, lists, citations, and endnotes so your finished documents always look polished and professional.
From there, PowerPoint shows you how to put together presentations using slide layouts, text, images, SmartArt, tables, and charts, along with transitions, shape alignment, and running a live slideshow. Outlook wraps things up with a productivity focus, teaching you email automation, calendar management, contact organization, complex scheduling, and smart ways to stay on top of a busy inbox. It's a well-rounded package that hands you practical, working knowledge across all four applications right from day one.
Self-paced curriculum
What you'll learn self-paced
- Excel Level I, II, and III
- PowerPoint Level I and II
- Word Level I and II
- Outlook Level I and II
Self-paced course outline
-
Excel Level I: Fundamentals Course Online (Self-Paced) 6 hours
Join us for a beginner Excel workshop where you'll learn the essentials of Microsoft Excel, including calculations, basic functions, graphs, formatting, and printing. This comprehensive course is perfect for those with limited experience looking to expand their proficiency.
- Become familiar with the interface and data entry
- Learn essential formulas and functions
- Format and print your work
- Create charts, including line, column, and pie charts
- Learn tips and tricks for easy workbook management
- Review key concepts in a final project
-
PowerPoint Level I (Self-Paced) 6 hours
Explore PowerPoint fundamentals through this self-paced course. Build engaging presentations by adding text, graphics, shapes, and transitions, and enhance your skills as an effective presenter. Perfect for beginners or those refreshing their knowledge.
- Create presentations from templates and customize layouts, themes, and content structure
- Edit text, bullets, and numbered lists using Outline View and formatting tools
- Insert and enhance photos, SmartArt, and shapes with effects, cropping, and alignment options
- Create and format tables, add connector lines, and import Excel charts to display data
- Apply transitions, manage presenter notes, and utilize tools for live or virtual presentations
- Save, print, and export presentations to PDF, with professional-use options
-
Microsoft Word Level I (Self-Paced) 6 hours
Master essential shortcuts and techniques in this self-paced Microsoft Word course. Improve your productivity and efficiency by learning how to handle mass emails, fix formatting issues, and use time-saving shortcuts. No prior experience with Word is required.
- Navigating and organizing documents
- Formatting text and documents
- Managing text and paragraphs
- Inserting and formatting tables
- Creating and managing lists
- Using endnotes, footnotes, and citations
- Inserting and editing images in Word documents
-
Microsoft Outlook Level I (Self-Paced) 6 hours
In this self-paced course, you'll learn how to personalize Outlook settings, automate tasks, search for items, and manage messages. You'll also discover how to create and manage calendars, appointments, meetings, and events, along with managing notes, tasks, journals, contacts, and groups for enhanced productivity.
- Customizing Outlook settings
- Managing messages
- Organizing and managing calendars
- Working with notes, tasks, and journals
- Managing contacts and groups
What's included with self-paced
- Self-paced video lessons
Self-paced lessons
Watch free previews and explore the lessons included with enrollment at Noble Desktop.
Excel Level I: Fundamentals Course Online (Self-Paced)
-
Interface
Lesson 1: Introduction
8:26
Explore the Microsoft Excel user interface, including the Quick Access Toolbar, Ribbon tabs and groups, Review tab features, Insert Function button, Zoom slider, Sheet Selector buttons, and the expansive rows and columns.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Rows and Columns
Lesson 1: Introduction
6:02
Insert, delete, hide, and group rows and columns using ribbon commands, right-click menus, keyboard shortcuts, and grouping buttons.
View enrollment options at Noble Desktop -
Autofill
Lesson 2: Formulas
9:07
Use Excel's autofill and flash fill features to efficiently complete patterns and replicate data across cells.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Data Entry
Lesson 2: Formulas
5:13
Learn techniques for efficient data entry, editing, copying, pasting, and cutting in spreadsheets.
View enrollment options at Noble Desktop -
Enrollment required
Calculations
Lesson 2: Formulas
10:16
Learn to perform basic calculations in Excel using formulas, cell references, and functions like AVERAGE while considering the order of operations (PEMDAS).
View enrollment options at Noble Desktop -
Enrollment required
Autosum Functions
Lesson 2: Formulas
9:58
Use Excel's AutoSum functions to quickly calculate Sum, Average, Max, Min, and Count in tables.
View enrollment options at Noble Desktop -
Enrollment required
Text Functions
Lesson 2: Formulas
8:04
Use text functions like PROPER, UPPER, LOWER, and TRIM in Excel to efficiently adjust text casing and remove extra spaces.
View enrollment options at Noble Desktop -
Enrollment required
True False
Lesson 2: Formulas
7:14
Verify statements in Excel as true or false using comparison operators.
View enrollment options at Noble Desktop -
Enrollment required
Absolute Cell References
Lesson 2: Formulas
10:07
Utilize absolute cell references in Excel formulas to fix a specific cell while autofilling calculations, preventing unwanted shifts in cell references.
View enrollment options at Noble Desktop -
Enrollment required
Multi Input Functions
Lesson 2: Formulas
12:37
Learn to use multi-input Excel functions like LEFT, RIGHT, SUMPRODUCT, and ROUND for extracting data, calculating totals, and managing rounding errors efficiently.
View enrollment options at Noble Desktop -
Enrollment required
Formatting
Lesson 3: Formatting
14:04
Explore various Excel formatting tools to enhance cell appearance, including changing colors, fonts, alignment, number formats, and merging cells.
View enrollment options at Noble Desktop -
Enrollment required
Conditional Formatting
Lesson 3: Formatting
9:30
Use conditional formatting to visually highlight and differentiate data based on set criteria within Excel.
View enrollment options at Noble Desktop -
Line Chart
Lesson 4: Charts & Tables
5:34
Create a basic line chart in Excel by selecting a single cell in your data, using the insert tab to choose a line chart, and customizing it with quick layout, color, and style options.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Column Chart
Lesson 4: Charts & Tables
7:53
Create a column chart by selecting data, inserting it from the Insert tab, and customizing elements like axis titles, data labels, and grid lines through the Chart Design tab.
View enrollment options at Noble Desktop -
Enrollment required
Trendlines
Lesson 4: Charts & Tables
3:05
Apply trend lines to charts by selecting the desired type (linear, exponential, linear forecast, or moving average) in the chart design options.
View enrollment options at Noble Desktop -
Enrollment required
Pie Chart
Lesson 4: Charts & Tables
7:27
Create and customize pie charts by selecting data, converting between 2D, 3D, and donut styles, and isolating specific slices for emphasis.
View enrollment options at Noble Desktop -
Enrollment required
Tables
Lesson 4: Charts & Tables
13:52
Learn to create and use Excel tables for efficient data management and analysis.
View enrollment options at Noble Desktop -
Printing
Lesson 5: Workbook Management
10:00
Explore and adjust printing options in Excel by utilizing the Page Layout tab to control margins, orientation, print area, page breaks, print titles, scale to fit, and gridlines, while adding headers and footers through the Insert tab for enhanced page setup and layout management.
This preview is temporarily unavailable. Please try again later.
-
Enrollment required
Worksheets
Lesson 5: Workbook Management
7:04
Manage Excel worksheets by inserting, deleting, hiding, moving, copying, and renaming them using right-click options or the ribbon menu.
View enrollment options at Noble Desktop -
Enrollment required
Freeze Panes
Lesson 5: Workbook Management
5:03
Freeze panes by selecting the desired row or column below or to the right of where you want the freeze, then choose "Freeze Panes" from the View tab.
View enrollment options at Noble Desktop -
Enrollment required
Excel Tricks
Lesson 5: Workbook Management
9:14
Explore Excel tricks like repeating commands with F4, applying multiple formats using Format Painter, inserting comments and links, and capturing screenshots directly into your spreadsheet.
View enrollment options at Noble Desktop