- 00:00Introduction03:09Exercise 0105:15Dynamic Arrays07:31Spill and Arrays18:23Extract and Count Unique Entries24:38Unique vs. Distinct28:02Unique with Multiple Criteria31:13Unique Values by Column35:37SORT Function44:30Horizontal Sort50:38SORTBY Function56:47Horizontal SORTBY59:52Sequence and Unstacking Records1:10:02Filter Function1:16:59Using Filter with Logic Plus Operator1:21:47Using Filter with Logic Asterisk Operator1:27:27Using Filter with Logic Equals Operator1:31:40Using Filter with Logic Minus Operator1:36:29RANDARRAY and RANDBETWEEN1:46:11XLookUp1:58:34XMatch2:04:55Exercise 022:18:04Two-way Lookups2:26:29CHOOSE Function2:36:33SWITCH Function2:41:03Exercise 032:48:11Median and Mode2:54:25Using LARGE and SMALL3:01:58Ranking Data3:09:39COUNTBLANK Function3:14:25Exercise 043:21:31Rounding Values3:28:29Specialized Rounding3:33:00Aggregate Function3:37:31Exercise 05
- 00:00Intro to Excel01:09What's New In Excel 201909:01Course Overview10:18Overview of the Excel window18:44Mouse-Features21:57Backstage View24:35Entering Text and Numbers in Excel29:06Creating Basic Formulas in Excel35:56Relative References in Excel38:57Order of Operations in Excel43:45Working with Ranges in Excel48:22Module 2 - Practice Exercise49:56Working with the Save and Save As Commands54:31File Extensions, Share, Export and Publish Files58:36Module 3 - Practice Exercise59:34Opening a File in Excel1:05:06Working with Larger Files in Excel1:10:41Freeze Panes in Excel1:13:57Split Screen in Excel1:21:03Module 4 Exercise1:23:51Headers and Footers in Excel1:31:15Print Titles1:34:07Comments in Excel1:39:31Page Setup Options in Excel1:47:01Fit to Print on One Page in Excel1:51:00Printing Workbooks in Excel1:54:56Module 5 Exercise1:56:49Adding and Deleting Columns and Cells2:03:00Changing Column and Rows Widths2:06:49Module 6 Exercise2:07:58Copt, Cut and Paste2:15:06Copying Formulas2:20:18Module 7 Exercise2:21:36Overview of Formulas2:24:24Create Formulas Using Functions part12:34:28Create Formulas Using Functions part22:39:53Absolute Values2:45:12Module 8 Exercise2:46:30Adding Deleting and Renaming Sheets2:50:38Additional Sheet Tab Options2:55:583 Dimensional Formulas3:01:29Module 9 Exercise
- 02:381 Introduction to MS Excel13:482 Organizing Data25:103 Basic Excel Formulas | Important Formulas for Beginners35:474 How to use the Excel IF function46:545 Pivot Tables in Excel | How to Create a Pivot Table in Excel57:046 Text Functions in Excel | Excel TEXT Function - Formula and Examples1:07:297 Cell Reference in Excel with Examples1:18:298 Text to Columns in Excel | How to Use Text-to-Columns in Excel1:28:049 How to Use Paste Special + How to Use Speak Cells Feature in Excel1:39:1010 Custom List in Excel + Using Advanced Fill in Excel1:49:3011 Flash Fill in Excel + Series features1:59:4812 Nested IF, AND, IF ERROR Function ( Logical Functions in Excel)2:11:5113 Comments and Custom Views2:22:0314 How to Make Charts and Graphs in Excel2:32:5915 Excel DATE function with examples + Mathematical Functions2:44:3316 How to Rotate Text in Cells in Excel + How to Print in Excel2:55:0417 How to use Header and Footer in MS Excel3:05:2418 Data validation in Excel3:15:4919 How to Record a Macro in Excel3:27:1220 Relative References in Excel3:38:1321 How to Make a Macro in Excel | Write Macros in Excel3:49:5122 Name Array in MS Excel4:00:2123 How To Use VLOOKUP in Excel4:10:1224 Approximate Match and VLOOKUP rules4:21:2125 Consolidate Data in Excel | Excel Consolidate Function4:32:0426 Count Functions in MS Excel4:43:0027 Single Criteria Statistical functions4:53:4228 Multiple Criteria Statistical Functions in Excel5:04:2629 How to use Index, Match, Lookup and HLookup in Excel5:16:2230 Protection Rules in MS Excel | Protecting a Worksheet's Format Excel5:26:5531 Create Hyperlinks in Excel | Links in MS Excel5:37:4132 Data Sorting In MS Excel | How to Sort Lists in Excel5:48:0733 Filtering Data | How to Filter in Excel5:58:4834 Advanced Filters in MS Excel6:09:1435 Chart Shortcuts in MS Excel | Create Excel Chart With Shortcut Keys6:19:3736 Combo Charts and Pie Charts in MS Excel6:31:0737 Spark Line Charts in MS Excel6:41:2638 Pivot Chart in MS Excel6:52:2539 Conditional Formatting in Excel : Part 17:02:5240 Conditional Formatting in Excel : Part 27:13:1341 Conditional Formatting for Icon Sets - How to use Icon Sets7:23:3542 Advanced Conditional Formatting Formulas in MS Excel7:32:1743 Customizing Pivot Tables Part 17:43:4044 Customizing Pivot Tables Part 27:53:5545 Pivot Table Item Slicers | Excel Pivot Table Slicers8:04:5246 Slicer and Timeline over Pivot Table in MS Excel8:15:0347 Dependent Dropdown Lists in MS Excel8:25:3648 Summary Report in MS Excel | How to Create an Excel Summary Report8:35:3449 Objects In Ms Excel | Excel Worksheet Objects8:45:5850 Table vs Cell Range in MS Excel8:56:1051 Slicers on Charts in MS Excel | Slicer Controlled Interactive Charts9:06:4052 How to Create a Linked Object in Microsoft Excel9:16:4653 Ctrl Shortcuts in MS Excel9:27:0854 Function Keys Shortcut In Microsoft Excel9:37:2355 Alt Key Shortcuts in MS Excel (Keyboard shortcuts in Excel)9:46:5556 Shift + Function Key shortcuts in MS Excel9:57:5457 Ctrl + Function Key Shortcuts In Ms Excel10:08:2258 Alt And Shift With Special Keys Shortcuts In Ms Excel10:19:2859
- 00:00Introduction00:22Course Intro02:42Excel 2021 vs Excel 36508:21Launching Excel12:00The Start Screen22:12Exploring the Interface33:51Ribbons, Tabs and Menus42:20Backstage Area47:00Quick Access Toolbar56:45Useful Keyboard Shortcuts1:06:27Getting Help1:13:04Exercise 011:15:27Working with Templates1:24:30Workbooks and Worksheets1:32:04Saving Workbooks1:40:50Entering and Editing Data1:50:43Navigating and Selecting Cells, Rows, and Columns1:58:02Exercise 022:03:22Formulas and Functions Explained2:15:06SUM Function2:22:44COUNT Function2:30:10AVERAGE Function2:34:27MIN and MAX Function2:36:52Handling Errors in Calculations2:45:34Absolute vs Relative Referencing2:52:29Autosum and Autofill Options3:02:12Flash Fill3:07:15Exercise 033:12:26What are Named Ranges3:21:33Managing Named Ranges3:25:22Using Named Ranges3:30:42Exercise 043:35:00Applying Number Formats3:45:03Applying Date and Time Formats3:50:41Formatting Cells, Rows and Columns3:59:20Format Painter4:04:00Exercise 054:08:11Working with Rows and Columns4:16:36Deleting and Clearing Cells4:23:02Aligning Text and Numbers4:34:15Applying Themes and Styles
- 00:00Start01:07Starting up01:27Recent documents and pinning documents01:54Templates02:34Layout - Tabs, ribbons, and groups in Microsoft Excel03:48Rows, Columns, Cells and Ranges05:49Worksheets in Microsoft Excel06:52View and zooming07:30Inputting Data10:56Formatting Data13:38Wrapping Text14:22Insert Row/ Merge & Center cells15:41Currency formatting16:20Print view17:02Add cell borders and colors18:18Basic formulas in Microsoft Excel21:17Copy formula23:45Freeze Pane24:52Basic Microsoft Excel functions28:59Tell Me” in Microsoft Excel29:43Inserting charts in Microsoft Excel
- Microsoft Excel endüstri lideri bir elektronik tablo yazılımı programı, güçlü bir veri görselleştirme ve analiz aracıdır.
- Excel, Microsoft tarafından geliştirilen ve Office ofis yazılım paketinde veya Microsoft 365 abonelik hizmetinde bulunan bir elektronik tablo uygulamasıdır.
- Microsoft Excel Full İndir – Türkçe 2013-2016-2019-2021, tüm serilerini seçip kurabilir tablo düzenleme ve oluşturmak Microsoft Excel.
- Excel, Microsoft Windows ile Apple Macintosh işletim sistemli bilgisayarlarda çalışabilen, elektronik tablolama programıdır.
- Bu nedenle Microsoft Excel programının ayrı olarak indirip önizleme sürümünü sınırsız bir şekilde deneyebileceğiniz 2016 sürümünü paylaşıyoruz.
- Microsoft Office içerisinde yer alan Excel 'e ait yükleme paketidir. Amacınız komple ofis kurmadan sadece Excel kullanmak ise bu paket işinizi görecektir.
- Microsoft Excel is the spreadsheet tool which belongs to Office with which you can work comfortably with tables, graphs and macros directly from your PC.
- Not: Windows 10 için Microsoft Excel önizleme sürümü olarak yayınlanmıştır ve sadece Windows 10 Teknik Önizleme sürümünü kullanıyorsanız indirebilirsiniz.
- Sürüm 5.0 geçildiğinde xlm kaydı bir seçenek olarak devam etti, ancak Microsoft bu seçeneği kullanmayı önermiyor. Excel indir, belirli hücre gruplarını...
Microsoft Excel
Genel bilgiler
Kısa bilgiler
- Yayın tarihi:1985
- Platformu: