Effective working with spreadsheet in Excel Training Course

Description

• Type

  Course

Description

Training for those working with a Microsoft Excel spreadsheet that would like to improve their work.

About this course

Requirements

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

Send

We will only publish your name and question

Request information

We are verifying your question adjusts to our publishing rules. According to your answers, we noticed you might not be elegible to enroll into this course, possibly because of: qualification requirements, location or others. It is important you consult this with the Centre.

Thank you!

We are reviewing your question. We will publish it shortly.

Or do you prefer the center to contact you?

Request information

Reviews

Have you taken this course? Share your opinion

Subjects

• Microsoft excel training
• Ms Office
• Painter
• Office IT
• Construction
• Graphics
• Excel
• Spreadsheet
• Printing
• MS Excel

Course programme

Edit spreadsheets

• Edit the contents of a cell
• Insert and delete cells
• Copying cells
• Copy and Paste commands
• The fill handle
• Fill command
• Series data and Autofill option
• Copying formulas
• Relative reference and absolute reference
• Appeals mixed
• Moving the cell
• The Office Clipboard
• Recall, repeat and redoing operations

Working with workbooks

• Excel Files
• Spreadsheets workbook
• Windows workbooks
• Save files to disk
• Opening an existing workbook

The use of functions in formulas

• Functions
• Construction features
• The function arguments.
• Enter a Function
• Math and trigonometry function
• Statistical Functions
• Logical Functions
• Search and address
• Information functions
• Date and Time Functions
• Text functions

Format Cells

• Formatting numbers
• Aligning
• Formatting fonts
• Borders
• Shaded cells
• Style
• Conditional formatting
• Format painter
• Psychological column width and row height
• Auto-fit
• AutoFormat
• Remove formatting from cells

Working with Graphic Objects

• Graphical objects
• Drawing Toolbar
• Drawing objects
• Inserting Images
• We work with graphics
• The order set of graphic objects

Creating Charts

• Charts
• Chart wizard
• Relationship data sheet of graph
• Data series and points
• Chart Elements
• Chart types
• Options charts
• Titles
• Axles
• The grid lines
• Legend
• Data labels
• Data table

Printing

• Printing
• Dialog, the Page Setup
• Print preview
• A dialog box, printing

Using lists

• Lists
• Transforming the range of the list
• Application forms
• AutoFilter
• Advanced filters
• Sorting
• Subtotals
• Functions operating on databases

Pivot tables

• Create and modify PivotTables
• Calculated fields and calculated members

Additional information

14 hours (usually 2 days including breaks)

See related categories

• Printing courses
• Distance learning Printing courses
• Construction courses
• Distance learning Construction courses
• Construction courses North Yorkshire
• Construction courses York
• MS Excel courses
• Distance learning MS Excel courses
• Courses in England
• Screen printing courses
• Nebosh construction certificate courses
• Nebosh construction courses
• Construction site management courses
• Excel vba courses
• Motion graphics courses
• Microsoft office specialist courses
• Office administration courses
• Excel 2007 courses
• Painter decorator courses
• Advanced excel courses
• Excel introduction courses
• Microsoft publisher courses
• Excel intermediate courses
• Construction project management courses
• Excel courses
• Distance learning Excel courses
• Distance learning Course
• Courses in North Yorkshire
• Courses in York
• Nobleprog Limited courses