Word Basics

This course will introduce new and existing users of Microsoft Word to the skills and knowledge needed to create common business documents including letters, memos and reports. You will also be introduced to Word’s proofing tools for spelling and grammar as well as the automatic proofing and formatting tools such as AutoCorrect and AutoFormat.

Course Outline

  • Duration: 1 day
  • Target Audience: New users of Microsoft Word
  • Prerequisites: An ability to work with Windows applications is required.
  • Versions: This course is suitable for users of Word 2010, 2013, 2016.

Learning Outcomes:

  • Navigate the Word screens
  • Create simple documents like letters and memos
  • Make basic changes to a document
  • Format text in a document
  • Use proofing tools
  • Use the online help system

Getting to know Word

  • Navigating the Word screens
  • Using the ribbon commands and dialog boxes

Creating a new document

  • Typing and editing text
  • Checking spelling and grammar
  • Saving a document

Working with a document

  • Opening existing documents and making changes
  • Selecting text blocks
  • Using find and replace
  • Copying and pasting

Formatting

  • Text
  • Paragraphs
  • Pages
  • Using autocorrect and autoformat

Using Autocorrect and AutoFormat

Using online help

  • Browsing for help

Cost

AUD$ 350 per person (in groups of three) at your premises.

AUD$ 600 (one-to-one) at your premises.

Excel Basics

This course introduces you to Excel spreadsheets and how they are used in business. You will learn to create, edit, format and print professional looking spreadsheets using simple formulas.

Course Outline

  • Duration: 1 day
  • Target Audience: This course will suit you if you are a beginner and are just getting started with Excel.
  • Prerequisites: Successful completion of Nom@d Learning Computer Fundamentals course or equivalent knowledge and skills are required to participate in this course.
  • Versions: This course is suitable for users of Excel 2010, 2013, 2016.

Learning Outcomes:

  • Start and explore Excel
  • Navigate around the workbook
  • Enter and edit data
  • Use simple formulas
  • Manipulate data
  • Format data
  • Preview and print data

Getting to know Excel

  • The Excel screen
  • Using short cut menus
  • Launching Dialog Boxes

Creating a new workbook

  • Typing text, numbers, dates and formulas
  • Making basic changes

Working with workbooks

  • Navigating using the keyboard
  • Using Go To

Editing in a workbook

  • Editing formulas
  • Clearing and deleting data in a cell
  • Using Undo and Redo

Selecting ranges

  • Selecting contiguous and noncontiguous ranges
  • Using special selection techniques
  • Selecting larger ranges

Copying data

  • Using Fill for quick copying
  • Copying from one range to another
  • Copying to another worksheet

Filling data

  • Filling a series
  • Filling using options
  • Creating a custom Fill list

Formulas and Functions

  • Creating formulas that add and subtract
  • Creating formulas that multiply and divide
  • Using the Sum Function to add
  • Finding an average
  • Finding a maximum and a minimum value
  • Common error messages

Font formatting

  • Changing fonts
  • Making text bold, italicised and underlined
  • Changing font colours
  • Using the Format Painter

Cell alignment

  • Aligning left, right and centre
  • Rotating, indenting, wrapping and merging text

Row and column formatting

  • Setting columns widths and row heights
  • Hiding rows and columns

Number formatting

  • Formatting as currency
  • Formatting percentages
  • Increasing and decreasing decimals

Printing

  • Previewing and printing a range
  • Printing an entire workbook

Applying borders

  • Applying a border to a range
  • Removing borders

Working with a worksheet

  • Worksheet zooming
  • Inserting, deleting, moving, copying and renaming a worksheets
  • Switching between worksheets

Worksheet techniques

  • Inserting, deleting, moving, copying and renaming a worksheet
  • Grouping worksheets
  • Freezing rows and columns

Page Setup

  • Page breaks
  • Settings rows as repeating print titles
  • Scaling to a percentage

Getting Help

  • Browsing for help

Cost

AUD$ 350 per person (in groups of three) at your premises.

AUD$ 600 (one-to-one) at your premises.

Goal Setting

What is your current mindset?

You need to have the right mind-set before attempting goal setting.

Start by believing in yourself, your ability to achieve your potential – not easy to I know, but it is achievable.

Where are you in your stage in life with your skills?

You have achieved a lot of life skills so far.

Do these stand you in good stead to move forward? Why not try and start with your current skills to date?

Can you let go of things?

Many of us dwell on past experiences. This drains us of positive energy.

These circumstances bring frustration, stress, and anxiety. We should strive to figure out what we can control and start there, letting go of the things that we cannot control.

Other tips:

  • Don’t limit yourself
  • Develop the right mind-set
  • Have a peer role model
  • Have the right kind of cheerleader
  • Handle stress better
  • Have small “wins”

App-eLearn Authoring Tool

I am excited to introduce App-eLearn, a new e-learning authoring tool to hit the Australian market in 2019.

App-elearn creates fully responsive, multi-device, HTML5 e-learning content using the award-winning Adapt developer framework.

Responsive e-learning design takes its inspiration from responsive web design; an approach that ensures a single version of a website or an e-learning course can provide a viewing experience optimised for different devices, from desktop to tablet to smartphone.

To find out more on how nom@d learning can help you build responsive e-learning content contact me for further details.

What is responsive design?

Over the past 5 years in Australia we have seen a massive uptake of smartphones and tablets, there’s been a massive tsunami how people access and consume content.

Nowadays, people expect better performance, easier engagement and greater expectations: yes, everyone wants to be able to access content (web, video, learning or whatever) on all of their devices, without compromise – by that we mean full experience, not some ‘dumbed down’ version’.

Video created by Roberto Blake. Please subscribe to his channel here.

Content creators are turning to flexible, dynamic layouts that work on all devices, to distribute rich content to mobile devices as well as desktops. This approach is known as responsive web design because the layout responds to the device’s viewport size and browser.

The flexibility offered by responsive design benefits both developer and user rather than offering multiple versions of a site or application. The biggest benefit to the developer is that only one fully featured site needs to be developed.

How do you respect your time?

Do you focus on the things that matter to you in your business? How do you value your time and deal with needy people? Can’t really take on more tasks?

Guess what? It may be time to take a good look at yourself, and start looking at how you respect other people, because your actions determine how you respect others’ time.

Here are some simple tips:

  • Tolerate frequent interruptions.
  • Be on time.
  • Meet deadlines.
  • Don’t keep others waiting.
  • Check with others if it’s ok to interrupt them.

Pursue happiness in the workplace

The pursuit of happiness is a never-ending one, no matter who you are or what you do for a living.

Thankfully, there are a variety of ways to make your workday more pleasant and productive, thereby increasing your chances of happiness.

No matter your situation, hopefully you’ll find something that contributes to a more positive work life.

Watch the video below to learn some tips for achieving happiness in the workplace:

Please note that nomad learning is in no way affiliated with the developer of these tutorials. All content included on this page is © GCFLearnFree.org.

Breaking through a creative block

When you’re on your creative A game, firing on all cylinders, it’s a great feeling. But what about the opposite end of the spectrum, when you find yourself struggling and the creativity just isn’t flowing? How do you break through this creative block?

Watch the video below to learn about breaking through a creative block:

Please note that nomad learning is in no way affiliated with the developer of these tutorials. All content included on this page is © GCFLearnFree.org.

Powered by WordPress.com.

Up ↑