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
Testimonials (2)
perfect adaptation of materials to the group, detailed discussion of issues, very high competence, very good contact with the group, high ability to transfer knowledge,
Malgorzata - LKQ Polska Sp. z o. o.
Course - Excel Basics
Machine Translated
Communication, method of transferring knowledge, openness
Barbara - LKQ Polska Sp. z o. o.
Course - Excel Basics
Machine Translated