Course Outline
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
Requirements
Knowledge of Windows
Testimonials
the way of providing information, simple readability, the ability to make contact
Pirelli
adjusting the scope of training to the actual needs at my workplace
Marcin Ostrówka
pivot tables
Jakub Poradzisz - Inspire Sourcing
Approach to different levels of participants' advancement
Jan Poradzisz - Inspire Sourcing
Strengthening the foundations, accurate explanation of all issues.
Barbara Poradzisz - Inspire Sourcing
Work on participants' examples and on-going answers to key issues. Contact with participants and a lot of smile :-) Practical approach!
Katarzyna Klimczak - Inspire Sourcing
Work and exercises on our case stud.
Lidia Poradzisz - Inspire Sourcing
Kamil's great knowledge and individual approach to the pace of the group. The trainer with great flexibility approached the various personalities of the participants and the level of knowledge as well as numerous questions. Full professionalism.
Magdalena Ryszka - Inspire Sourcing
High knowledge and skills on the part of the trainer, great help and accessibility for participants, very good training atmosphere, excellent training! :)