Excel for Business Life, From Beginning to Advanced
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
Requirements
- You just need to know that you need Excel to take this course.
Description
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.
Who this course is for:
- Every employee that uses Excel
Instructor
Kenan Çılman graduated from Istanbul Technical University, Department of Industrial Engineering in 2004.
He is gives lectures about finance, advanced Excel and software courses in many universities and academies, as well as developing projects and software with Excel. He also creates and publishes games and programs in android and Excel as a hobby (published at excelsizeyeter website). He is expert of Php, CSS, Visual Basic, html, Excel Macro, JQuery, Javascript, SQL, MySql, Power Query and Android.
He started to his finance career and worked on corporate valuation reports, public offerings, sales / change of hands (Merger & Acquisition) and lease certificates in 2006.
In parallel with his finance career, he continued to carry out software activities and created important financial software to the market by combining both professions. These include: financial advisory program, algorithmic order system, share-based buy / sell models, hedging models, stock exchange models, special fund management systems, credit rating models, partnership structure simplification models and systems, accounting programs, company news tracking systems, company valuation models, business plans, feasibility models, participation index model, what-if analysis etc. He has created and released more than one hundred programs. The programs and reports have been published in the CMB bulletins and in the activity reports of public companies, as well as some news sites (such as Habertürk). Until now, Turkey's many leading companies had consulting and training services from him. He held all the CMB licenses and served as a Board Member of the Participation Board until 2013.
Kenan Çılman conducts valuation expertise and training activities in institutions and gives Advanced Excel, Excel Macro (VBA), Company Valuation, Financial Modeling, Financial Mathematics and Credit Modeling courses.