Brochure
Enquire- Introduction
- WATCH ME: Essential Information for a Successful Training
- Experience
- Excel 2013 Exercise Files
- Downloadable Course Transcripts
- Templates; Creating, Opening, and Saving a Workbook
- Online, Offline, and Contextual Help
- Excel Options
- Ribbon Interface
- Quick Access Toolbar
- Mini Toolbar
- Create Backup Option; Auto-Recover and Autosave
- Entering Text and Numbers
- Date Formats
- Formatting Cells; Editing and Deleting Data
- Fill
- Themes and Cell Styles
- Inserting, Deleting, Hiding and Adjusting Rows and Columns
- Wrap Text and Alignment
- Merging Cells; Applying Themes and Styles
- Borders
- Copy, Cut and Paste
- Spell checking
- Moving, Copying, Inserting, Deleting and Locking Sheets;
- Multiple Worksheets
- Inserting Comments
- Workbook Views, Zoom and Freeze
- Printing; Headers, Footers and Margins
- Overview of Formulas and Functions
- Cell References
- Names
- Finding Errors; New Excel Functions
- Multiple Workbooks and Windows; Comparing Workbooks
- Go to; Find and Replace Options
- Applying, Clearing and Managing Rules
- Chart Types; Chart Recommendation
- Basic Formatting
- Selecting Data, Positioning and Printing Charts
- Saving Workbooks; PDF and CSV Formats
- Sorting
- Filtering
- Tables
- VLOOKUP
- Text Function
- Date and Time Functions
- Logical Functions
- Financial Analysis Case Study - Part 1
- Financial Analysis Case Study - Part 2
- Quick Analysis Tool
- Adding and Formatting Shapes, Picture, Clip Art, WordArt and
- SmartArt
- Protecting Worksheets
- Protecting Workbooks
- Sharing and SkyDrive
- Trust Center; Export; Inspect Workbook
- Summary; More Help
- Microsoft Excel 2013 Quiz
- What's New
- Overview of Principles
- Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
- Flash Fill
Online
₹ 499 3,499
Quick facts
| particular | details | |
|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course overview
Microsoft Office is the most popular office software in the world, with over 1 billion users. While most individuals are compatible with Microsoft Office's fundamental features, few are aware of its advanced features, which are meant to save time, budget, and effort. Simon Sez IT, an online training portal that provides courses in information technology, established the MS Office 2013: 10-in-1 Courses To Maximize Productivity certification, which is delivered by Udemy.
MS Office 2013: 10-in-1 Courses To Maximize Productivity online course aims to provide a solid understanding of advanced concepts and principles relevant to Microsoft Office 2013, including pivot tables, charts, the ribbon interface, hyperlinks, operators, expressions, VLOOKUP, the quick access toolbar, and the mail marge, among others. MS Office 2013: 10-in-1 Courses To Maximize Productivity online classes offer 80 hours of video lectures aimed at providing a thorough understanding of the features of Microsoft Office products such as Excel, Word, Outlook, PowerPoint, Access, Publisher, and VBA.
The highlights
- Certificate of completion
- Self-paced course
- 80 hours of pre-recorded video content
- 23 articles
- 16 downloadable resources
- Quizzes
Program offerings
- Online course
- Learning resources. 30-day money-back guarantee
- Unlimited access
- Accessible on mobile devices and tv
Course and certificate fees
Fees information
₹ 499 ₹3,499
certificate availability
Yes
certificate providing authority
Udemy
What you will learn
Knowledge of excel
After completing the MS Office 2013: 10-in-1 Courses To Maximize Productivity online certification, participants will have a better knowledge of Microsoft Office 2013's fundamental as well as advanced concepts and principles. Participants will explore the functionalities of applications like Excel, Word, PowerPoint, Outlook, Access, Publisher, and VBA. Participants will learn about Pivot tables, charts, ribbon interfaces, operators, expressions, and VLOOKUP. Participants will also learn how to use the quick access toolbar, hyperlinks, and the mail marge in the Microsoft Office environment.
Who it is for
The syllabus
Learn Microsoft Excel 2013 Beginner Course
Learn Microsoft Excel 2013 Advanced Training Course
- WATCH ME: Essential Information for a Successful Training
- Experience
- Excel 2013 Advanced Exercise Files
- Downloadable Course Transcripts
- Payment
- Future Value
- Principle Payment
- Depreciations
- How Dates and Times are Stored
- Dates and Times Calculation
- Exercise on Date and Time Functions; Date and Time Settings
- Average
- Percentile
- Regression
- LINEST Function
- Example of Functions for Inferential Statistics
- Text Function Case Study - 1
- Text Function Case Study - 2
- Lookup and Reference Functions
- Logical Functions
- Connecting to Other Workbooks
- Connecting to Access Data
- Connecting to Web Data
- Creating a Table and Changing Table Name; Filter; Removing
- Duplicates; Total Row
- Inserting Columns and Rows; Resizing Tables
- Table Reference
- Table Styles
- Table Selection
- Basic Principles of Pivot Tables
- Presentational Side of Pivot Tables
- Filtering in Pivot Tables; Slices
- What if
- Scenario Manager
- Goal Seeker
- Solver
- Area Charts
- Surface Charts
- Stock Charts - Part 1
- Stock Charts - Part 2
- Radar Charts
- Bubble Charts
- Regression and Scatter Chart
- Creating Pivot Charts
- Using Sparklines
- Creating Workbooks using a Web App
- Sharing your Workbook
- Closing
- Microsoft Excel 2013 Advanced - Quiz
- Prerequisites of Excel 2013 Advanced Course
- List of Functions; Common Types of Arguments; Basic Use of
- Functions
- Advanced Aspects of Functions; Searching for a Function
- Autosum
Learn Microsoft Word 2013
- WATCH ME: Essential Information for a Successful Training
- Experience
- Word 2013 Exercise Files
- Downloadable Course Transcripts
- Starting and Exiting; Templates; Creating, Opening and Saving
- Documents
- Word Workspace; Backstage View
- Online and Offline Help
- Settings and Preferences
- The Ribbon
- Mini Toolbar/Bar
- Setting Up AutoSave and AutoRecover Preferences
- Typing, Editing, and Deleting Text; Customizing Status Bar
- Navigation; Word Wrapping; Making a Selection
- Inserting Symbols, Date and Time, and Document Property
- Various Methods of Copying, Cutting and Pasting
- Uses of Navigation Pane
- Find and Replace; Go to
- Keyboard Shortcuts and Key Tips
- Print Layout, Web Layout and Draft Views; Ruler and Gridlines
- Zoom
- Read Mode
- Spelling and Grammar Errors; Language Settings
- AutoCorrect; Proofing Settings; Spell Checking
- Fonts, Font Size, and Font Colors; Text Effect and Text Highlight
- Alignment; Line and Paragraph Spacing; Indent
- Fill/Shading; Border Tab; Format Painter
- Bulleted, Numbered and Multilevel Lists
- File Formats
- Printing
- Page Layout, Sections and Margins
- Headers, Footers and Page Numbers
- Using Templates
- Using Themes and Styles
- Opening and Editing PDFs
- Creating a Table; Inserting, Selecting and Deleting Rows and
- Columns
- Formatting Tables
- Inserting, Cropping, Resizing and Positioning Pictures
- Picture Styles; Picture Adjustments, Corrections and Effects
- Online Pictures and Clipart
- Inserting and Formatting Shapes and Textbox
- Smart Art and WordArt
- Screenshots
- Creating Charts
- Resume Reading and Editing
- Object Zoom
- Mail Merge Wizard Part 1
- Mail Merge Wizard Part 2
- Send to Email; Post to Blog; SkyDrive; Invite People
- Restrict Editing, Comments, Simple Markup and Tracking
- Changes
- Navigation, Headings, Table of Contents, Update Page numbers
- and Outline View
- Watermarks
- Page Borders
- Types of Hyperlinks
- Inspecting and Protecting Documents
- Microsoft Update; Closing
- Microsoft Word 2013 - Quiz
- Acquiring Word 2013; Information about Installing and
- Upgrading
- What's New
- Overview of Principles
- Quick Access Toolbar
Learn Microsoft Outlook 2013
- READ ME: Essential Information for a Successful Training Experience
- Information about Installation and Upgrade
- Downloadable Course Transcripts
- Outlook 2013 Workspace
- The Ribbon
- Quick Access Toolbar
- Mini Toolbars
- Contextual Menu
- Status Bar
- Customizing Settings and the Use of Outlook
- List of Keyboard Shortcuts; Using Key Tips
- Setting Up an Account
- Sending and Receiving Email
- Creating Appointments and Scheduling Meetings
- Adding Contacts
- Adding Tasks
- Creating Notes
- Managing RSS Feeds
- Printing Emails and Contacts; Print Properties
- Favorites; PST and OST Files; Folder Size
- Setting Up Gmail and POP Accounts
- Adding New Folder, Moving and Deleting Items, and Emptying
- Folders
- Backup and Restore a PST file
- AutoArchive and Manual Archive
- Import and Export Wizard
- Calendar Options
- Calendar Amendments and Rescheduling
- Calendar Recurrence
- Calendar Attachments
- Calendar Events
- Managing Reminders
- Basics of Search; Searching Contacts
- Search Folders
- Color Categories
- Managing Tasks
- Contacts Options
- Contact Information
- Outlook Social Connector
- Contact Views
- Contact Groups
- Email Options
- Email Send and Receive Settings
- Composing Email
- Email Signatures
- Email Inbox
- Email Actions
- Touch Action Bar
- Junk Email
- Stationery
- Rules
- Quick Steps
- Outlook Journal
- Mail Merge using Word
- Trust Center
- Microsoft Updates; Closing
- Microsoft Outloook 2013 - Quiz
- What's New in Outlook 2013
- Using Touch
- Online, Offline, and Contextual Help
Learn Microsoft PowerPoint 2013
- WATCH ME: Essential Information for a Successful Training
- Experience
- PowerPoint 2013 Exercise Files
- Downloadable Course Transcripts
- What's New in PowerPoint 2013
- Using Touch
- PowerPoint Workspace; Opening, Saving and Exiting
- Backstage View; Protecting Presentations; Editing Properties
- Online and Offline Help
- Customize Settings and Preference
- The Ribbon
- Quick Access Toolbar
- Mini Toolbar
- Status Bar
- Backup Files; Adjust AutoSave; Recover Unsaved Presentation
- Adjusting View and Adding Notes in Normal View;
- Promote/Demote
- Moving Slides in Slide Sorter View; Notes Page and Reading
- View
- Zoom
- Undo and Redo Actions; Set Maximum Number of Undos
- Adding and Formatting Text; Placeholder Textbox
- Manual Textbox; Inserting Symbols
- Using Clipboard and Mini Toolbar; Paste Option
- AutoCorrect and Proofing
- Templates, Slides and Masters
- Background Color, Themes and Layouts
- Header and Footer
- Bulleted and Numbered Lists
- Alignment, Line Spacing, Ruler and Tabs
- Inserting Pictures
- Formatting Pictures
- Photos and Photo Albums
- Clip Art
- Screenshots
- Drawing and Formatting Shapes
- Creating Complex Shapes
- SmartArt
- Save Options, Create PDF/XPS Document, Change File Type
- Creating and Formatting Tables
- Creating Charts using Excel; Editing Data, Chart Type and Chart
- Element
- Basics of Animation
- Controlling Animation; Motion Path
- Animation of SmartArt
- Printing Slides and Handouts
- Linking to a Webpage and a Slide
- Aligning Objects; Grid and Guides; Nudging
- Spell check; Create Handouts and Videos; Inspect Document;
- Hide Slide
- Transitions and Timings; Setting up and Recording a Slide Show
- Manual Presentation; Presenter View and Tools
- Comments
- Saving your Presentation on SkyDrive
- PowerPoint Web App; Send Email; Get a Link
- Presenting on the Web
- Inserting and Formatting Video; Adding Audio
- Protecting your Presentation; Trust Center; Closing
- Microsoft Powerpoint 2013 - Quiz
- Acquiring PowerPoint 2013
- New Blank Presentation; Slide Size, Orientation and Background
- Adding Contents; Adding and Deleting Slides
Learn Microsoft Access 2013 Beginner Course
- Acquiring Access 2013; Course Overview
- WATCH ME: Essential Information for a Successful Training
- Experience
- Access 2013 Exercise Files
- Downloadable Course Transcripts
- What's New in Access 2013
- Using Touch
- Database Templates; Creating, Opening and Saving Databases
- Workspace and Backstage View
- Online, Offline, and Contextual Help
- Finding Keyboard Shortcuts and Key Tips
- Customizing the Settings and Use of Access 2013
- The Ribbon
- Quick Access Toolbar
- Customizing the Status Bar
- Overview of the Main Features of Access Database
- Web App Basics
- Relationships Between Tables - Part 1
- Relationships Between Tables - Part 2
- Inserting and Formatting Fields; Field Validation; Navigation
- Buttons
- Sorting, Filtering and Finding Data
- Entering Data; Changing the Order of Columns, Field Width and
- Height
- Design View; Field Properties
- Saving Data; Data Types, Attachments and Field Size
- Input Masks; More on Field Properties
- Creating Forms; Form Wizard
- Single Forms; Insert, Delete, Modify, Sort and Filter Records
- Layout View; Adding Existing Fields
- Design View; Arranging Fields
- Controls
- Form Design
- Query Design
- Joins and Query Wizard
- Query Types
- Operators and Expressions - Part 1
- Operators and Expressions - Part 2
- Operators and Expressions - Part 3
- Subforms
- Report Wizard; Previewing a Report
- Report Design
- Grouped and Summary Reports; Modifying a Report
- Adding Subreports
- Documenter; Print Properties and Options
- Import and Append; Copy and Paste; Export Access Database
- Database Templates and Application Parts
- Navigation Form
- Modal Dialogs - Part 1
- Modal Dialogs - Part 2
- Modal Dialogs - Part 3
- Actions; Example of VBA; Creating AutoExec Macro
- More Access Options
- Info Tab
- Trust Center
- Updates; Closing
- Microsoft Access 2013 - Quiz
- Creating Tables - Part 1
- Creating Tables - Part 2
Learn Microsoft Access 2013 Advanced Training Course
- WATCH ME: Essential Information for a Successful Training
- Experience
- Access 2013 Advanced Exercise Files
- Linking to Other Access Database Tables
- How to Install SQL Server Express
- Setting up a Database, Accessing MDF file, and Linking via ODBC
- using SQL Server
- Reasons to Split a Database; Splitting a Database to a Front-end
- and a Back-end
- Consequences of the Split; Moving a Database; Adding a Trusted
- Location
- Access Options relating to Multi-user Issues; Record Locking
- Basics of Macros and Properties of Macro Editor
- Examples of Macros; Autoexec
- More Autoexec
- Macro Security
- Customizing the Quick Access Toolbar and the Ribbon
- Convert Macro to VBA; VBA Editor
- Reorganizing VBA Workspace; Developing, Debugging and
- Running VBA Codes
- Modules, Subs, Options Explicit, and Variables
- Scope of Variables
- Branch and Loop
- Customizing Events
- Responding to Events and Developing Error Handles
- More on Events
- Getting Help with Events
- Basics of Forms: Review and Tips and Tricks
- Advanced Features of Forms - Part 1
- Advanced Features of Forms - Part 2
- Advanced Features of Forms - Part 3
- Advanced Features of Forms - Part 4
- Basics of Queries: Review
- Main Features and Syntax of SQL Statements
- Use of Multiple Criteria of a Where Clause
- How Joins Look in SQL Statements and using Query Grids
- Update Query
- Delete and Make Table Queries
- Append Query
- Protecting your Database and Codes
- Making your Database More User-Friendly
- Setting up an Access Web App
- Building Basic Web Apps
- Closing
- Microsoft Access 2013 Advanced - Quiz
- Prerequisites and Basic Knowledge of Access 2013
- Indexes and Introduction to the Movies Database
- Basics in Working with Datasheet View
- Controlling the Display and Advanced Sorting and Filtering in
- Datasheet View
Learn Microsoft Publisher 2013
- WATCH ME: Essential Information for a Successful Training
- Experience
- Publisher 2013 Exercise Files
- Downloadable Course Transcripts
- Interface Overview: The Publisher Application
- Insert, Move, Rename and Delete Pages
- Viewing and Navigating Pages
- Rulers, Measurements, and Guidelines
- Establishing Business Information
- Setting Preferences
- Saving Your Publication
- Inserting a Text Box
- Formatting a Text Box
- Introduction
- Create a New Publication
- Interface Overview: Backstage View
- Character Formatting Options
- Working with Font Schemes
- Importing Text from Word
- Working with Columns
- Setting Paragraph and Line Spacing Options
- Inserting Hyperlink Text
- Inserting Special and Break Characters
- Performing a Spell Check
- Using Find and Replace Feature
- Paragraph Formatting Options
- Working with Tab Stops
- Working with Styles
- Bitmap vs. Vector Images
- Digital Image File Formats
- Inserting Images and Image Placeholders
- Move, Resize and Crop Images
- Utilizing the Adjustment Settings
- Adding Captions and Alternate Text to Images
- Inserting Page Parts, Borders and Accents
- Inserting a Basic Shape
- Formatting a Shape
- Drawing Lines with Line Tools
- Editing a Shape using Anchor Points
- Comparing Color Models
- Exploring RGB, CMYK, and Pantone Colors
- Using Adobes Kuler Tool
- Creating and Applying Color Schemes
- Tints, Gradients, Textures and Patterns
- Applying Custom Colors
- Utilizing the Scratch Area
- Arranging, Grouping and Ungrouping Objects
- Rotating, Flipping, Nudging and Aligning Objects
- Wrapping Text around Objects
- Utilizing the Format Painter
- Saving an Object as a Building Block
- Inserting a Table
- Inserting and Deleting Rows and Columns
- Formatting a Table
- Working with Master Pages
- Applying a Page Background
- Managing Page Setup Options
- Starting a Mail Merge
- Selecting Mail Merge Recipients
- Inserting Merge Fields
- Previewing and Completing a Mail Merge
- Working with Skydrive
- Running Design Checker and Managing Embedded Fonts
- Printing a Publication
- Additional Saving and Print Options
- Course Summary
- Microsoft Publisher 2013 - Quiz
- Bonus lecture
Essential VBA Training for Excel - Automate Repetitive Tasks
- WATCH ME: Essential Information for a Successful Training
- Experience
- VBA Exercise Files
- First Coding Manipulations
- VBA Syntax, Keywords, and Comments
- Objects and VBA's Intellitext
- Variables and Method Calling Rules
- How to Define and Manage Variables
- Constant Variable Types and Variables through Intellitext
- Subroutines
- Logical Constructs: The Boolean Type
- Logical Constructs: If and Switch Statements
- Methods for Communicating to the User
- Looping: The For and Do While Loops
- Looping: Collections and the For Each Loop
- Functions
- Returning Values from Functions
- Determining Limitations
- Sending Values to Functions
- The Worksheet Function Object
- Completing Exercise 5
- The Range Object
- Writing an Array Formula
- The Application Object
- The Workbook and Worksheet Objects
- Using Errors to Guide You
- The Name and Names Objects
- The PivotTable Object
- The Chart and ChartObject Objects
- The PageSetup Object and Print Ranges
- One Approach To Completing Exercise 8
- Concluding Remarks
- VBA Course Quiz
- Introduction to the VBA Course
- Getting Started
- The VBA Editor
VBA Intermediate Course
- WATCH ME: Essential Information for a Successful Training
- Experience
- Course Exercise Files
- Course Support Files
- Excel File Types
- Code Modules
- Detailed Memory Management
- Code Module Interactions
- The VBA Project Model
- Advanced Parameter Definitions
- What Are Events?
- Pre-Defined Events
- Event Parameters
- A Series Of Example Events
- Application Events
- Chapter Overview + New Keyword
- Creating A Custom Type
- Create a New Class
- Defining a Class
- Practical Example of a Class
- Practice Test of a Class
- Special Class Variables and Components
- Initialization and Termination
- VBA Attributes and Usage
- Inheritance - Defining the Bookmarks Support Class
- Creating a Userform
- Designing a Userform
- Coding a Userform
- Modding the Excel Interface
- UI Interface Scope and Range
- Course Overview
- Chapter 2 Preview
- UI Interface Control Options and Access
- What are References? How do they work?
- Course Conclusion
- Reference Object
- Office Libraries
- ADODB Library
- The Scripting Library
- VBA Intermediate Course Quiz
Extras
- EXTRA RESOURCE: The Most Frequently Used Excel Shortcuts - Infographic
- EXTRA RESOURCE: The Most Frequently Used PowerPoint Shortcuts - Infographic
- EXTRA RESOURCE: The Most Frequently Used Access Shortcuts - Infographic
- EXTRA RESOURCE: The Most Frequently Used Word Shortcuts - Infographic
- EXTRA RESOURCE: The Most Frequently Used Outlook Shortcuts - Infographic
