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 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.
Who Should Use Microsoft Excel?
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:
• Collecting and analyzing data for projects or theses.
• Presenting data visually with charts and graphs.
• Performing statistical analyses on survey results or experimental data.
Training Content:
1. Getting Started
1.1 Definition and Purpose of Excel
1.2 Installation and Version Differences
2. Worksheet Operations
2.1 Starting Excel / Interface Overview / Menus
2.2 File Menu and Templates
3. Workbook Operations
3.1 Difference Between Workbook and Worksheet (Basic Structure)
3.2 Worksheet Management
4. Cells and Data Operations
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
5. Formatting
5.1 Cell Formatting
5.2 Cell Styles
5.3 Format Painter
6. Page Setup and Printing
6.1 Printing
6.2 Page Setup
6.3 View Options
7. Basic Mathematical Operations
7.1 Basic Calculations
7.2 Fundamental Mathematical Functions
7.3 Cell Referencing
8. Data Tables and Management
8.1 Sorting
8.2 Filtering
8.3 Subtotals
8.4 Advanced Filtering
9. Logical Functionsr
9.1 IF Functions
9.2 Nested IF Functions
9.3 AND / OR Functions
10. Conditional Formatting
10.1 Conditional Formatting
10.2 Icon Sets
10.3 Using Formulas in Conditional Formatting
11. Conditional Operations
11.1 Creating Conditional Operations
11.2 Removing Duplicates
11.3 Multi-Criteria Functions
11.4 Multi-Criteria Functions – Part 2
12. Text Operations
12.1 Converting Text to Columns / Text Functions
12.2 Data Cleaning
12.3 Flash Fill
13. Lookup and Reference Functions
13.1 Lookup and Reference Functions
14. Date Functions
14.1 Date Functions
15. Charts
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
16. Data Validation
16.1 File Protection
16.2 Data Validation
17. Pivot Tables
17.1 Introduction to Pivot Tables
17.2 Value Display
17.3 Grouping
17.4 Classification
17.5 Page Filtering
17.6 Pivot Charts
18. Macros
18.1 Introduction to Macros
18.2 Accessing Macro Code
18.3 Using Relative References
Training Duration: 15 hours – Online (Live Sessions)
For More Information:
• Phone: 0532 334 53 79
• Email: [email protected]
Payment Options:
• Online Payment:http://op.aydin.edu.tr/sem/uzapp/
• Cash or Credit Card at campus
• Bank EFT / Wire Transfer
Bank Account:
T.C. İSTANBUL AYDIN ÜNİVERSİTESİ
YAPI KREDİ BANK, SEFAKÖY BEŞYOL BRANCH
Branch Code: 815
Account No: 70356668
IBAN: TR46 0006 7010 0000 0070 3566 68