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

در حال حاضر محصولی در سبد خرید شما وجود ندارد.

رمز خود را فراموش کرده اید؟
وب سایت تخصصی شرکت فرین
خانه » فروشگاه » آموزش های اداری و آفیس » آموزش Microsoft Access » MS Office; Excel, Word, Access & PowerPoint 2019 – Beginners

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
    • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 1535
    حجم: 14827 مگابایت
    مدت زمان: 2019 دقیقه
    تاریخ انتشار: ۲۷ دی ۱۴۰۱
    دسته بندی محصول
    Udemy-Training
    Udemy-Training
    مشاهده دوره های Udemy-Training
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید