Excel Basics Training Course

Nobleprog Limited

Course

In City Of London

Price on request

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Location

    City of london

The course participants will be able to efficiently use primarily data analysis tools such as scenarios and pivot tables, use the features to perform calculations on dates and text-processing functions, and create and adapt to the needs of macros to automate work with spreadsheets.

Facilities

Location

Start date

City Of London (London)
See map
Token House, 11-12 Tokenhouse Yard, EC2R 7AS

Start date

On request

Questions & Answers

Add your question

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

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Excel
  • Options
  • Database Management
  • Database
  • Database training
  • Data analysis
  • Logic
  • Graphics
  • Web
  • MS Excel

Course programme

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

See related categories

Excel Basics Training Course

Price on request

The best Excel courses

See all

See all