Become An Ace of MS Office
Description
WHAT WILL YOU LEARN IN THIS COURSE:
Presentation dos and don'ts
Text and bullet edition options
How to use graphics, images, objects and shapes
Using SmartArt
Working with Charts and Graphs
How to utilize Master Slides and just how much time this could save you
How to add audio and video to a presentation
All about transitions between slides
Animation, the animation pane and motion paths
Setting your slideshow options
Presentation preparation and delivery
The backstage area of PowerPoint including printing a presentation
How to get started with Word 2019
Word 2019 basics including navigation, editing and saving
Character formatting in Word including Format Painter and AutoCorrect
How to properly work with bullets and numbering in Microsoft Word
All about formatting paragraphs and managing lists
Working with Tables in Word including formatting, converting data and formulas
Page appearance including page-breaks, watermarks and styles
All about Sectioning a document
Inserting graphics, pictures, shapes, icons and 3d models (new for 2019)
How to work with envelopes and labels
All about mail-merge and operating Word at scale
How to create an Index or Contents page
Reviewing and Printing in Word and Page Setup
Protecting a Word document and basic macros in Word
What's new in Excel 2019
Creating workbooks
Entering text, numbers and working with dates
Navigating workbooks
Page setup and print options
Working with rows, columns and cells
Cut, Copy and Paste
Introduction to functions and formulas
Formatting in Excel, including formatting cells and numbers
Creating charts and graphs
Sorting and Filtering
Introduction to PivotTables
Lessons
- 24 Lessons
- 04 hours 45 mins 27 secs
- Introduction 5 mins 18 secs
- Navigation Pane 10 mins 34 secs
- Working with Rulers in MS Word 19 mins 28 secs
- Understanding Paragraph Settings, Bullets and Fonts 15 mins 41 secs
- Working with Tables in Word including formatting, converting data and Formulas 12 mins 55 secs
- Understanding Signature Line and Pictures 7 mins 23 secs
- How to work with Index and Content Page 8 mins 19 secs
- Page Appearance, Water Marks and Styles 6 mins 59 secs
- Inserting graphics, Pictures, Shapes, Icons and 3d Models 20 mins 34 secs
- Introduction 12 mins 26 secs
- Rows, Columns, Editing Features and Home Tab 16 mins 1 secs
- Understanding Formulas and it's Composition 15 mins 32 secs
- Understanding different dimensions of sum, Calculating percentages and grades. 13 mins 1 secs
- Absolute and Relative References and Rank Function 10 mins 9 secs
- Formatting a document and data validation 13 mins 36 secs
- Grouping, Ungrouping and SubTotal 9 mins 33 secs
- Understanding the function of SUMIF 11 mins 20 secs
- All about pivot Tables 10 mins 22 secs
About instructor
Reviews
Need some basic video editing improvements and some topic theory must be explained about verstility of topic (i.e applications of function and formula etc.)