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

جمع جزء: 378,000 تومان

مشاهده سبد خریدتسویه حساب

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

Microsoft Office; Excel, Word & PowerPoint 2019 – Beginners

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

Learn the essentials of Microsoft Office in this 3-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 the Save 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 - Adding Deleting and Renaming Sheets
  • 43 - Additional Sheet Tab Options
  • 44 - 3 Dimensional Formulas

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

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

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

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

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

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

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

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

    • 18 - Excel 2019 Beginner Pivot Tables
  • 87 - Pivot Tables
  • 88 - Pivot Charts
  • 89 - Module 18 Practice Exercise

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

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

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

    • 22 - PowerPoint 2019 Course Introduction
  • 98 - Welcome and Overview
  • 99 - WATCH ME Essential Information for a Successful Training Experience
  • 100 - DOWNLOAD ME Course Exercise Files.html
  • 100 - PowerPoint-2019-Exercise-Files.zip
  • 101 - Downloadable Course Transcripts.html
  • 101 - Microsoft-PowerPoint-2019-Course-by-Simon-Sez-IT.pdf

    • 23 - PowerPoint 2019 Overview
  • 102 - Navigate a PowerPoint Presentation
  • 103 - Overview of the Screen and Views
  • 104 - Exercise 1

    • 24 - PowerPoint 2019 Getting Started
  • 105 - Presentation Tips and Guidelines
  • 106 - Creating a New Presentation
  • 107 - Working with Slides
  • 108 - Saving a Presentation
  • 109 - Exercise 02

    • 25 - PowerPoint 2019 Text and Bullet Editing Options
  • 110 - Formatting Text
  • 111 - Working with Bullets and Numbered Lists
  • 112 - Exercise 03

    • 26 - PowerPoint 2019 Adding Graphics
  • 113 - Inserting Shapes
  • 114 - Inserting Graphics
  • 115 - Inserting Icons and 3D Models
  • 116 - Inserting Pictures
  • 117 - Exercise 04

    • 27 - PowerPoint 2019 Working with objects
  • 118 - Selecting Objects
  • 119 - Editing Objects
  • 120 - Formatting Objects Part 1
  • 121 - Formatting Objects Part 2
  • 122 - Arranging Objects
  • 123 - Grouping Objects
  • 124 - Exercise 05

    • 28 - PowerPoint 2019 Editing Pictures
  • 125 - Picture Options
  • 126 - Cropping Pictures
  • 127 - Formatting Pictures
  • 128 - Things You Can Do with Pictures
  • 129 - Exercise 06

    • 29 - PowerPoint 2019 Working with SmartArt
  • 130 - Creating SmartArt
  • 131 - Modifying SmartArt
  • 132 - Creating a Flowchart using SmartArt
  • 133 - Exercise 07

    • 30 - PowerPoint 2019 Working with Tables
  • 134 - Creating Tables
  • 135 - Formatting Tables
  • 136 - Inserting Tables
  • 137 - Exercise 08

    • 31 - PowerPoint 2019 Working with Charts
  • 138 - Adding Charts
  • 139 - Formatting Charts
  • 140 - Inserting Charts from Microsoft Excel
  • 141 - Exercise 09

    • 32 - PowerPoint 2019 Unlocking the Power of Masters
  • 142 - Using Master Slides
  • 143 - Modifying Master Slides
  • 144 - Creating a New Master Design Template
  • 145 - Exercise 10

    • 33 - PowerPoint 2019 Adding Media
  • 146 - Adding Video to a Presentation
  • 147 - Adding Audio to a Presentation
  • 148 - Exercise 11

    • 34 - PowerPoint 2019 Working with Transitions
  • 149 - Applying Transitions
  • 150 - Transition Options
  • 151 - Exercise 12

    • 35 - PowerPoint 2019 Animation
  • 152 - Animating an Object
  • 153 - Effect Options
  • 154 - Working with the Animation Pane
  • 155 - Motion Paths
  • 156 - Triggers
  • 157 - Exercise 13

    • 36 - PowerPoint 2019 Hyperlinks and Action Buttons
  • 158 - Working with Action Buttons
  • 159 - Working with Hyperlinks
  • 160 - Exercise 14

    • 37 - PowerPoint 2019 Slideshow Options
  • 161 - Onscreen Presentation Options
  • 162 - Hiding Slides
  • 163 - Changing the Order of Slides
  • 164 - Copying Slides
  • 165 - Slideshow Options
  • 166 - Exercise 15

    • 38 - PowerPoint 2019 Preparing a Presentation for Delivery
  • 167 - Rehearse Timings
  • 168 - Recording a Presentation
  • 169 - Slide Show Settings
  • 170 - Creating a Custom Slide Show
  • 171 - Exercise 16

    • 39 - PowerPoint 2019 Exploring the Backstage Area
  • 172 - Exporting options
  • 173 - The Backstage Area
  • 174 - Printing a Presentation
  • 175 - Exercise 17

    • 40 - PowerPoint 2019 Course Close
  • 176 - Conclusion

    • 41 - Word 2019 Introduction
  • 177 - Welcome and Overview
  • 178 - WATCH ME Essential Information for a Successful Training Experience
  • 179 - DOWNLOAD ME Course Exercise Files.html
  • 179 - Word-2019-Exercise-Files.zip
  • 180 - Downloadable Course Transcripts.html
  • 180 - Microsoft-Word-2019-Course-by-Simon-Sez-IT-Full-Transcripts.pdf
  • 181 - Overview of the MS Word Screen
  • 182 - The Backstage View

    • 42 - Word 2019 Getting Started with Word
  • 183 - Creating a New Blank Document
  • 184 - Working with NonPrinting Characters and Line Spacing
  • 185 - Saving a Document
  • 186 - Opening a Document
  • 187 - Navigating a Document
  • 188 - Go To Find and Replace
  • 189 - Editing a Document
  • 190 - Practice Exercise

    • 43 - Word 2019 Character Formatting
  • 191 - AutoCorrect Options
  • 192 - Selecting Text
  • 193 - Cut Copy and Paste
  • 194 - Character Formatting Options
  • 195 - Format Painter
  • 196 - Working with Numbers
  • 197 - Working with Bullets
  • 198 - Creating an Outline
  • 199 - Practice Exercise

    • 44 - Word 2019 Paragraph Formatting
  • 200 - Alignment Options
  • 201 - Line Spacing Options
  • 202 - Working with Indents
  • 203 - Working with Tabs
  • 204 - Practice Exercise

    • 45 - Word 2019 Managing Lists
  • 205 - Sorting a List

    • 46 - Word 2019 Tables
  • 206 - Working with Tables
  • 207 - Creating a Table
  • 208 - Adding Rows and Columns to a Table
  • 209 - Formatting Table Data
  • 210 - Borders and Shading
  • 211 - Sorting in a Table
  • 212 - Drawing in a Table
  • 213 - Converting Existing Data to a Table
  • 214 - Quick Tables
  • 215 - Using Formulas in Tables
  • 216 - Practice Exercise

    • 47 - Word 2019 Styles
  • 217 - Working with Styles
  • 218 - Creating Styles
  • 219 - Editing Styles
  • 220 - Practice Exercise

    • 48 - Word 2019 Controlling Page Appearance
  • 221 - Working with Page Breaks
  • 222 - Working with Columns
  • 223 - Adding a Watermark
  • 224 - Headers and Footers

    • 49 - Word 2019 Sectioning
  • 225 - What is Sectioning
  • 226 - Sectioning a Document
  • 227 - Odd and Even Sections
  • 228 - Practice Exercise

    • 50 - Word 2019 Graphics
  • 229 - Inserting Pictures
  • 230 - Inserting Pictures into Existing Documents
  • 231 - Picture Options
  • 232 - Working with Shapes
  • 233 - Icons and 3D Models
  • 234 - SmartArt Charts and Screenshots
  • 235 - Practice Exercise

    • 51 - Word 2019 Envelopes and Labels
  • 236 - Working with Envelopes
  • 237 - Working with Labels

    • 52 - Word 2019 Mail Merges
  • 238 - What is Mail Merge
  • 239 - Creating a Mail Merge Document Part 1
  • 240 - Creating a Mail Merge Document Part 2
  • 241 - Merging a Document with an Existing Data Source
  • 242 - Merging Envelopes and Labels
  • 243 - Merging a Directory
  • 244 - Practice Exercise

    • 53 - Word 2019 Page Setup Options
  • 245 - Building Blocks
  • 246 - Auto Text
  • 247 - Practice Exercise

    • 54 - Word 2019 Indexing and Table of Contents
  • 248 - Creating an Index
  • 249 - Creating a Table of Contents
  • 250 - Practice Exercise

    • 55 - Word 2019 Review and Printing
  • 251 - Using the Thesaurus and Spell Check
  • 252 - Comments
  • 253 - Page Setup Options
  • 254 - Printing
  • 255 - Practice Exercise

    • 56 - Word 2019 Other Word Options
  • 256 - Word Options
  • 257 - Protecting a Document
  • 258 - Macros

    • 57 - Wrap Up
  • 259 - Closing

    • 58 - Extras
  • 260 - EXTRA LESSON Designing Better Spreadsheets Webinar Recording
  • 261 - EXTRA LESSON Data Cleaning in Excel Webinar Recording
  • 262 - EXTRA LESSON Top Ten Excel Functions You HAVE to Know Webinar Recording
  • 263 - EXTRA LESSON Creating Engaging PowerPoint Presentations Webinar Recording
  • 264 - EXTRA RESOURCE The Most Frequently Used PowerPoint Shortcuts Infographic.html
  • 264 - Powerpoint.pdf
  • 265 - EXTRA RESOURCE The Most Frequently Used Excel Shortcuts Infographic.html
  • 265 - PC-Excel-Most-Used.pdf
  • 266 - EXTRA RESOURCE The Most Frequently Used Word Shortcuts Infographic.html
  • 266 - Word.pdf

    • 59 - Congratulations
  • 267 - BONUS Lecture.html
    • 189,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

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

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

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