Karen Horn
INTRO TO EXCEL – Virtual Course
This 3-hour session will introduce you to the capabilities of the MS Excel program. Learn the basics of what you can do with the powerful electronic spreadsheet program including: Purpose of spreadsheetsMoving around the screenUsing the ‘Ribbon’Entering dataCreating basic formulasSelecting cellsWorking with workbooksViewing & printing Date: September 15, 2022 Time: 9:00 a.m. – Noon Cost:…
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…
CREATING OPPORTUNITIES WITH RESPECT & EMPATHY DE-ESCALATION – FACE TO FACE
Yellowknife North Slave Campus 5004 54 St, Yellowknife, NT, CanadaIntroduction Introduction SequenceTraditional lecture vs. skill based learningDe-escalation OverviewGoals of the course Part I: Realizing Expectations Being a professional brings expectations from:- The organization, the public, the media and the courtsNatural reactions in the face of conflict – Fight, Flight or Freeze- Exceptions are those who benefited from: great parents, great mentors, the Anvil of…
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.…
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…
SPEAK UP, SPEAK OUT
Yellowknife North Slave Campus 5004 54 St, Yellowknife, NT, CanadaSurveys indicate that many people list public speaking as their greatest fear – while fear of death is listed farther down the list! If you are someone who would rather die than speak up in public, this one-day course is for you. In addition to learning what it takes to be effective in any public…
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…