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
Introduction
- Basic information about the program
- Construction of the main window
- Operations on workbooks (notebooks) and sheets
Entering and modifying data in spreadsheet cells
Formatting data
- Determining how to display different types of data and calculation results (eg, dates, amounts, percentages or fractions)
- Determining the edge and the background of the cells
- Formatting row and column titles
- Using Styles
Navigation
- Moving up in large sheets
- Parallel work on multiple spreadsheets / workbooks
Copying and moving data
- Select areas (cell ranges)
- Moving data
- Paste Special
- Autofill cell strings (series) of data (for example, order numbers and dates of the next working day)
Formula, addresses and cell names
- Create, modify and copy formulas
- Circular references
- Conditional formatting
- The address types and their use
- References to other worksheets and workbooks
- Using cell names
Functions
- General rules for using the function
- Frequently used functions
- Nesting functions
- Using the conditional
- The Function Wizard
Charts
- The main chart types and their use
- General principles for creating compelling charts
- Creating Charts.
- Components of graphs and their modification
- Create your own chart types
Requirements
- A basic understanding of computers
Audience
- Data Analysts
14 Hours
Testimonials (5)
Explanations "in everyone's language"; the fact that every time our questions were answered and it was explained to us in at least 2 ways what, how and from where; the relaxed atmosphere and the fact that although there was a lot about mathematics, I didn't feel that; the trainer's experience proven through reasoned explanations, but never demonstrative; the trainer's passion: it is clear that he likes what he does :)
Alex - DEICHMANN SRL
Machine Translated
The practice
Eliza - DEICHMANN SRL
Course - Excel Basics
Most of all I appreciated the trainer's way of interacting with all the trainees, the willingness to provide any information requested and the interest given to each topic so that it is well understood. The course was very interactive, with lots of information and examples, and also the exercises were very useful for checking and consolidating knowledge.
Alex - DEICHMANN SRL
Machine Translated
some new functions i did knew before, such as power query; fomat cell -alignment-fill
Bella - fu ma si jing mi duan jian (da lian) you xian gong si
Course - Excel Basics
The guy was really helpful and knowledgeable and i really learned a lot in two days.
