Udemyalltr

MS Excel : Ofisinizin Kahramanı Olun

Excel eğitiminde uzmanlaşın! Veri analizi, raporlama ve profesyonel Excel kullanımı öğrenin. Kariyerine değer kat!

4.3(246)
4,551students
14h 24m
Certificate
Can Uysal
Can UysalCan

Course Content

MS Excel : Ofisinizin Kahramanı Olun is an all-levels Udemy course taught by Can Uysal. It runs 14h 24m, is taught in Turkish, and includes a certificate of completion. Learners rate it 4.3 out of 5 from 246 reviews, with 4,551 students enrolled. It is a paid course, last updated August 2018.

Master Excel with this comprehensive course! This 15+ hour video course empowers you with skills you can use for a lifetime. Learn to leverage powerful Excel features to analyze data and create stunning visualizations.

Key Topics Covered:

  • Text Functions: Manipulate and extract information from text data.
  • Mathematical Functions: Perform calculations and solve mathematical problems within Excel.
  • Date Functions: Work with dates and times for accurate reporting and analysis.
  • Pivot Tables & Charts: Become proficient in creating and customizing pivot tables and charts. Learn to build insightful dashboards to showcase your data.
  • Macros: Automate repetitive tasks and streamline your workflow.
  • Dashboards: Design interactive dashboards for clear data presentation.
  • Professional Functions: Unlock advanced Excel functions for complex data analysis.
  • VLOOKUP & Lookup Functions: Master VLOOKUP and other lookup functions to efficiently find and retrieve data. Discover the lesser-known capabilities of VLOOKUP!
  • Data Validation: Ensure data accuracy and consistency with data validation rules.
  • Text to Columns: Easily convert data from a single column into multiple columns.
  • Keyboard Shortcuts: Boost your productivity with essential Excel keyboard shortcuts.
  • Data Types & Chart Selection: Choose the right chart type for your data and create compelling visualizations.
  • IF Functions & IS Functions: Use conditional logic to perform calculations based on specific criteria.
  • And much more!

Course Resources:

  • Access to all Excel files used in the lessons.
  • Free PDF resources to enhance your Excel skills (links provided).
  • New videos added regularly based on student questions.

Who is this course for?

This course is designed for both beginners with no prior Excel experience and those looking to refresh their skills. We focus on practical applications and solving common problems related to Pivot Tables and Pivot Charts.

While this course utilizes MS Excel 2016, many features are also available in MS Excel 2013.

Please note: Instructor-provided answers to questions asked in the course are not available to all students. Resources are provided for those who wish to access them.

$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.