Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
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
Requirements
Knowledge of Windows and the basics of MS Excel
Testimonials
The trainer's skills
Katarzyna Zarazka
Dużo ćwiczeń, zwięzła teoria.
Monika
Spokój i tłumaczenie materiału
Paulina
Attention to details, solving problem till it's solved.
Trener by zainteresowany tym jakie zagadnienia nas interesuja i w jaki sposób wykorzystujemy Excel w pracy.
Na początku prowadzący zapytał nas o naszą pracę i o to, jak pracujemy z Excelem oraz czego potrzebujemy się nauczyć, co nadało fajny rytm zajęciom. Wielki plus za anielską cierpliwość :)
power query
Related Courses
Analysing Financial Data in Excel
14 hours
Excel For Statistical Data Analysis
14 hours
Excel Advanced with VBA
21 hours
Excel Advanced
14 hours
Excel Data Analysis
14 hours
Financial Analysis in Excel
14 hours
VBA For Access & Excel
21 hours
Excel Basics
14 hours