|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ms-excel-course/
课程评论：没有评论
课程名称：从零到专业的Microsoft Excel课程 课程概述：本课程适合所有Excel用户的级别，包括初学者、中级和高级用户。课程内容涵盖了所有Excel的命令和公式，包括简单的、基础的和复杂的公式，满足专业用户的需求。此外，课程还介绍了许多常被用户忽视的Excel技巧。从未接触过Excel的用户，通过本课程将能够掌握Excel的各项功能，成为熟练用户。 课程结构：本课程包括70节讲座，详细解答使用Excel时可能遇到的各种问题。课程内容涉及到的工具包括数据透视表、数据透视图、饼图、复杂表格、高级公式等各种高级功能。学员将学习到所有的格式选项、插入选项和数据选项。同时还将学习到多种Excel技巧，例如快速分析工具、数据验证、条件格式化、Power Pivot以及数据透视表的使用等。 课程亮点： - 多种Excel快捷操作技巧 - 高级公式和条件格式使用 - 数据分析和可视化工具 - 适用于各个水平的学习者，循序渐进 - 入门到精通，帮助学员全面理解Excel的各个功能和应用 无论你是初学者还是想要提升Excel技能的专业人士，这门课程都能为你提供全面而详细的学习体验。通过不断的实践和技巧应用，学员将能够有效提高工作效率，轻松处理各种Excel任务。
الكورس مناسب لكل مستويات مستخدمي الاكسيل ( المبتديء والمحترف والمتوسط ) يشمل جميع اوامر ومعادلات الاكسيل - المعادلات البسيطه والبدائيه والمعادلات المعقده والتي يحتاجها المحترفين - يشمل ايضا العديد من تريكات الاكسيل التي يجهلها كثير من المستخدمين - اذا كنت لا تعلم في الاكسيل شيئا سوف تخرج من الكورس بفضل الله محترف للاكسيل وعلي درايه تامه بكل تفاصيل الاكسيل.- This course for all excel users levels ( primary and advanced levels ) including all excel details & functions & formulas. - Throw the 70 Lectures you will find all your answers for any question which may face you when you are using excel. - You will find many advanced tools ( Pivot table - Pivot chart - Pie Chart - Advanced Tables - Advanced equations - Advanced formulas ) - All Formatting Options - All Insert options & Data options Lecture 39 1 Excel Tricks 1 CTRL + ELecture 40 2 Excel Tricks 2 CTRL + ELecture 41 3 Excel Tricks 3 CTRL + ; & Ctrl + ELecture 42 4 Excel Tricks 4 Custom List for dragging downLecture 43 5 Excel Tricks 5 Select Multi Sheets and make your workLecture 44 6 Quick access analysis toolLecture 45 7 Filter - tableLecture 46 8 Data Validation ( Drop down list data validation )Lecture 47 9 Auto fit columns & RowsLecture 48 10 Transpose ( تقلب الصف عمود والعمود صف )Lecture 49 11 Remove duplicatesLecture 50 12 Goal Seek ( Data - what if - goal seek ) ( محتاج احقق قيمه معينه )Lecture 51 13 VlockupLecture 52 14 Paste SepacialLecture 53 15 changing chart columns to pattern or pictureLecture 54 16 IF FunctionLecture 55 17 Insert ScreenShot ( insert - illustration - screenshot )Lecture 56 18 Absolute Cell ReferenceLecture 57 19 Show Formula ( CTRL + ˜ )Lecture 58 20 Convert Text to columnsLecture 59 21 Conditional formattingLecture 60 22 Power PivotLecture 61 23 Freeze PanesLecture 62 24 CTRL Arrow key to select last cellLecture 63 25 3D reference (جمع نفس الخليه في كل الشيتات )Lecture 64 26 forecast sheetLecture 65 27 SUMIFS ـجميع القيم التي امام قيم معينه ( اكثر من criteria )Lecture 66 28 IF ERROR - Advanced Transpose ( Live Edit ) تحديث القيم بعد عمل transpose عند تغيير القيم الاصليهLecture 67 29 SlicersLecture 68 30 Scenario ManagerLecture 69 31 Convert FunctionLecture 70 32 Convert Currency LiveLecture 71 33 Hide CellsLecture 72 34 remove blanksLecture 73 35 track changesLecture 74 36 advanced filterLecture 75 How To use pivot table & SlicerLecture 76 How to learn excel in 40 min & pivot tablesLecture 77 How to make report by excelLecture 78 Paste Link & Transpose & combination for both of themLecture 79 Excel ShortcutsLecture 80 Pivot table Secrets80.01 use table ( to be able to add data )80.02 show pivot table details ( Double click or - right click and show details )80.03 delete data source ( bring it again with double click on total )80.04 replace empty cells with any values - replace errors with any value80.05 field setting - layout print - show with no data (( to show empty cells ))80.06 Group for pivot table items80.07 group numeric items80.08 group dates and show by month or year80.09 automatic refresh - options - data - automatic refresh80.1 show filter - put item in filter area - options - show filter area (( will create new sheets with each item )80.11 filter by label & by value80.12 sort80.13 move the items manually to sort it80.14 change the layout - design - report layout80.15 repeat labels - design - report layout - repeat item labels80.16 turn off (Get pivot table data formula ) - from options in the left corner - choos to turn off get pivot table data formula80.17 prevent column width from changing - right click - pivot table options - autofit columns - change on update ( tick )80.18 calculated fields - analyze - fields - calculated fields - insert formula and add80.19 creat pivot chart ( choos any chart and link with pivot table80.2 add slicer80.21 insert timeline80.22 link slicer with other tables ( right click - report connection - choose the tables to link )80.23 filter on top N80.24 add multible subtotals - field setting - CTRL select - sum & averag ( but before this stage you have to choose alow multible subtotals from the pivot table options80.25 show values as - field setting OR right click values - show valuse asLecture 81 Excel Power Query 1 ( Home Tap )81.01 Refresh81.02 Properties81.03 Manage81.04 Choose Columns81.05 Remove columns81.06 remove rows81.07 keep rows81.08 sort81.09 Split columns81.10 Data Type81.11 Use first row as header81.12 replace values81.13 Merge Quaries81.14 Append Quaries81.15 Data Source Setting81.16 New SourceLecture 82 Excel Power Query 2 ( Transform Tap )82.01 Transpose ( تقلب الصف عمود والعمود صف )82.02 Reverse rows82.03 Count rows82.04 Replace Values & errors82.05 Fill82.06 Pivot Columns82.07 Unpivot columns82.08 move82.09 convert to list82.10 format82.11 split columns82.12 Extract82.13 Statistics82.14 Standard82.15 Rounding82.16 Information82.17 Date & Time & DurationLecture 83 Excel Power Query 3 ( Add Columns & View Taps )84.01 Columns from example84.02 custom column84.03 merge columns84.04 format & extract & statistics & standard & date and time
