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 (7)
Division into tasks and topics.
Anna
Course - Excel Basics
Machine Translated
a lot of exercises
Monika
Course - Excel Basics
Machine Translated
knowledge, method of conducting workshops
Karol
Course - Excel Basics
Machine Translated
Useful information, proper pace of performing individual exercises, clear explanation of theory
Krzysztof
Course - Excel Basics
Machine Translated
Very thoroughly explained. The instructor has a lot of knowledge. The time flew by quickly. I didn't feel like it was dragging. More trainings like this.
Magdalena
Course - Excel Basics
Machine Translated
the entire training, the calmness of the instructor
Malgorzata
Course - Excel Basics
Machine Translated
Contact with training participants, knowledge
Anna
Course - Excel Basics
Machine Translated