MS Office Training - Basic to Advance Level
1 month of Skillshare
Available with PurchaseFree
All memberships will be billed automatically on a recurring basis until canceled. If eligible for a free trial, cancel before the trial ends to avoid being charged. Offer only valid for new paid subscribers. See full terms of service here.
About this product
Himanshu Dhar
MIS Trainer
Welcome to the comprehensive Microsoft Office Complete Online Course. This course is meticulously designed to equip you with the essential skills needed to excel in the use of Microsoft Office applications, including Excel, Access, Word, and PowerPoint.
Course Duration: 10 hours 12 Minutes
Total Videos: 114
Excel Essentials:
1 Excel Structure and Basics
2 Overview of Excel structure
3 Understanding cell properties
4 Autofill for values, text, and dates
5 Advanced Autofill tools
6 Text functions including UPPER, LOWER, PROPER, and TRIM
7 Operators based equations
8 Math functions and text functions like RIGHT, LEFT, FIND, MID, CONCATENATE, REPLACE, SUBSTITUTE, LEN, REPT, EXACT, and SEARCH
9 Text to column functionalities
10 Workbook and sheet protection techniques
11 Logical and Conditional Functions:
12 Introduction to IF function and logical tests
13 Advanced IF functions including nested IF
14 Understanding AND and OR functions and their combinations
15 Exploring the usage of IF, AND, and OR together
16 Pivot Tables and Data Analysis:
17 Introduction to Pivot Tables
18 Managing field areas and value field reports
19 Working with slicers and duplicate pivot tables
20 Grouping data to manage dates and values
21 Inserting calculated fields
22 Goal Seek and Scenario Manager
23 Utilizing PMT function for EMI calculation
24 Creating data tables for loan calculations
25 Advanced Excel Features:
26 Printing options in Excel
27 Sharing workbooks and collaboration features
28 Chart preparation including advanced customization
29 Conditional formatting and data validation
30 Advanced math functions
31 Lookup functions like VLOOKUP, HLOOKUP, MATCH, and INDEX
32 Understanding VLOOKUP array and column tricks
33 Macro recording and execution techniques
Access Fundamentals:
1 Introduction to MS Access
2 Overview of MS Access and its functionalities
3 Creating Tables in MS Access
4 Understanding table creation and design
5 Importing and Exporting Data in Access:
6 Techniques for importing and exporting data
7 Creating Forms from Tables
8 Form creation from existing tables for data entry
9 Generating Reports in Access
10 Report generation based on database queries
11 Querying in Access Databases
Word Mastery:
1 Introduction to MS Word:
2 Overview of Word interface and functionalities
3 Font Formatting and Styles
4 Understanding font formatting options and styles
5 Page Layout Options
6 Customizing headers, footers, page numbers, colors, and borders
7 Text Formatting
8 Incorporating text boxes, WordArt, drop caps, and symbols
9 Advanced Features
10 Hyperlinks, bookmarks, cross-references, watermarks, table of contents, bibliography, citations, captions, footnotes, endnotes, mark entry, and mail merge
11 Print-related options and track changes in Word
PowerPoint Proficiency:
1 Introduction to PowerPoint
2 Overview of PowerPoint interface and functionalities
3 Formatting Slides and Managing Videos
4 Techniques for slide formatting and video management
5 Slide Show Options
6 Customizing slide show options for presentations
7 Designing Slides:
8 Creating captivating presentations with transitions and animations
FAQs
What are digital products?
Digital products at Skillshare are expertly crafted tools, resources, and templates developed by top creatives that are available to you for purchase. With a wide range of resources to suit every creative need, they are actionable, making your learning experience real and unforgettable.
How can I purchase a digital product?
Anyone can purchase a digital product on Skillshare — click Buy now to enter your payment information and complete your purchase. Once payment is complete, all files will be available for download instantly from this page. You'll also receive an email with a link to download your digital product after purchase.
Is there a limit to how many times I can download a digital product?
No, there is no limit to how many times you can download a digital product. Even if a product is removed by the creator, you can still access the download page in most cases by logging in to your Skillshare account.
Can I get a refund or cancel my digital product purchase?
Digital products are non-refundable and cannot be returned or canceled. To learn more, see our refund policy in the Skillshare Help Center.
Can I make and sell my own digital products?
Absolutely! Visit How can I sell a digital product on Skillshare? to learn how you can create, list and sell your own digital products on Skillshare.