Continuing Education Aurora Campus, Inuvik
FORMULAS & FUNCTIONS – Virtual Course
FORMULAS & FUNCTIONS In this 3-hour session, learn how to set up formulas and functions to get the Excel program to do the math for you. Topics include: Creating and editing formulasMathematical operatorsCommon functionsConditional functionsAbsolute & relative cell referencesProtecting your workbook Date: September 29, 2022Time: 9:00 a.m. – NoonCost: $150.00Instructor: Heather Lyon ABOUT EXCEL TRAINING…
FORMATTING THE WORKSHEET – Virtual Course
Make your Excel workbooks look professional and readable by learning how to properly format all the aspects of your spreadsheet. In this 3-hour session, you will learn how to work with: Formatting dates & numbersCell alignmentFonts & sizesBordersColours and patternsFormat painterThemes & StylesConditional formatting Date: October 13, 2022Time: 9:00 a.m. – NoonCost: $150.00Instructor: Heather Lyon…
CHARTS & TABLES – Virtual Course
In the Excel program, you can convert your data from a spreadsheet into a table and/or chart. Learn how you can turn dry financial and statistical information into a vibrant visual display that will have a powerful impact on your audience! Charts vs. TablesCreating a chartChanging chart typesChanging chart layout and locationUsing sparklinesCreating a tableCreating…
WRITING & EDITING SKILLS – MAKING THE MESSAGE CLEAR – Virtual Course
Good business writing leads to good business decisions, which leads to good business. This course emphasizes business writing (letters, memos, emails, documents, web material) with the reader and readability in mind. In two days you will focus on new formats, writing style, tone, clarity, conciseness and results while exploring new skills and time saving approaches.…
PROJECT MANAGEMENT FUNDAMENTALS
Aurora Campus, InuvikDuring this face-to-face workshop you will examine project management from conceptualization through to final completion. You will learn how to set up an effective plan, apply project planning steps, develop the project plan and implement it, manage work in progress, monitor controls, and reporting status. Date: November 7-9, 2022 Time: 9:00 AM to 4:00 PM…
MINUTE TAKING – Virtual Course
This workshop is for people who are responsible for taking minutes in meetings. You will learn how to co-ordinate meetings, take minutes in formal and informal meetings, edit the minutes without altering content, and how to present, distribute and maintain the minutes most effectively. Topics include agenda preparation, minute taking styles & formats for different…
EXCEL EXTRAS – Virtual Courses
You know the basics of the Excel program. Now learn about what else you can do to make working with this program even easier and more effective in this 3-hour session. Topics include: Working with graphicsInserting a screenshotSorting & FilteringUsing hyperlinksUsing commentsDrop-down listsGrouping & SubtotalsQuick Analysis Date: November 10, 2022Time: 9:00 a.m. – NoonCost: $150.00Instructor:…
BOOKKEEPER & FINANCIAL CLERK/ASSISTANT TRAINING – INTRO TO ACCOUNTING – Virtual Course
This class is designed to enhance the knowledge of people presently employed in a bookkeeping or finance position, or interested in pursuing a career in a bookkeeping position. Course Description This 3-day course looks at the theory and the steps involved in preparing books for a business or organization in the NWT. Using an accounting…
READING & UNDERSTANDING FINANCIAL STATEMENTS – Virtual Courses
You pay all kinds of money to your accountant to prepare annual financial statements for your business, but do you really know how to read them? This workshop goes through the sections of basic financial statements including balance sheets, income statements and supporting documents to give you a thorough understanding of the information they contain.…
WRITING EFFECTIVE PROPOSALS – INSTRUCTOR-LED ONLINE SERIES – Virtual Courses
This 2-day course is designed to teach students how to write an effective proposal, whether to obtain work for a business or funding for an organization. The steps involved are covered from obtaining the needed information to prepare the proposal right to the layout of the final document. Through a combination of lecture and hands…
Intro to Excel – Online
This series of 3-hour sessions are delivered in a live, online session where students and the instructor can speak and interact with one another. Students will need a computer with internet access and a microphone/speakers for this class. A headset with a microphone is ideal, but not required. As the instructor demonstrates the exercises, students…
Formulas & Functions – Online
This series of 3-hour sessions are delivered in a live, online session where students and the instructor can speak and interact with one another. Students will need a computer with internet access and a microphone/speakers for this class. A headset with a microphone is ideal, but not required. As the instructor demonstrates the exercises, students…