Certificate for Kinga Holeksa
Certificate ID:
749799
Authentication Code:
4c38f
Certified Person Name:
Kinga Holeksa
Trainer Name:
Marcin Tatuś
Duration Days:
2
Duration Hours:
14
Course Date:
2024-01-08 09:00 to 2024-01-09 16:00
Course Outline:
Excel basics
- Excel data types - How Excel treats date and time
- Searching for values in a spreadsheet - Find and mark
- Sheet protection
- Data accuracy
- Create a data series
- Autocorrect
- Instant Fill
- Go To Special
- Paste Special
- Text as columns
- Quick access bar
- Good sheet creation practices
- Keyboard shortcuts
- Cell formatting
- Conditional formatting
Creating formulas
- Inserting functions
- Editing formulas
- Logical functions
- Mathematical functions
- Search Functions
- Text functions
- Date and time functions
- Summing the contents of cells with a button AutoSum
- Adding functions using a dialog box
- Formula evaluation
- Specifying the location of values
- Naming the range
- Modify named ranges
- Use named ranges in formulas
Create a PivotTable
- Basic information about pivot tables
- Overview of pivot table report fields
Creating charts and pivot charts
- Create pivot charts
- Change the chart type
Course Name Eng:
Microsoft Office Excel - intermediate level