Course not currently available
Effective working with spreadsheet in Excel Training Course
Course
In York ()
£ 2,150
VAT inc.
Description
-
Type
Course
Training for those working with a Microsoft Excel spreadsheet that would like to improve their work.
About this course
Knowledge of Windows
Reviews
Have you taken this course?
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
- Excel Files
- Spreadsheets workbook
- Windows workbooks
- Save files to disk
- Opening an existing workbook
- 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
- 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
- Graphical objects
- Drawing Toolbar
- Drawing objects
- Inserting Images
- We work with graphics
- The order set of graphic objects
- 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
- Dialog, the Page Setup
- Print preview
- A dialog box, printing
- Lists
- Transforming the range of the list
- Application forms
- AutoFilter
- Advanced filters
- Sorting
- Subtotals
- Functions operating on databases
- Create and modify PivotTables
- Calculated fields and calculated members
Additional information
14 hours (usually 2 days including breaks)
Effective working with spreadsheet in Excel Training Course
£ 2,150
VAT inc.