Word and Excel Basics Training Course

Course Code

3090

Duration

21 hours (usually 3 days including breaks)

Overview

Course participants will learn how to create a aesthetic professional-looking documents in a word processor Microsoft Word. The course participants will be able to efficiently perform a variety of calculations in a transparent way to organize and present their results, use multiple mechanisms to facilitate and accelerate the creation of spreadsheets in Excel.

Course Outline

Word

Introduction to the use of text editors

  • Possibilities of computer text processing.
  • Creating and saving documents
  • Quick and precise navigation through the document

Style

  • The importance of style for easy maintenance of consistency, transparency and aesthetics document
  • Style groups and their applications
  • Quickly change the basic text formatting
  • Format titles and typographical resources used to distinguish them
  • General rules for obtaining clarity and aesthetic texts

Letters - bullet points and lists

  • Use bullet points and calculations
  • Maintaining a consistent look throughout the document lists
  • Quickly change the appearance of a letter
  • Rearranging or level for the list item

The construction and use of tables

  • Inserting tables
  • Aesthetics and transparency tables (such as changing font sizes, font size and edges, internal margins and background color of the cells)
  • Modifying tables (such as adding and removing columns and rows, and create headers common to several columns)

Headers and footers to pages

  • The use of
  • Setting a separate header / footer for the first page of the document
  • Using automatic page numbering (including numbers such as "Number next page / number of pages in the document")
  • Insert information on all pages of the document metrics (eg title, author, or date of update)
  • Change the font and size of letters for numbers (independently from the rest of the contents of the header / footer)

Excel

Introduction

  • Basic information about the program
  • Construction of the main window
  • Operations on workbooks (notebooks) and sheets

Entering and modifying data in spreadsheet cells

Formatting data

  • Determining how to display different types of data and calculation results (eg, dates, amounts, percentages or fractions)
  • Determining the edge and the background of the cells
  • Formatting row and column titles
  • Using Styles

Navigation

  • Moving up in large sheets
  • Parallel work on multiple spreadsheets / workbooks

Copying and moving data

  • Select areas (cell ranges)
  • Moving data
  • Paste Special
  • Autofill cell strings (series) of data (for example, order numbers and dates of the next working day)

Formula, addresses and cell names

  • Create, modify and copy formulas
  • Circular references
  • Conditional formatting
  • The address types and their use
  • References to other worksheets and workbooks
  • Using cell names

Functions

  • General rules for using the function
  • Frequently used functions
  • Nesting functions
  • Using the conditional
  • The Function Wizard

Charts

  • The main chart types and their use
  • General principles for creating compelling charts
  • Creating Charts.
  • Components of graphs and their modification
  • Create your own chart types

Testimonials

★★★★★
★★★★★

Related Categories

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in the UK!

As a Business Development Manager you will:

  • expand business in the UK
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!