{"id":1030,"date":"2025-01-13T14:52:38","date_gmt":"2025-01-13T11:52:38","guid":{"rendered":"https:\/\/sem.aydin.edu.tr\/en\/?p=1030"},"modified":"2026-01-29T13:54:11","modified_gmt":"2026-01-29T10:54:11","slug":"temel-excel-egitimi","status":"publish","type":"post","link":"https:\/\/sem.aydin.edu.tr\/en\/temel-excel-egitimi\/","title":{"rendered":"Basic Excel Training"},"content":{"rendered":"\n

What is Microsoft Excel?<\/strong><\/p>\n\n\n\n

Microsoft Excel is a spreadsheet program developed by Microsoft. Users can input data into cells and perform a wide variety of calculations, analyses, and create charts. Excel offers extensive data processing and analytical functions, allowing users to easily sort, filter, group, and summarize data. Advanced features such as macros and programming tools enable automated operations. Excel is widely used today and is one of the most common tools for data processing, analysis, and reporting in office environments.<\/p>\n\n\n\n

Who Should Use Microsoft Excel?<\/strong><\/p>\n\n\n\n

Microsoft Excel serves a broad audience and is used across many industries for different purposes:
Finance and Accounting:
Excel is used for creating financial statements, analyzing balance sheets and income-expenditure, performing tax calculations, and visualizing data relationships through financial functions.
Sales and Marketing:
Excel helps analyze sales data, track marketing expenses, manage customer data, and categorize, filter, and group information effectively.
Manufacturing and Engineering:
Excel is used to track production data, plan and scale operations, analyze performance, calculate costs, and manage engineering projects, including product development and process optimization.
Students:
\u2022 Collecting and analyzing data for projects or theses.
\u2022 Presenting data visually with charts and graphs.
\u2022 Performing statistical analyses on survey results or experimental data.<\/p>\n\n\n\n

<\/p>\n\n\n\n

Training Content:<\/strong><\/p>\n\n\n\n

\u00a01. Getting Started<\/strong><\/p>\n\n\n\n

1.1 Definition and Purpose of Excel
1.2 Installation and Version Differences<\/p>\n\n\n\n

\u00a02. Worksheet Operations<\/strong><\/p>\n\n\n\n

2.1 Starting Excel \/ Interface Overview \/ Menus
2.2 File Menu and Templates<\/p>\n\n\n\n

\u00a03. Workbook Operations<\/strong><\/p>\n\n\n\n

3.1 Difference Between Workbook and Worksheet (Basic Structure)
3.2 Worksheet Management<\/p>\n\n\n\n

\u00a04. Cells and Data Operations<\/strong><\/p>\n\n\n\n

4.1 Cell Operations
4.2 Entering and Editing Data
4.3 Row and Column Operations
4.4 AutoComplete
4.5 Autofill
4.6 Custom Lists
4.7 Adding Comments and Notes
4.8 Find and Replace<\/p>\n\n\n\n

5. Formatting<\/strong><\/p>\n\n\n\n

5.1 Cell Formatting
5.2 Cell Styles
5.3 Format Painter<\/p>\n\n\n\n

\u00a06. Page Setup and Printing<\/strong><\/p>\n\n\n\n

6.1 Printing
6.2 Page Setup
6.3 View Options<\/p>\n\n\n\n

\u00a07. Basic Mathematical Operations<\/strong><\/p>\n\n\n\n

7.1 Basic Calculations
7.2 Fundamental Mathematical Functions
7.3 Cell Referencing<\/p>\n\n\n\n

\u00a08. Data Tables and Management<\/strong><\/p>\n\n\n\n

8.1 Sorting
8.2 Filtering
8.3 Subtotals
8.4 Advanced Filtering<\/p>\n\n\n\n

\u00a09. Logical Functionsr<\/strong><\/p>\n\n\n\n

9.1 IF Functions
9.2 Nested IF Functions
9.3 AND \/ OR Functions<\/p>\n\n\n\n

\u00a010. Conditional Formatting<\/strong><\/p>\n\n\n\n

10.1 Conditional Formatting
10.2 Icon Sets
10.3 Using Formulas in Conditional Formatting<\/p>\n\n\n\n

\u00a011. Conditional Operations<\/strong><\/p>\n\n\n\n

11.1 Creating Conditional Operations
11.2 Removing Duplicates
11.3 Multi-Criteria Functions
11.4 Multi-Criteria Functions \u2013 Part 2<\/p>\n\n\n\n

\u00a012. Text Operations<\/strong><\/p>\n\n\n\n

12.1 Converting Text to Columns \/ Text Functions
12.2 Data Cleaning
12.3 Flash Fill<\/p>\n\n\n\n

\u00a013. Lookup and Reference Functions<\/strong><\/p>\n\n\n\n

13.1 Lookup and Reference Functions<\/p>\n\n\n\n

\u00a014. Date Functions<\/strong><\/p>\n\n\n\n

14.1 Date Functions<\/p>\n\n\n\n

\u00a015. Charts<\/strong><\/p>\n\n\n\n

15.1 Column Chart
15.2 Line Chart
15.3 Pie Chart
15.4 Combined and Map Charts
15.5 3D Map
15.6 Sparklines<\/p>\n\n\n\n

\u00a016. Data Validation<\/strong><\/p>\n\n\n\n

16.1 File Protection
16.2 Data Validation<\/p>\n\n\n\n

17. Pivot Tables<\/strong><\/p>\n\n\n\n

17.1 Introduction to Pivot Tables
17.2 Value Display
17.3 Grouping
17.4 Classification
17.5 Page Filtering
17.6 Pivot Charts<\/p>\n\n\n\n

\u00a018. Macros<\/strong><\/p>\n\n\n\n

18.1 Introduction to Macros
18.2 Accessing Macro Code
18.3 Using Relative References<\/p>\n\n\n\n

Training Duration: <\/strong>15 hours \u2013 Online (Live Sessions)<\/p>\n\n\n\n

For More Information:<\/strong><\/p>\n\n\n\n

\u2022 Phone: 0532 334 53 79
\u2022 Email: sem@aydin.edu.tr<\/p>\n\n\n\n

Payment Options:<\/strong>
\u2022 Online Payment:http:\/\/op.aydin.edu.tr\/sem\/uzapp\/<\/a>
\u2022 Cash or Credit Card at campus
\u2022 Bank EFT \/ Wire Transfer<\/p>\n\n\n\n

Bank Account:<\/strong><\/p>\n\n\n\n

T.C. \u0130STANBUL AYDIN \u00dcN\u0130VERS\u0130TES\u0130
YAPI KRED\u0130 BANK, SEFAK\u00d6Y BE\u015eYOL BRANCH
Branch Code: 815
Account No: 70356668
IBAN: TR46 0006 7010 0000 0070 3566 68<\/p>\n","protected":false},"excerpt":{"rendered":"

What is Microsoft Excel? Microsoft Excel is a spreadsheet program developed by Microsoft. Users can input data into cells and perform a wide variety of calculations, analyses, and create charts. Excel offers extensive data processing and analytical functions, allowing users to easily sort, filter, group, and summarize data. Advanced features such as macros and programming […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[40,13,16],"tags":[],"class_list":["post-1030","post","type-post","status-publish","format-standard","hentry","category-digital-and-it-training","category-general","category-programs"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/sem.aydin.edu.tr\/en\/wp-json\/wp\/v2\/posts\/1030","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sem.aydin.edu.tr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sem.aydin.edu.tr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sem.aydin.edu.tr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sem.aydin.edu.tr\/en\/wp-json\/wp\/v2\/comments?post=1030"}],"version-history":[{"count":3,"href":"https:\/\/sem.aydin.edu.tr\/en\/wp-json\/wp\/v2\/posts\/1030\/revisions"}],"predecessor-version":[{"id":2553,"href":"https:\/\/sem.aydin.edu.tr\/en\/wp-json\/wp\/v2\/posts\/1030\/revisions\/2553"}],"wp:attachment":[{"href":"https:\/\/sem.aydin.edu.tr\/en\/wp-json\/wp\/v2\/media?parent=1030"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sem.aydin.edu.tr\/en\/wp-json\/wp\/v2\/categories?post=1030"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sem.aydin.edu.tr\/en\/wp-json\/wp\/v2\/tags?post=1030"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}