وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

MS Office; Excel, Word, Access & PowerPoint 2019 – Beginners

سرفصل های دوره

Learn the essentials of Microsoft Office in this 4-course bundle for Office 365 or Office 2019 users.


1 - Excel 2019 Introduction
  • 1 - Intro to Excel
  • 2 - WATCH ME Essential Information for a Successful Training Experience
  • 3 - Course Exercise Files.html
  • 3 - Excel-2019-Beginner-Course-Exercise-Files.zip
  • 4 - Downloadable Course Transcripts.html
  • 4 - Microsoft-Excel-2019-Course-by-Simon-Sez-IT.pdf
  • 5 - Whats New In Excel 2019
  • 6 - Course Overview
  • 7 - Overview of the Excel window
  • 8 - MouseFeatures
  • 9 - Back Stage View

  • 2 - Excel 2019 Beginner Creating Workbooks
  • 10 - Entering Text and Numbers
  • 11 - Creating Basic Formulas
  • 12 - Relative References
  • 13 - Order of Operations
  • 14 - Working with Ranges
  • 15 - Module 2 Practice Exercise

  • 3 - Excel 2019 Beginner Saving Workbooks
  • 16 - Working with theSave and Save As Commands
  • 17 - File Extensions Share Export and Publish Files
  • 18 - Module 3 Practice Exercise

  • 4 - Excel 2019 Beginner Navigating Workbooks
  • 19 - Opening a File
  • 20 - Working with Larger Files
  • 21 - Freeze Panes Option
  • 22 - Split Screen Option
  • 23 - Module 4 Practice Exercise

  • 5 - Excel 2019 Beginner Page Setup & Print Options
  • 24 - Headers and Footers
  • 25 - Print Titles
  • 26 - Comments
  • 27 - Page Setup Options
  • 28 - Fit to Print on One Page
  • 29 - Printing Workbooks
  • 30 - Module 5 Practice Exercise

  • 6 - Excel 2019 Beginners Working with Rows Columns and Cells
  • 31 - Adding and deleting rows columns and cells
  • 32 - Changing Column andRow Widths
  • 33 - Module 6 Practice Exercise

  • 7 - Excel 2019 Beginners Moving Data
  • 34 - Cut Copy and Paste
  • 35 - Copying Formulas
  • 36 - Module 7 Practice Exercise

  • 8 - Excel 2019 Beginners Formulas & Functions
  • 37 - Overview of Formulas
  • 38 - Create Formulas Using Functions Part 1
  • 39 - Create Formulas Using Functions Part 2
  • 40 - Absolute Values
  • 41 - Module 8 Practice Exercise

  • 9 - Excel 2019 Beginner Working with Sheets
  • 42 - Working with the Save and Save As Commands
  • 43 - Adding Deleting and Renaming Sheets
  • 44 - Additional Sheet Tab Options
  • 45 - 3 Dimensional Formulas
  • 46 - Module 9 Practice Exercise

  • 10 - Excel 2019 Beginner Formatting Worksheets
  • 47 - Formatting Cells Part 1
  • 48 - Formatting Cells Part 2
  • 49 - Formatting Numbers
  • 50 - Borders and Shading
  • 51 - Format as Table
  • 52 - Using Styles
  • 53 - Using Format Painter
  • 54 - Protecting Sheets
  • 55 - Fill Handle and Custom Lists
  • 56 - Module 10 Practice Exercise

  • 11 - Excel 2019 Beginner Charts
  • 57 - Creating Charts
  • 58 - Types of Charts
  • 59 - Editing Charts Part 1
  • 60 - Editing Charts Part 2
  • 61 - Using Graphics to Enhance Charts
  • 62 - Linking Chart Titles
  • 63 - Module 11 Practice Exercise

  • 12 - Excel 2019 Beginner Working with Names
  • 64 - Creating Range Names
  • 65 - Managing Names
  • 66 - Using Names in Formulas
  • 67 - Module 12 Practice Exercise

  • 13 - Excel 2019 Beginner Sorting and Filtering
  • 68 - Remove Duplicates
  • 69 - Sort Data
  • 70 - Filter Data
  • 71 - Advanced Filters
  • 72 - Module 13 Practice Exercise

  • 14 - Excel 2019 Beginner Outlining and Subtotaling
  • 73 - Creating an Outline
  • 74 - Subtotals
  • 75 - Module 14 Practice Exercise

  • 15 - Excel 2019 Beginner Working with Views
  • 76 - Arranging Files
  • 77 - New Window Option
  • 78 - Custom Views
  • 79 - Module 15 Practice Exercise

  • 16 - Excel 2019 Beginner Linking Files
  • 80 - Creating Formulas Between File
  • 81 - Working with Links
  • 82 - Consolidating Data
  • 83 - Module 16 Practice Exercise

  • 17 - Excel 2019 Beginner Advanced Formula Creation
  • 84 - If Statements
  • 85 - VLookups
  • 86 - Data Validation
  • 87 - Formula Auditing
  • 88 - Module 17 Practice Exercise

  • 18 - Excel 2019 Beginner Pivot Tables
  • 89 - Pivot Tables
  • 90 - Pivot Charts
  • 91 - Module 18 Practice Exercise

  • 19 - Excel 2019 Beginner Additional Excel Features
  • 92 - Slicers
  • 93 - Goal Seeker
  • 94 - Text to Columns
  • 95 - Watch Window
  • 96 - Customizing Ribbons and Tabs
  • 97 - Module 19 Practice Exercise

  • 20 - Excel 2019 Beginner Shortcuts
  • 98 - Excel Shortcuts Every User Should Know

  • 21 - Excel 2019 Beginner Closing
  • 99 - Closing Video

  • 22 - Word 2019 Introduction
  • 100 - Welcome and Overview
  • 101 - WATCH ME Essential Information for a Successful Training Experience
  • 102 - Course Exercise Files.html
  • 102 - Word-2019-Exercise-Files.zip
  • 103 - Downloadable Course Transcripts.html
  • 103 - Microsoft-Word-2019-Course-by-Simon-Sez-IT-Full-Transcripts.pdf
  • 104 - Overview of the MS Word Screen
  • 105 - The Backstage View

  • 23 - Word 2019 Getting Started with Word
  • 106 - Creating a New Blank Document
  • 107 - Working with NonPrinting Characters and Line Spacing
  • 108 - Saving a Document
  • 109 - Opening a Document
  • 110 - Navigating a Document
  • 111 - Go To Find and Replace
  • 112 - Editing a Document
  • 113 - Practice Exercise

  • 24 - Character Formatting
  • 114 - AutoCorrect Options
  • 115 - Selecting Text
  • 116 - Cut Copy and Paste
  • 117 - Character Formatting Options
  • 118 - Format Painter
  • 119 - Working with Numbers
  • 120 - Working with Bullets
  • 121 - Creating an Outline
  • 122 - Practice Exercise

  • 25 - Word 2019 Paragraph Formatting
  • 123 - Alignment Options
  • 124 - Line Spacing Options
  • 125 - Working with Indents
  • 126 - Working with Tabs
  • 127 - Practice Exercise

  • 26 - Word 2019 Managing Lists
  • 128 - Sorting a List

  • 27 - Word 2019 Tables
  • 129 - Working with Tables
  • 130 - Creating a Table
  • 131 - Adding Rows and Columns to a Table
  • 132 - Formatting Table Data
  • 133 - Borders and Shading
  • 134 - Sorting in a Table
  • 135 - Drawing in a Table
  • 136 - Converting Existing Data to a Table
  • 137 - Quick Tables
  • 138 - Using Formulas in Tables
  • 139 - Practice Exercise

  • 28 - Word 2019 Styles
  • 140 - Working with Styles
  • 141 - Creating Styles
  • 142 - Editing Styles
  • 143 - Practice Exercise

  • 29 - Word 2019 Controlling Page Appearance
  • 144 - Working with Page Breaks
  • 145 - Working with Columns
  • 146 - Adding a Watermark
  • 147 - Headers and Footers

  • 30 - Word 2019 Sectioning
  • 148 - What is Sectioning
  • 149 - Sectioning a document
  • 150 - Odd and Even Sections
  • 151 - Practice Exercise

  • 31 - Word 2019 Graphics
  • 152 - Inserting Pictures
  • 153 - Inserting Pictures into Existing Documents
  • 154 - Picture Options
  • 155 - Working with Shapes
  • 156 - Icons and 3D Models
  • 157 - SmartArt Charts and Screenshots
  • 158 - Practice Exercise

  • 32 - Word 2019 Envelopes and Labels
  • 159 - Working with Envelopes
  • 160 - Working with Labels

  • 33 - Word 2019 Mail Merges
  • 161 - What is Mail Merge
  • 162 - Creating a Mail Merge Document Part 1
  • 163 - Creating a Mail Merge Document Part 2
  • 164 - Merging a Document with an Existing Data Source
  • 165 - Merging Envelopes and Labels
  • 166 - Merging a Directory
  • 167 - Practice Exercise

  • 34 - Word 2019 Page Setup Options
  • 168 - Building Blocks
  • 169 - Auto Text
  • 170 - Practice Exercise

  • 35 - Word 2019 Indexing and Table of Contents
  • 171 - Creating an Index
  • 172 - Creating a Table of Contents
  • 173 - Practice Exercise

  • 36 - Word 2019 Review and Printing
  • 174 - Using the Thesaurus and Spell Check
  • 175 - Comments
  • 176 - Page Setup Options
  • 177 - Printing
  • 178 - Practice Exercise

  • 37 - Word 2019 Other Word Options
  • 179 - Word Options
  • 180 - Protecting a Document
  • 181 - Macros

  • 38 - Word 2019 Wrap Up
  • 182 - Closing

  • 39 - PowerPoint 2019 Course Introduction
  • 183 - Welcome and Overview
  • 184 - WATCH ME Essential Information for a Successful Training Experience
  • 185 - Course Exercise Files.html
  • 185 - PowerPoint-2019-Exercise-Files.zip
  • 186 - Downloadable Course Transcripts.html
  • 186 - Microsoft-PowerPoint-2019-Course-by-Simon-Sez-IT.pdf

  • 40 - PowerPoint 2019 Overview
  • 187 - Navigate a PowerPoint Presentation
  • 188 - Overview of the Screen and Views
  • 189 - Exercise 1

  • 41 - PowerPoint 2019 Getting Started
  • 190 - Presentation Tips and Guidelines
  • 191 - Creating a New Presentation
  • 192 - Working with Slides
  • 193 - Saving a Presentation
  • 194 - Exercise 02

  • 42 - PowerPoint 2019 Text and Bullet Editing Options
  • 195 - Formatting Text
  • 196 - Working with Bullets and Numbered Lists
  • 197 - Exercise 03

  • 43 - PowerPoint 2019 Adding Graphics
  • 198 - Inserting Shapes
  • 199 - Inserting Graphics
  • 200 - Inserting Icons and 3D Models
  • 201 - Inserting Pictures
  • 202 - Exercise 04

  • 44 - PowerPoint 2019 Working with objects
  • 203 - Selecting Objects
  • 204 - Editing Objects
  • 205 - Formatting Objects Part 1
  • 206 - Formatting Objects Part 2
  • 207 - Arranging Objects
  • 208 - Grouping Objects
  • 209 - Exercise 05

  • 45 - PowerPoint 2019 Editing pictures
  • 210 - Picture Options
  • 211 - Cropping Pictures
  • 212 - Formatting Pictures
  • 213 - Things You Can Do with Pictures
  • 214 - Exercise 06

  • 46 - PowerPoint 2019 Working with SmartArt
  • 215 - Creating SmartArt
  • 216 - Modifying SmartArt
  • 217 - Creating a Flowchart using SmartArt
  • 218 - Exercise 07

  • 47 - PowerPoint 2019 Working with Tables
  • 219 - Creating Tables
  • 220 - Formatting Tables
  • 221 - Inserting Tables
  • 222 - Exercise 08

  • 48 - PowerPoint 2019 Working with Charts
  • 223 - Adding Charts
  • 224 - Formatting Charts
  • 225 - Inserting Charts from Microsoft Excel
  • 226 - Exercise 09

  • 49 - PowerPoint 2019 Unlocking the Power of Masters
  • 227 - Using Master Slides
  • 228 - Modifying Master Slides
  • 229 - Creating a New Master Design Template
  • 230 - Exercise 10

  • 50 - PowerPoint 2019 Adding Media
  • 231 - Adding Video to a Presentation
  • 232 - Adding Audio to a Presentation
  • 233 - Exercise 11

  • 51 - PowerPoint 2019 Working with Transitions
  • 234 - Applying Transitions
  • 235 - Transition Options
  • 236 - Exercise 12

  • 52 - PowerPoint 2019 Animation
  • 237 - Animating an Object
  • 238 - Effect Options
  • 239 - Working with the Animation Pane
  • 240 - Motion Paths
  • 241 - Triggers
  • 242 - Exercise 13

  • 53 - PowerPoint 2019 Hyperlinks and Action Buttons
  • 243 - Working with Action Buttons
  • 244 - Working with Hyperllinks
  • 245 - Exercise 14

  • 54 - PowerPoint 2019 Slideshow Options
  • 246 - Onscreen Presentation Options
  • 247 - Hiding Slides
  • 248 - Changing the order of slides
  • 249 - Copying slides
  • 250 - Slideshow Options
  • 251 - Exercise 15

  • 55 - PowerPoint 2019 Preparing a presentation for delivery
  • 252 - Rehearse Timings
  • 253 - Recording a Presentation
  • 254 - Slide Show Settings
  • 255 - Creating a Custom Slide Show
  • 256 - Exercise 16

  • 56 - PowerPoint 2019 Exploring the Backstage Area
  • 257 - Exporting options
  • 258 - The Backstage Area
  • 259 - Printing a Presentation
  • 260 - Exercise 17

  • 57 - PowerPoint 2019 Course Close
  • 261 - Conclusion

  • 58 - Access 2019 Beginners Introduction
  • 262 - Introduction to Access 2019
  • 263 - WATCH ME Essential Information for a Successful Training Experience
  • 264 - Access-2019-Exercise-Files.zip
  • 264 - Course Exercise Files.html
  • 265 - Access-2019-Course-Files.zip
  • 265 - Course Demo Files.html
  • 266 - Downloadable Course Transcripts.html
  • 266 - Microsoft-Access-2019-Course-by-Simon-Sez-IT.pdf
  • 267 - Acquiring Access 2019
  • 268 - Structure of the Course

  • 59 - Access 2019 Beginners Getting Started with Access 2019
  • 269 - Using Database Templates
  • 270 - Creating Saving and Opening Databases
  • 271 - The Access Workspace and Backstage
  • 272 - Online Help and Tell Me What You Want To Do

  • 60 - Access 2019 Beginners The Ribbon and Toolbars
  • 273 - Working with the Ribbon
  • 274 - The Quick Access Toolbar
  • 275 - Contextual Menus
  • 276 - The Status Bar

  • 61 - Access 2019 Beginners Keyboard Shortcuts and Key Tip
  • 277 - Keyboard Shortcuts
  • 278 - Key Tips

  • 62 - Access 2019 Beginners Access Options
  • 279 - Exploring Access Options

  • 63 - Access 2019 Beginners Tables
  • 280 - Creating a Table and Fields
  • 281 - Indexed Field
  • 282 - Lookup Wizard
  • 283 - Numeric Fields
  • 284 - Practice Exercise 01

  • 64 - Access 2019 Beginners Importing Data
  • 285 - Importing Data from Excel
  • 286 - Practice Exercise 02

  • 65 - Access 2019 Beginners Backup Restore and Repair
  • 287 - Backing up your Database
  • 288 - Compact and Repair

  • 66 - Access 2019 Beginners Datasheet View
  • 289 - Design in the Datasheet View
  • 290 - Sorting and Filtering in Datasheet View
  • 291 - Entering and Modifying Data in Datasheet View

  • 67 - Access 2019 Beginners Relationships
  • 292 - Creating a Link Table
  • 293 - Setting up Relationships
  • 294 - Practice Exercise 03

  • 68 - Access 2019 Beginners Forms
  • 295 - Creating a Form
  • 296 - Modifying a Form
  • 297 - Practice Exercise 04
  • 298 - Forms in Layout View
  • 299 - Forms in Design View
  • 300 - Form Design
  • 301 - Practice Exercise 05

  • 69 - Access 2019 Beginners Subforms
  • 302 - Setting Up Subforms Part 1
  • 303 - Setting Up Subforms Part 2
  • 304 - Setting Up Subforms Part 3
  • 305 - Practice Exercise 06

  • 70 - Access 2019 Beginners Queries
  • 306 - Creating a Query
  • 307 - Joins
  • 308 - Query Wizard
  • 309 - Practice Exercise 07

  • 71 - Access 2019 Beginners Expressions
  • 310 - Setting Up Validations
  • 311 - Calculation using Expressions

  • 72 - Access 2019 Beginners Reports
  • 312 - Basic Reports
  • 313 - Report Design
  • 314 - Complex Reports
  • 315 - Practice Exercise 08

  • 73 - Access 2019 Beginners Printing
  • 316 - Printing and Print Properties

  • 74 - Access 2019 Beginners More Data Types
  • 317 - YesNo OLE Objects and Hyperlink Data Types

  • 75 - Access 2019 Beginners More About Forms
  • 318 - Form Controls
  • 319 - Form Themes
  • 320 - Navigation Forms

  • 76 - Access 2019 Beginners Exporting
  • 321 - Exporting an Access Database

  • 77 - Access 2019 Beginners Application Parts
  • 322 - Adding Application Parts to a Database

  • 78 - Access 2019 Beginners More Access Options
  • 323 - Additional Access 2019 Options

  • 79 - Access 2019 Beginners Info Tab
  • 324 - Edit Database Properties and Encrypt with Password

  • 80 - Access 2019 Beginners Course Close
  • 325 - Course Close

  • 81 - Extras
  • 326 - EXTRA LESSON Designing Better Spreadsheets Webinar Recording
  • 327 - EXTRA LESSON Data Cleaning in Excel Webinar Recording
  • 328 - EXTRA LESSON Top Ten Excel Functions You HAVE to Know Webinar Recording
  • 329 - EXTRA RESOURCE The Most Frequently Used Excel Shortcuts Infographic.html
  • 329 - PC-Excel-Most-Used.pdf
  • 330 - EXTRA RESOURCE The Most Frequently Used PowerPoint Shortcuts Infographic.html
  • 330 - Powerpoint.pdf
  • 331 - Access-Shortcuts.pdf
  • 331 - EXTRA RESOURCE The Most Frequently Used Access Shortcuts Infographic.html
  • 332 - EXTRA RESOURCE The Most Frequently Used Word Shortcuts Infographic.html
  • 332 - Word.pdf

  • 82 - Congratulations
  • 333 - BONUS Lecture.html
  • 53,700 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 1535
    حجم: 14827 مگابایت
    مدت زمان: 2019 دقیقه
    تاریخ انتشار: 27 دی 1401
    طراحی سایت و خدمات سئو

    53,700 تومان
    افزودن به سبد خرید