Unleashing The Power Of Microsoft Office

Free Download Unleashing The Power Of Microsoft Office
Published 12/2023
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 9.26 GB | Duration: 16h 29m
Microsoft Office

What you’ll learn
Microsoft Excel
Microsoft Word
Microsoft Power Point
Microsoft Outlook Express
Requirements
12th Pass
Age upto 65 Years
Description
This course provides a comprehensive introduction to the core applications within the Microsoft Office suite, empowering participants with essential skills to enhance productivity in a professional and academic setting. Through hands-on exercises and practical examples, participants will gain proficiency in the following key applications:Microsoft Word:Creating and formatting documentsManaging text, images, and stylesCollaboration features and document reviewMicrosoft Excel:Building and formatting spreadsheetsFormulas, functions, and data analysisCharts and graphs for data visualizationMicrosoft PowerPoint:Designing and delivering effective presentationsSlide layout, transitions, and animationsCollaboration on presentationsMicrosoft Outlook:Email management and organizationCalendar scheduling and appointmentsContacts and tasks for personal and professional productivityCourse Objectives: Upon completion of this course, participants will be able to:Create and edit professional documents, spreadsheets, and presentations.Efficiently manage emails, calendars, and contacts using Microsoft Outlook.Use advanced features of Microsoft Office applications for improved productivity.Collaborate on documents and presentations with others.Apply best practices for data organization and analysis in Microsoft Excel.This course is designed for individuals seeking to enhance their Microsoft Office skills, including professionals, students, and anyone looking to improve their proficiency in office productivity software.Prerequisites: Basic computer literacy and familiarity with the Windows operating system are recommended.
Overview
Section 1: MS Excel
Lecture 1 Intro to Excel
Lecture 2 Add in Excel
Lecture 3 Average in Excel
Lecture 4 Comments in Excel
Lecture 5 Divide in Excel
Lecture 6 Multiply in Excel
Lecture 7 Paste Special in Excel
Lecture 8 Percentage in Excel
Lecture 9 Print in Excel
Lecture 10 Running Total in Excel
Lecture 11 Subtraction in Excel
Lecture 12 Merge in Excel
Lecture 13 Wrap Text in Excel
Lecture 14 Date Formula in Excel
Lecture 15 Month Formula
Lecture 16 Conditional Formatting in Excel
Lecture 17 Create Borders in Excel
Lecture 18 Number Formatting in Excel
Lecture 19 Filter in Excel
Lecture 20 Sort in Excel
Lecture 21 Transpose in Excel
Lecture 22 Count Formula in Excel
Lecture 23 Counta Formula in Excel
Lecture 24 CountBlank Formula in Excel
Lecture 25 Bar Chart in Excel
Lecture 26 Column Chart in Excel
Lecture 27 Line Chart in Excel
Lecture 28 Averageif Formula in Excel
Lecture 29 Countif Formula in Excel
Lecture 30 If Formula in Excel
Lecture 31 Sumif Formula in Excel
Lecture 32 Concatenate In Excel
Lecture 33 Pivot Tables in Excel
Lecture 34 Hlookup in Excel
Lecture 35 Vlookup in Excel
Lecture 36 Large Formula
Lecture 37 Max Formula
Lecture 38 Min Formula
Lecture 39 Median Formula
Lecture 40 Abs Formula
Lecture 41 Cell Formula
Lecture 42 Char Formula
Lecture 43 Clean Formula
Lecture 44 Code Formula
Lecture 45 Exact Formula
Lecture 46 Remove Duplicates
Lecture 47 Averagea Formula
Lecture 48 Averageif Formula
Lecture 49 Averageifs Formula
Lecture 50 Lower Case Formula
Lecture 51 Upper Case Formula
Lecture 52 Proper Case
Lecture 53 Mode Formula
Lecture 54 Rank Formula
Lecture 55 Round Formula
Lecture 56 RoundDown Formula
Lecture 57 Roundup Formula
Lecture 58 Insert Special Characters
Lecture 59 Insert Themes in Excel
Lecture 60 Use Tables in Excel
Lecture 61 Use Templates
Lecture 62 How To Insert A Custom Background Image In Excel
Lecture 63 Random Numbers
Lecture 64 SumProduct Formula
Lecture 65 Data Validation with List Feature
Lecture 66 Data Validation with Date
Lecture 67 Data Validation with Whole Numbers
Lecture 68 Sunburst Chart
Lecture 69 Treemap Chart
Lecture 70 N Formula
Lecture 71 Autofill
Lecture 72 Customize Quick Access Toolbar
Lecture 73 Datedif Formula
Lecture 74 DateValue Formula
Lecture 75 Edate Formula
Lecture 76 Auto Updating DropDown Lists
Lecture 77 Insert Serial Number Automatically
Lecture 78 Choose Formula
Lecture 79 Ceiling Formula
Lecture 80 Correl Formula
Lecture 81 Or Formula
Lecture 82 left Formula
Lecture 83 Mid Formula
Lecture 84 Daverage Formula
Lecture 85 Dcount Formula
Lecture 86 Dcounta Formula
Lecture 87 Dget Formula
Lecture 88 Dmax Formula
Lecture 89 Dproduct Formula
Lecture 90 Dsum Formula
Lecture 91 And Formula
Lecture 92 Isblank Formula
Lecture 93 Iserr Formula
Lecture 94 Sumifs Formula
Lecture 95 Highlight a cell based on a Formula
Lecture 96 Create Pivot Chart
Lecture 97 Slicer in Pivot Table
Lecture 98 Timeline in Pivot Table
Lecture 99 Vlookup with DropDown List
Lecture 100 Indirect Formula
Lecture 101 Multiple Vlookup With Columns Formula
Lecture 102 Compare 2 lists in Excel with Vlookup Formula
Lecture 103 Depreciation Formula
Lecture 104 sum of years depreciation syd
Lecture 105 Straight line depreciation
Lecture 106 PMT Formula New
Lecture 107 IPMT Formula
Lecture 108 Charts That Update Automatically
Lecture 109 Create Combo Chart in Excel
Lecture 110 Create Visual In-cell Indicators In Excel
Lecture 111 Create Visual In-cell Indicators With Icon Sets In Excel
Lecture 112 Sparkline Charts in Excel
Lecture 113 Highlight a Column based on a Formula
Lecture 114 Highlight a Row based on a Formula
Lecture 115 Find Formula
Lecture 116 Replace Formula
Lecture 117 Find and Replace in Excel
Lecture 118 Index 1
Lecture 119 Match 1
Lecture 120 Index and Match 1
Lecture 121 Index and Match 2
Lecture 122 Index and Match 3
Lecture 123 Index and Match 4
Lecture 124 Index and match 5
Lecture 125 Create Custom Tab in Excel
Lecture 126 Customize Status Bar
Lecture 127 Add Password in Excel
Section 2: MS Word
Lecture 128 Learn MS Word for Beginners Entering Text
Lecture 129 Learn MS Word Deleting Text
Lecture 130 MS Word Splitting and Joining Text
Lecture 131 Learn MS Word Undo and Redo
Lecture 132 MS Word Find and Replace
Lecture 133 Learn MS Word Spell Check
Lecture 134 Learn MS Word Check Word Count
Lecture 135 MS Word Print a Document
Lecture 136 MS Word Understanding Section
Lecture 137 Creating Line Numbers in MS Word
Lecture 138 Save As Option in MS Word
Lecture 139 View 2 Documents Side By Side in MS Word
Lecture 140 Enter Footnote And Endnote in MS Word
Lecture 141 Handle Multiple Documents in MS Word
Lecture 142 Insert WordArt
Lecture 143 Highlight Content in MS Word
Lecture 144 Don’t Print Comments in Word
Lecture 145 Print
Lecture 146 Learn MS Word Text Block
Lecture 147 Use Comments in MS Word
Lecture 148 MS Word Apply A Theme
Lecture 149 MS Word Modifying A Theme
Lecture 150 Learn MS Word Create Borders
Lecture 151 MS Word Edit Borders
Lecture 152 Learn MS Word Create Page Border
Lecture 153 Learn MS Word Create Text And Paragraph Border
Lecture 154 Learn MS Word Create Bullet Points
Lecture 155 Convert MSword File To PDF in MS Word
Lecture 156 Convert MSword File To Other Format in MS Word
Lecture 157 MS Word Create Cover Page
Lecture 158 MS Word Creating Headers
Lecture 159 Unlink Images From Text
Lecture 160 MS Word Advanced Headers
Lecture 161 MS Word Text Formatting
Lecture 162 MS Word Formatting a Document
Lecture 163 MS Word Page Formatting
Lecture 164 Use Format Painter in MS Word
Lecture 165 Insert Shape in MS Word
Lecture 166 Insert Clip Art in MS Word
Lecture 167 Insert Text Box in MS Word
Lecture 168 Insert SmartArt in MS Word
Lecture 169 Insert Special Characters in MS Word
Lecture 170 MS Word Learn To Use Styles
Lecture 171 MS Word Creating Formatting Style
Lecture 172 MS Word Assign Shortcut Key to Style
Lecture 173 Learn MS Word Creating Tables
Lecture 174 MS Word editing Tables
Lecture 175 MS Word Design Tables
Lecture 176 Create Table Of content in MS Word
Lecture 177 Insert Image in MS Word
Lecture 178 Mix Image And Text in MS Word
Lecture 179 Moving Images in MS Word
Lecture 180 Insert Video in MS Word
Lecture 181 Mail Merge in MS Word
Section 3: MS PowerPoint
Lecture 182 Intro
Lecture 183 Work With Slides
Lecture 184 Customize Quick Access Toolbar
Lecture 185 Using Multiple Layouts
Lecture 186 Work with Text
Lecture 187 Using Text
Lecture 188 Working Text contd
Lecture 189 Insert Image
Lecture 190 Use Header and Footer
Lecture 191 Slide Design and Size
Lecture 192 Use Inbuilt Templates
Lecture 193 Photo Album
Lecture 194 Use Video
Lecture 195 Use Audio
Lecture 196 Use Shapes
Lecture 197 Use SmartArt
Lecture 198 Use Textbox
Lecture 199 Use Cascade and Arrange Window Options
Lecture 200 Animations
Lecture 201 Record Screen and Audio
Lecture 202 Use Slide Show
Lecture 203 Use Outline View
Lecture 204 Use Slide Sorter
Lecture 205 Use Zoom View
Lecture 206 Use Hyperlinks
Lecture 207 Use Transitions
Lecture 208 Spell Check
Lecture 209 Convert PPT To PDF
Lecture 210 Create Handout
Lecture 211 Protect PPT with Password
Lecture 212 Use Reading View
Lecture 213 Use Handout Master
Lecture 214 Use Notes Master
Lecture 215 Use New Window Option
Lecture 216 Use Thesaurus
Lecture 217 Use Comments
Lecture 218 Use Notes Page
Lecture 219 Use Left Side Menu
Lecture 220 Use Open Command
Lecture 221 Use Save As Option
Lecture 222 Print Options
Lecture 223 Use Find and Replace
Lecture 224 Use Replace Command
Section 4: MS Outlook
Lecture 225 Adding an IMAP or POP account manually
Lecture 226 Backing up or moving Outlook
Lecture 227 Get Addins
Lecture 228 Create New Folder in Outlook
Lecture 229 Manage Inbox
Lecture 230 Read Email
Lecture 231 Search Email
Lecture 232 Sending or receiving email manually
Lecture 233 Setting advanced general Outlook options
Lecture 234 Add Signatures
Lecture 235 Creating personal stationery
Lecture 236 Read Aloud
Lecture 237 Create Voting buttons in a message
Lecture 238 Exploring delivery options
Lecture 239 Exploring other mail settings
Lecture 240 Add Attachment to a email
Lecture 241 Format a email
Lecture 242 Out Of Office Reply
Lecture 243 Reply to All and Forward a Email
Lecture 244 Reply to email
Lecture 245 Write a Email
Lecture 246 Creating search folders
Lecture 247 Mailbox Clean up Tools
Lecture 248 Organizing mail into folders
Lecture 249 Reusing text by creating Quick Parts
Lecture 250 Using conditional formatting to change font and color
Lecture 251 Using filters and the People pane
Lecture 252 Create Rules to manage emails in Outlook
Lecture 253 Creating follow-up flags
Lecture 254 Ignoring conversations and flagging as junk
Lecture 255 Using Quick Steps
Lecture 256 View and Save Attachments
Lecture 257 Create New Contact Group
Lecture 258 Navigate People Hub and Create a Contact
Lecture 259 Creating an appointment
Lecture 260 Navigating the Calendar
Lecture 261 Printing, emailing, and sharing the calendar
Lecture 262 Setting calendar preferences
Lecture 263 Create and Assign Task
Lecture 264 Navigating Tasks
Lecture 265 Creating a meeting
Lecture 266 Responding, Sharing, Editing and Canceling meeting
Lecture 267 Creating Notes
This course is designed for individuals seeking to enhance their Microsoft Office skills, including professionals, students, and anyone looking to improve their proficiency in office productivity software. Prerequisites: Basic computer literacy and familiarity with the Windows operating system are recommended.

Homepage

https://www.udemy.com/course/ms-office-j/