Course not currently available

Working with spreadsheet in Microsoft Excel Training Course

Course

Online

£ 1,750 VAT inc.

Description

  • Type

    Course

  • Methodology

    Online

The course participants will be able to efficiently perform a variety of calculations in a transparent way to arrange and present their results, use multiple mechanisms to facilitate and accelerate the creation of spreadsheets, as well as protect the calculations and their results against unauthorized persons

About this course

Knowledge of Windows

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Microsoft Excel
  • Spreadsheet
  • Data Protection
  • Construction
  • Graphics
  • Printing
  • Microsoft excel training
  • MS Excel
  • Construction Training

Course programme

Introduction
  • Basic information about the program
  • Construction of the main window
  • Operations on workbooks (notebooks) and sheets
Entering and modifying data in worksheet cells Formatting data
  • Determining how to display different types of data and calculation results (eg, dates, amounts, percentages or fractions)
  • Determining the edge of the cell and the background
  • Formatting row and column titles
  • Using Styles
Navigation
  • Moving up in extensive sheets
  • Concurrent work on multiple worksheets / workbooks
Copying and moving data
  • Select areas (cell ranges)
  • Moving data
  • special insert
  • Autofill sections (series) of data (for example, ordinals 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
  • Nested functions
  • Using the conditional
  • The Function creator
Graphics in spreadsheets
  • AutoShapes and WordArt
  • static and dynamic data images
Charts
  • The main chart types and their applications
  • General principles for creating compelling charts
  • Creating charts
  • Components of graphs and their modification
  • Create owns chart types
Hiding and Data Protection
  • Hiding sheets, columns, and rows
  • Hide formulas and cell entries
  • Protect worksheet and workbook from changes
  • Protecting workbooks before opening
Print
  • Printing sheets and areas of discontinuous
  • Printing charts

Additional information

14 hours (usually 2 days including breaks)

Working with spreadsheet in Microsoft Excel Training Course

£ 1,750 VAT inc.