Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
14 Hours
Testimonials (5)
well-prepared training, interesting topics
Maciek Boiski - Instytut Energetyki - Panstwowy Instytut Badawczy
Course - Microsoft Office Excel - poziom podstawowy
There was a good amount of information for the time of training. Also the trainer was very engaged with the group, especially when people were having troubles or asking questions. It was very nice of him to offer help in case of future ideas.
Aleksander Jarecki - Amazon Development Center Poland Sp. z o.o.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)
I generally enjoyed the practical examples.
Marika Agius
Course - Visual Basic for Applications (VBA) for Analysts
I was recently struggling with some pivot table issues and the course gave me the knowledge to work with pivot tables quicker, smarter and more efficiently.
Arina Moayed-Dzenisa - Universal-Investment-Gesellschaft mbH Branch Poland Sp. z o. o.
Course - Microsoft Office Excel - poziom średnio zaawansowany
The training was really useful. I liked the most the parts related to the pivot tables, filtering, lockup options and data consolidation. I appreciated trainer's excellent knowledge on the subject. His attitude was very good as well. He built open and 'not so formal' atmosphere which helped participants to ask the questions or speak about their daily excel issues. He was fully understandable during the whole training and his way of explaining the topics was direct and adequate.
