Spreadsheets, files and memos are necessary documents in most businesses. … Microsoft Excel and Microsoft Word are part of the Microsoft Office package of …
Course Content
المحتوى
-
MS Excel Tutorial Lesson 1 Excel Interface
00:00 -
MS Excel Tutorial Lesson 2 Quick Access Toolbar
00:00 -
MS Excel Tutorial Lesson 3 Workbooks and Worksheets
00:00 -
MS Excel Tutorial Lesson 4 Formula Bar
00:00 -
MS Excel Tutorial Lesson 5 Status Bar
00:00 -
MS Excel Tutorial Lesson 6 Navigation Tools
00:00 -
MS Excel Tutorial Lesson 7 Shortcut menus and Mini toolbar
00:00 -
MS Excel Tutorial Lesson 8 Creating new workbooks
00:00 -
MS Excel Tutorial Lesson 9 Tell Me Assistant and Help
00:00 -
MS Excel Tutorial Lesson 10 Data Entry and Editing
00:00 -
MS Excel Tutorial Lesson 11 Autofill
00:00 -
MS Excel Tutorial Lesson 12 Dates and Times
00:00 -
MS Excel Tutorial Lesson 13 Undo and Redo
00:00 -
MS Excel Tutorial Lesson 14 Comments
00:00 -
MS Excel Tutorial Lesson 15 Save and Save As
00:00 -
MS Excel Tutorial Lesson 16 Basic Formula for Calculations
00:00 -
MS Excel Tutorial Lesson 17 Basic Formula Function
00:00 -
MS Excel Tutorial Lesson 18 Duplicating Formulas
00:00 -
MS Excel Tutorial Lesson 19 Year to Date Calculation
00:00 -
MS Excel Tutorial Lesson 20 Percentage formula
00:00 -
MS Excel Tutorial Lesson 21 Relative absolute and mixed reference
00:00 -
MS Excel Tutorial Lesson 22 SUM and AVERAGE
00:00 -
MS Excel Tutorial Lesson 23 Common functions
00:00 -
MS Excel Tutorial Lesson 24 Font styles and effects
00:00 -
MS Excel Tutorial Lesson 25 Row height and column width
00:00 -
MS Excel Tutorial Lesson 26 Alignment and warp text
00:00 -
MS Excel Tutorial Lesson 27 Borders
00:00 -
MS Excel Tutorial Lesson 28 Numeric and special formatting
00:00 -
MS Excel Tutorial Lesson 29 Numbers and dates
00:00 -
MS Excel Tutorial Lesson 30 Conditional formatting
00:00 -
MS Excel Tutorial Lesson 31 Tables
00:00 -
MS Excel Tutorial Lesson 32 Slicer
00:00 -
MS Excel Tutorial Lesson 33 Working with Shapes
00:00 -
MS Excel Tutorial Lesson 34 Inserting and Working with Pictures
00:00 -
MS Excel Tutorial Lesson 35 SmartArt
00:00 -
MS Excel Tutorial Lesson 36 Editing Rows and Columns
00:00 -
MS Excel Tutorial Lesson 37 Hiding and Unhiding Rows and Columns
00:00 -
MS Excel Tutorial Lesson 38 Moving and Copying Data
00:00 -
MS Excel Tutorial Lesson 39 Finding and Replacing data
00:00 -
MS Excel Tutorial Lesson 40 Printing Area and Titles
00:00 -
MS Excel Tutorial Lesson 41 Page Layout
00:00 -
MS Excel Tutorial Lesson 42 Page Break
00:00 -
MS Excel Tutorial Lesson 43 Page Setup and Printing Controls
00:00 -
MS Excel Tutorial Lesson 44 Creating Charts
00:00 -
MS Excel Tutorial Lesson 45 Chart Types
00:00 -
MS Excel Tutorial Lesson 46 Chart Formatting
00:00 -
MS Excel Tutorial Lesson 47 Axes and Titles
00:00 -
MS Excel Tutorial Lesson 48 Chart Elements
00:00 -
MS Excel Tutorial Lesson 49 In cell charts
00:00 -
MS Excel Tutorial Lesson 50 Freezing and unfreezing panels
00:00 -
MS Excel Tutorial Lesson 51 Splitting screens
00:00 -
MS Excel Tutorial Lesson 52 Collapsing and Expanding data
00:00 -
MS Excel Tutorial Lesson 53 Multiple workbooks display
00:00 -
MS Excel Tutorial Lesson 54 Renaming inserting coloring and deleting sheets
00:00 -
MS Excel Tutorial Lesson 55 Moving copying and grouping sheets
00:00 -
MS Excel Tutorial Lesson 56 Linking worksheets and workbooks
00:00 -
MS Excel Tutorial Lesson 57 Maintaining and locating links
00:00 -
MS Excel Tutorial Lesson 58 IF function
00:00 -
MS Excel Tutorial Lesson 59 VLOOKUP function for approximate data
00:00 -
MS Excel Tutorial Lesson 60 VLOOKUP function for exact data
00:00 -
MS Excel Tutorial Lesson 61 COUNTIF function
00:00 -
MS Excel Tutorial Lesson 62 Unlocking and protecting worksheets
00:00 -
MS Excel Tutorial Lesson 63 Workbook protection
00:00 -
MS Excel Tutorial Lesson 64 Setting passwords
00:00 -
MS Excel Tutorial Lesson 65 Tracking changes
00:00 -
MS Excel Tutorial Lesson 66 Sorting
00:00 -
MS Excel Tutorial Lesson 67 Inserting subtotals
00:00 -
MS Excel Tutorial Lesson 68 Using filters
00:00 -
MS Excel Tutorial Lesson 69 Splitting data
00:00 -
MS Excel Tutorial Lesson 70 Flash Fill
00:00 -
MS Excel Tutorial Lesson 71 Removing duplicate data
00:00 -
MS Excel Tutorial Lesson 72 Validation tools
00:00 -
MS Excel Tutorial Lesson 73 Goak Seek
00:00 -
MS Excel Tutorial Lesson 74 Solver
00:00 -
MS Excel Tutorial Lesson 75 Scenario Manager
00:00 -
MS Excel Tutorial Lesson 76 Data Tables
00:00 -
MS Excel Tutorial Lesson 77 Validation for Just Number or Text Input
00:00 -
MS Excel Tutorial Lesson 78 Kutools for Validation
00:00 -
MS Excel Tutorial Lesson 79 Pivot Tables Creation
00:00 -
MS Excel Tutorial Lesson 80 Pivot Tables Manipulation
00:00 -
MS Excel Tutorial Lesson 81 Grouping and date and time
00:00 -
MS Excel Tutorial Lesson 82 Grouping by various facotors
00:00 -
MS Excel Tutorial Lesson 83 Slicers
00:00 -
MS Excel Tutorial Lesson 84 PivotCharts
00:00 -
MS Excel Tutorial Lesson 85 Go to Special
00:00 -
MS Excel Tutorial Lesson 86 Creating Macro
00:00 -
MS Excel Tutorial Lesson 87 Running Macro and Assigning Buttons
00:00 -
MS Excel Tutorial Lesson 88 Making a Grade Sheet
00:00 -
MS Excel Tutorial Lesson 89 Generating Automatic Comments using Numbers
00:00 -
MS Excel Tutorial Lesson 90 Autohide Tabs
00:00 -
MS Excel Tutorial Lesson 91 Copying just the Visible Data Excluding Hidden Columns
00:00 -
MS Excel Tutorial Lesson 92 KuTools for Excel
00:00 -
MS Excel Tutorial Lesson 93 Multiple User Sharing
00:00 -
Paint 3D Tutorial Lesson 22 Importing Paint 3D Models in MS Excel
00:00 -
Final Exam – MS Excel

















































