Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
12 Hour(s) 58 Minute(s)
Language
English
Taught by
Kenan Çılman
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Learn Excel, develop strategy, solve business life affairs
This course is ideal for anyone who wants to learn Excel. The course is designed with an understandable and easy in English. The main goal of the course is to teach all the requirements you need in business life and to use Excel in the most efficient manner.
All videos here have examples and Excel files, and all of them are examples of real business life.
Course Content
- 8 section(s)
- 61 lecture(s)
- Section 1 Introduction
- Section 2 For Beginners
- Section 3 Data Management in Excel
- Section 4 Excel Formulas
- Section 5 Advanced Excel
- Section 6 Graphics in Excel
- Section 7 Linear Modelling in Excel
- Section 8 Useful Tips
What You’ll Learn
- Excel Fundamentals
- Formats, Fonts and Design
- Worksheet Properties
- Data Management in Excel
- Data Sort
- Data Sort From Left to Right
- Data Filter
- Table
- Remove Dublicates
- Custom List
- Subtotal and Data Groups
- Pivot Table
- Pivot Table Properties and Options
- User Defined Formulas in Pivot Table
- Merge Pivot Tables
- Excel Formulas
- Structure of Excel Formulas
- Text Formulas
- Flash Fill
- Statistical Formulas
- Date and Time Formulas
- SUBTOTAL Function For Filter
- Lookup Functions
- VLOOKUP For 2 Tables
- Advanced Filter Functions
- FORMULAS Menu
- Advanced Excel
- Data Validation
- Conditional Formatting
- Special Cells (GOTO SPECIAL)
- External Data From Other Sources
- Name Manager
- Consolidation
- Watch Window and Trace Cells
- Excel Protection
- Printer Settings
- Relation of PDF and Printer
- Graphics and Charts in Excel
- Simple Graphs
- Column Graphs
- Pie Chart Graphs
- Picture Graphs
- Graphics into the Cells
- Linear Modelling in Excel
- Goal Seek
- What-if Analysis / Data Table
- Excel Solver
- Senario Analysis
- Useful Tips
- Copy - Paste Options
- F4 Key
- Fix Headers
- VIEW Menu
- ComboBox
- Trendline
- Spin Button
- Animated Charts
- Scroll Bar
- Draw Shapes
- Fix Formulas (Details of F4 Key)
- Creating Custom Menu
- Watch Movie and Listen Music in Excel
Skills covered in this course
Reviews
-
MMuhammet Faruk Safa
Çok verimli bir eğitimdi🙏
-
UUdemy Hoca
teşekkürler
-
AAngie Castejon
Very detailed and informative.
-
AAbdullah Akıllıoğlu
Perfect
