Udemyalltr

Excel Eğitimi

Learn Excel from beginner to advanced! Master spreadsheets, data analysis, and powerful formulas. Boost your productivity with our comprehensive Excel training.

4.9(9)
17students
45m
Certificate
Fatih Eren
Fatih ErenFatih Eren

Course Content

Excel Eğitimi is an all-levels Udemy course taught by Fatih Eren. It runs 45m, is taught in Turkish, and includes a certificate of completion. Learners rate it 4.9 out of 5 from 9 reviews, with 17 students enrolled. It is a paid course, last updated November 2024.

Master Microsoft Excel: Boost Your Productivity & Reporting Skills

Unlock the power of Microsoft Excel and transform the way you work! This course equips you with essential skills to manage data, create insightful reports, and save valuable time. Go beyond basic spreadsheet use and gain a competitive edge.

What You'll Learn:

  • Fundamental Excel Operations: Build a solid foundation in Excel basics.
  • Data Formatting: Learn to format IBANs and other data types efficiently within Excel.
  • Data Entry & Manipulation: Master quick data filling techniques to streamline your workflow.
  • Formatting Power: Utilize the Fill Color tool for visually appealing and informative spreadsheets.
  • Text to Columns: Convert text data into organized columns for easier analysis.
  • Time-Saving Techniques: Quickly remove blank rows to optimize your spreadsheets.
  • Date Calculations: Determine the month of a given date.
  • Age Calculation: Automatically calculate age from a birthdate.
  • Data Cleaning: Effectively find and remove duplicate entries to ensure data accuracy.
  • Time Management: Accurately calculate the total of multiple time entries.
  • Day of the Week: Find the day of the week for any given date.
  • Text Manipulation: Ensure consistent text formatting throughout your spreadsheets.
  • Rounding Functions: Master various rounding functions (Round, Round Up, Round Down, Ceiling) for precise calculations.
  • Data Consolidation: Combine data from multiple Excel sheets using VLOOKUP.
  • Instant Reporting: Create dynamic reports with Pivot Tables.
  • Data Sorting: Sort data effectively for easy analysis and insights.
  • Freeze Panes: Use the dollar sign ($) to freeze sections of your spreadsheet for easier navigation.
  • Conditional Formatting: Identify duplicate values using conditional formatting.
  • Conditional Formatting - Between: Highlight values within a specific range using conditional formatting.
  • Conditional Formatting - Greater Than/Less Than: Apply conditional formatting based on value comparisons.
  • COUNTIF Function: Count data within tables using the COUNTIF function.
  • Averages: Calculate averages with ease.
  • MAX/MIN Functions: Find the maximum and minimum values in your data.
  • Text Combination: Combine first and last names into a single column.
  • Text Functions: Extract specific parts of text using functions like LEFT and RIGHT.
  • Text Functions: Extract portions of text using the MID function.
  • Date Formulas: Explore various date formulas for advanced calculations.

This course is designed for anyone looking to enhance their Excel skills for professional success. Learn to work with data effectively, create compelling reports, and make data-driven decisions.

$ 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.