Microsoft Office Fundamentals Bootcamp Online
A 24-hour beginner bundle covering four Microsoft Office applications. The Excel course covers formatting, line, column, and pie charts, and workbook management; Word covers document formatting, text styling, tables, lists, citations, and endnotes....
What's included
- 24 hours of project-based instruction
- 21 training videos
- Instructor support for questions during the course
- Class recordings for 30 days
- Verified digital certificate of completion
- Instruction at an ACCET-accredited school
Overview
A 24-hour beginner bundle covering four Microsoft Office applications. The Excel course covers formatting, line, column, and pie charts, and workbook management; Word covers document formatting, text styling, tables, lists, citations, and endnotes.
PowerPoint covers building presentations with slide layouts, images, SmartArt, tables, and charts, plus transitions, shape alignment, and slideshow setup. Outlook covers email automation, calendar and contact management, scheduling, and inbox organization. VDCI prices the four together below the individual course total.
Who this course is for
Beginners who need working knowledge across Excel, Word, PowerPoint, and Outlook, including students and staff moving into office-based roles.
Tuition & enrollment
Enroll with Virtual Design and Construction Institute, the course provider.
Loading enrollment options…
Prefer to enroll directly? Open the course website.
Preview the course
Watch free previews and explore the lessons included with enrollment at VDCI.
Excel Fundamentals Course Online
-
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 VDCI -
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 VDCI -
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 VDCI -
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 VDCI -
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 VDCI -
Enrollment required
True False
Lesson 2: Formulas
7:14
Verify statements in Excel as true or false using comparison operators.
View enrollment options at VDCI -
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 VDCI -
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 VDCI -
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 VDCI -
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 VDCI -
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 VDCI -
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 VDCI -
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 VDCI -
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 VDCI -
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 VDCI -
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 VDCI -
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 VDCI
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 Fundamentals Course Online 6 hours
Join our beginner Excel workshop to master the fundamentals of Microsoft Excel, including calculations, basic functions, creating graphs, formatting, and printing. This course is designed for individuals with limited experience who want to enhance their skills and build proficiency in Excel.
-
PowerPoint Fundamentals Course Online 6 hours
Get to grips with PowerPoint fundamentals in this beginner-friendly course. You'll build compelling presentations using text, graphics, shapes, and transitions, picking up the skills you need to present with confidence. Whether you're just getting started or coming back to refresh your knowledge, this course has you covered.
- Build presentations from templates and tailor layouts, themes, and content structure to fit your needs
- Edit text, bullets, and numbered lists using Outline View and built-in formatting tools
- Add and enhance photos, SmartArt, and shapes with effects, cropping, and alignment options
- Create and format tables, connect shapes with lines, and pull in Excel charts to display your data
- Apply transitions, manage presenter notes, and use tools designed for both live and virtual presentations
- Save, print, and export your work to PDF with options suited for professional use
-
Word Fundamentals Course Online 6 hours
Pick up the shortcuts and techniques that make Microsoft Word so much more manageable. This course walks you through everything from handling mass emails and fixing formatting issues to using time-saving shortcuts that keep your workflow on track. No prior Word experience needed.
- Navigating and organizing documents
- Formatting and managing text, paragraphs, and entire documents
- Inserting and formatting tables
- Creating and managing lists
- Using endnotes, footnotes, and citations
- Inserting and editing images in Word documents
-
Outlook Fundamentals Course Online 6 hours
Get the most out of Outlook for everyday work tasks while working toward your Microsoft Office Specialist: Outlook Associate certification. You'll learn how to automate your email, handle a busy inbox, manage your schedule, and keep your contacts in order, picking up practical skills that'll make a real difference in how productively you work.
- Customizing Outlook settings
- Managing messages
- Organizing and managing calendars
- Working with notes and tasks
- Managing contacts and groups