Microsoft Office (Intermediate)
Overview
Boost your Microsoft Office skills with our Intermediate course. Master Word, Excel, PowerPoint, and Outlook. Learn advanced features and shortcuts for enhanced productivity. Stay ahead in the digital age. Enroll now and excel in the workplace!
The Intermediate Microsoft Office Award of Recognition program allows students to become more proficient in using Microsoft Office products for the purposes of home, school, or work use.
Take your Microsoft Excel skills to the next level as you master charts, graphs, pivot tables, slicers, sparklines, auto filters, macros and other advanced Excel functions. master the more advanced features of Microsoft Word and learn how to create an index, build a list of figures, design a table of contents, do desktop publishing, perform a mail merge and use time-saving shortcuts. Learn how to use Microsoft PowerPoint to create exciting slide show presentations that include SmartArt, multimedia, animation, sound, charts, clip art and hyperlinks.
Admission Requirements
- O.S.S.D. or equivalent
Mature Student Assessment is available for this program. For more information, please contact counselling@lambtoncollege.ca. Review the Mature Student Admission process.
Academic admission requirements can be obtained through Academic Upgrading and the Pre-Programs at Lambton College.
Prior Learning Assessment
If you believe you have an equivalent level of knowledge and would like credit through Prior Learning Assessment, please contact online@lambtoncollege.ca or call 519-479-1023 at least two weeks before classes begin.
Credential Eligibility
If you are taking courses with the intention of completing this program and earning a credential, you must meet the Admission Requirements. It is your responsibility to supply proof of admission requirements to the Office of the Registrar before completing three courses in this program.
If you complete the program but fail to provide proof of admission requirements, you will be ineligible to receive your credential.
Costs
Course Fees
- Exact costs can be obtained during the registration process. Visit the Course List and select an individual course for associated course fees.
Graduation Fees
Students who successfully complete all the academic requirements for this program should submit their intent to graduate in order to receive their credential. The graduate module can be completed on myLambton via Self Service.
A graduation fee of about $75 is added to your account upon verification that admission requirements have been met. For exact fees contact your Enrolment Services Professional.
Textbooks
Textbook costs may be applicable to each course. Most textbooks can be purchased through textnet.ca, but some exceptions do apply. Some courses may have software or equipment requirements that are not included in the cost of the course and are the responsibility of the student. Please see individual course pages for course-specific textbook information.
Scholarships Available
There are 9 scholarships available for this program, with a total value of $1,000!
Technology Requirements
In order to keep pace with the requirements of each and every course in your program, Lambton College requires that each student have access to a laptop while studying at our college.
Courses
Course List
Many businesses rely on spreadsheets to manage budgets, schedules, and tracking. Microsoft Excel is considered the industry standard for spreadsheets. If you use Excel regularly and want to learn more advanced functions in this powerful software, this course is for you. You will learn how to harness the power of Excel's data analysis tools and AutoFilter commands and how to create macros that eliminate repetitive tasks. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other intermediate functions to your professional skill set. In addition, you will learn to create macros that let you manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems.
If you create business documents like letters, brochures, or newsletters, you know that their quality is representative of your organization. To create professional-quality documents efficiently and effectively, you have to use advanced word processing functions. This online course will teach you how to use Microsoft Word 2019, the newest version of Microsoft Office/Microsoft 365's widely-used word processing software. Through hands-on lessons and modules, you will learn how to use a number of shortcuts and time-saving techniques to create complex documents. By the end of the course, you will know how to create and organize tables, manipulate graphics, and merge spreadsheets, amongst other functions, to turn Word into a simple desktop publishing tool.
Textbooks
There is no required textbook for this course.
Please note: There may be required software or other resources for this course. Please be sure to check the course outline when you first log in to the course.
Host Course Code:Host Course Name:
This in-depth course introduces PowerPoint's functions and will teach you how to plan and create professional-quality presentations. You will learn how to catch your audience's attention with PowerPoint's visual features like photo album. As you become acquainted to Office 365, you will learn how to utilize OneDrive and PowerPoint Online's cross-functionality—saving, editing, and sharing your presentations online. This course is perfect for beginners looking to learn how to use the latest PowerPoint software. You will have the opportunity to create a custom presentation with content specific to your needs. By completion, you will be able to create captivating presentations and contribute to your company's business processes.
Textbooks
There is no required textbook for this course.
Please note: There may be required software or other resources for this course. Please be sure to check the course outline when you first log in to the course.
Host Course Code:Host Course Name:
Have Questions?
If you have any questions about our online programs, the courses offered, the registration process, or any other Online Education related questions, reach out to us.
Contact
Online Education
More Information
Prepare for Success
Variations due to Section
Remember to review the important dates associated with this program - some deadlines may be different depending on how your program is delivered and what section you're enrolled in.
Technology Requirements
It is required that students purchase a laptop with a Windows operating system.
Internet Speed Requirements
For best performance for students learning remotely, an internet connection with a minimum of 40 Mbps download and 10 Mbps upload speed is recommended in order to effectively use video conferencing and remote lecture delivery software as well as, other online resources remotely. Due to the large area over which students may be dispersed, we are unable to recommend a specific provider, so you will need to inquire around your area to find one that best suits your needs.
Minimum Laptop Requirements
In order to access the internet and virtually-delivered software and courseware, student laptops should include the following at a minimum. By meeting the following specifications, students will be equipped to access software and courseware on their laptop through the internet:
- Intel i5 8th Gen Processor or equivalent
- 16 GB of RAM (with a minimum of 8 GB)
- 100 GB HDD or more
- HD Graphics
- Webcam with a microphone
- Wireless 802.11n/ac 5ghz capable
- Windows Operating System (Windows 11)
Software
To ensure students are getting the most our of their classroom experience, some software will be required.
Lambton College has made this software easily accessible online. Students can leverage our Microsoft Office 365 software packages and services. In addition, much of the software you require for your courses will be available on demand for use on any device - on or off campus.