Effective working with spreadsheet in Excel Training Course

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