Last updated
Kurskod
3094
Varaktighet
14 timmar (vanligtvis 2 dag inklusive pauser)
Krav
Knowledge of Windows
Översikt
Utbildning för dem som arbetar med Microsoft Excel skivor som vill förbättra sitt arbete.
Kursplan
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
Vittnesmål
We also do Consultancy!
We work with leading clients across a wide range of technologies!
Reach out for Project | Staff Enhancement | System Audit Consulting