The Ultimate Microsoft Office 2010 Training Bundle 48 Hours

BY
Udemy

Gain a hands-on understanding of the essential principles and methodologies associated with Microsoft Office 2010 from scratch.

Mode

Online

Fees

₹ 449 3099

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

Microsoft Office 2010 is a popular edition of the popular office applications, but it's indeed one of the most challenging editions for some individuals to grasp, particularly to the addition of Microsoft's now-ubiquitous 'Ribbon' interface. The Ultimate Microsoft Office 2010 Training Bundle 48 Hours online certification is designed by Simon Sez IT, an e-learning portal that offers information technology courses and is made available by Udemy.

The Ultimate Microsoft Office 2010 Training Bundle 48 Hours online classes are designed for learners who wish to learn how to use Microsoft Office 2010 applications such as Excel, Word, Access, PowerPoint, and Outlook. With The Ultimate Microsoft Office 2010 Training Bundle 48 Hours online classes, learners will gain a thorough understanding of concepts such as state management, database security, and data normalization, as well as be able to work on projects that include multiple chats, tables, transitions, and animations.

The highlights

  • Certificate of completion
  • Self-paced course
  • 48 hours of pre-recorded video content
  • 12 articles
  • 5 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
₹ 449  ₹3,099
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

Knowledge of excel

After completing The Ultimate Microsoft Office 2010 Training Bundle 48 Hours certification course, learners will become familiar with the principles and methodologies associated with Microsoft Office 2010. Learners will study the features of Word, PowerPoint, Excel, Outlook, and Access. Learners will study how to work with animations, transitions, hyperlinks, and ribbon interfaces as well as various charts, notes, and tables such as pivot tables. Learners will also explore slide management, database security, and data normalization procedures.

The syllabus

Learn Microsoft Excel 2010 Beginner Course

  • Introduction and Overview of Excel 2010 Course
  • READ ME: Essential Information for a Successful Training Experience
  • Overview of the Excel Window
  • Working with the Mouse
  • Excel Options
  • Entering Text and Numbers
  • Creating Basic Formulas
  • Relative References
  • Order of Operations
  • Working withe Ranges
  • Working with Save and Save As Commands
  • File Extensions
  • Opening a FileWorking with Larger Files
  • Freeze Panes Options
  • Split Screen Option
  • Page Setup Options
  • Headers and Footers
  • Print Titles
  • Comments
  • Fit to Print on One Page
  • Printing Workbooks
  • Adding and Deleting Rows, Columns, and Cells
  • Changing Column and Row Widths
  • Cut, Copy and Paste
  • Copying Formulas
  • Overview of Formulas
  • Create Formulas using Functions - Part 1
  • Create Formulas using Functions - Part 2
  • Absolute Values
  • Adding, Deleting and Renaming Sheets
  • Additional Sheet Tab Options
  • 3-D Formulas
  • Cell Formatting
  • Number Formatting
  • Borders and Shading
  • Format as Table
  • Using Styles
  • Using Format Painter
  • Protecting Sheets
  • Fill Handle and Custom Lists
  • Creating Charts
  • Types of Charts
  • Editing Charts
  • Using Graphics to Enhance Charts
  • Creating Range Names
  • Managing Names
  • Using Names in Formulas
  • Removing Duplicates
  • Sort Data
  • Filter Data
  • Advanced Filters
  • Creating an Outline - Part 1
  • Creating an Outline - Part 2
  • Subtotals
  • New Window Option
  • Arrange File Options
  • Creating a Workspace
  • Custom Views
  • Scenarios
  • Creating Formulas Between Files
  • Working with Links
  • IF Statement
  • VLookups
  • Consolidating Data
  • Data Validation
  • Formula Auditing
  • Comments
  • Goal Seeker
  • Text to Columns Option
  • Watch Window
  • Closing Video
  • Excel 2010 Quiz

Learn Microsoft Excel 2010 Advanced Course

  • Introduction to Advanced Excel 2010
  • READ ME: Essential Information for a Successful Training Experience
  • Four Basic Steps When Creating Charts/Graphs
  • Additional Features to Help Create Charts/Graphs
  • Additional Features to Help Create Charts/Graphs Part 2
  • Detailed Formatting for Charts/Graphs
  • Formatting Legends within Charts/Graphs
  • Formatting Axes and Gridlines within Charts/Graphs
  • Trends within Charts and Graphs
  • Complex Trends within Charts and Graphs
  • Trends over Time within Charts and Graphs
  • Showing Differences Using Bar Charts
  • Showing Differences Using Pie Charts
  • Limitations with Pie Charts & How to Correct
  • Alternative Ways to Show Differences
  • Using Charts & Graphs to Show Relationships
  • Using Charts & Graphs to Show Relationships Part 2
  • Charting & Graphing Financial Information
  • Charting & Graphing Financial Information Part 2
  • Specific Charts for Finance Information
  • Setting Up Live Charts
  • Using Sparklines for Data Visualization
  • Using and Formatting Data Bars, Color Scales & Icon Sets
  • Setting Up Pivot Tables/Charts
  • Setting Up Pivot Tables/Charts Part 2
  • Filtering Pivot Tables/Charts
  • New Features for Pivot Tables/Charts
  • Graphics Tools
  • Graphics Tools Part 2
  • Exporting Charts and Graphs
  • Exporting Charts and Graphs Part 2
  • Excel 2010 Advanced Quiz

Learn Microsoft Word 2010

  • Getting Started in Word 2010
  • READ ME: Essential Information for a Successful Training Experience
  • Learning the Workspace
  • Learning the Workspace Part 2
  • Create New Document, Using Templates, and Page Setup
  • Converting and Saving Documents
  • Selecting Text; Cut, Copy, Paste; Drag & Drop
  • Insert/Overtype; Navigation Pane; Find & Replace
  • Hyphenation, Auto-Correct, and Redo
  • Text Formatting
  • Paragraph Formatting Options
  • Formatting with Bullets, Indents, Borders, Shading
  • Creating/Saving New Template; Changing Styles
  • Managing, Modifying and Deleting New Styles
  • Working with/Using Themes
  • Inserting/Formatting ClipArt, Pictures
  • Using Picture Tools & New Features
  • Inserting Screenshots, Using WordArt
  • Using SmartArt, SmartArt Tools
  • Inserting Tables; Adding Text; Selecting Parts of Tables
  • Formatting Tables; Table Tools
  • Inserting Charts; Chart Tools
  • Creating Charts with Pre-existing Data
  • Desktop Publishing Adding Drop Caps, Watermarks, Borders, Page Colors
  • Using/Formatting Multi-Columns; Text Boxes
  • Inserting/Resizing Shapes
  • Stacking, Grouping Objects
  • Creating Outline, Sub-Documents
  • Expand/Collapse Sections; Document Properties; Cover Pages
  • Add Table of Contents: Header & Footer Tools; Quick Parts
  • Line-numbering, Adding Bibliography & Index
  • Understanding Formatting Marks; Sections Features
  • Inserting Symbols, Equations, Auto-Text, Building Blocks
  • Inserting Footnotes, Bookmarks, Cross-references
  • Setting up Mail Merge Using Wizard
  • Manual Mail Merge Set-up
  • Spelling/Grammar Check
  • Using Thesaurus, Research Option, Translate; Printing Document
  • Publishing to Web Publishing & Accessing Word Documents on Web
  • Using Document Inspector, Password Protect, Editing Restrictions
  • Reviewing & Sharing Reviewing, Sharing and Leaving/Adding Comments
  • Customizing Word Customizing with Word Options
  • Expanding Word Functionality; Using Macros
  • Importing/Exporting, Embedding Document to Other Programs
  • Check for Updates, Safe Mode
  • Word 2010 Quiz

Learn Microsoft Outlook 2010

  • Getting Started
  • READ ME: Essential Information for a Successful Training Experience
  • Course Review
  • Overview of Calendar, Appointments, Contacts, Tasks, Notes
  • Adding New Accounts, Removing Accounts
  • Add Items, To-Do Options and Customization
  • Creating New Task, Modifying Details, Recurring Tasks
  • Calendar Displays, Set Up/Edit/Delete Appointments
  • Using Help Options; Add/Edit/Delete Contacts
  • Create, Edit, Forward Notes
  • Options, Create, Send Journal Entries
  • Customize Quick Access Toolbar & the Ribbon
  • Customizing Workspace Views Part 1
  • Customizing Workspace Views Part 2
  • Managing Data File Folders
  • Outlook Connector; Customizing Mail
  • Creating Rules for Sent/Incoming Emails
  • Formatting Email Messages
  • General Mail Options
  • Assigning/Completing Tasks
  • Forward/Edit/Group Contacts
  • Setting Up Meeting Requests; Calendar Options
  • Setup RSS Feeds
  • Organize RSS Feeds, New Social Connection
  • Junk Mail Options, Dealing with Junk Mail
  • Filtering Through & Searching for Specific Emails
  • Auto Archive Options & Manual Archive
  • Email Security & Maintenance
  • Outlook 2010 Quiz

Learn Microsoft PowerPoint 2010

  • Introduction
  • READ ME: Essential Information for a Successful Training Experience
  • Introduction to PowerPoint 2010 Basics
  • Start and Exit
  • PowerPoint 2010 Window
  • The Ribbon
  • The Backstage: Open, Save, Close
  • Options
  • Different Views
  • Introduction to Working with Slides
  • Manage Slide Appearance
  • Working with Text
  • Outlining a Presentation
  • Slide Management
  • Working with Shapes
  • Working with Tables
  • Using SmartArt
  • Using Templates
  • Working with Themes
  • Introduction to Beyond Basics
  • Using Hyperlinks
  • Working with Clips, Pictures, & Screenshots
  • Multimedia: Audio & Video
  • Animation
  • Transitions
  • Compare & Merge Presentations
  • Sharing with Other Office 2010 Applications
  • Introduction to Presenting Your Presentations
  • Using Notes
  • Creating Handouts
  • Printing Presentations and Notes/Handouts
  • Automated Self-Running Slide Shows
  • Annotating While Presenting
  • Concluding the Course
  • PowerPoint 2010 Quiz

Learn Microsoft Access 2010 Beginner Course

  • Intro to Backstage View, Ribbon, Quick Access Toolbar & Options
  • READ ME: Essential Information for a Successful Training Experience
  • Start/Exit, Help Features, Shortcuts, Views, Templates
  • Understanding Database Components
  • Introduction to Design of a Database
  • Introduction to Building a Database
  • Creating Tables & Basic Setup of Relationships
  • Using Quick Parts to Setup New Table, Importing Spreadsheet
  • Entering Data Types into Tables
  • Changing Table Attributes, Copy, Rename, Delete Records
  • Table Structures
  • Table and Field Properties
  • Auto-Create Forms, Filtering & Searching
  • Types of Different Forms & Creating New
  • Improve Look, Style, & Feel of Forms
  • Adding Fields to Existing Form
  • Understanding and Setting Up the Expression Builder
  • Format Control on Forms/Reports
  • Sorting Single & Multiple Columns; Filter One Field Data Records
  • Sorting & Filtering Data in Form View; Find & Replace in Forms
  • Understanding Reports & Structure
  • Creating Reports; Using Print Preview to Check Report Outcome
  • Advanced Reporting; Formatting Reports
  • How to Improve Report Design, Add Existing Fields; Group/Sort
  • Select Queries; Sorting; Defined Criteria
  • Change Fields wthin Query; Specifying Criteria for Numbers/Text
  • Update Queries; Append Queries; Delete Queries
  • Inner/Outer Joins; Make Table Queries; Mail Merge
  • Securing Database and Views; New Features
  • Access 2010 Quiz

Learn Microsoft Access 2010 Advanced Training Course

  • Introduction to Advanced Access 2010
  • READ ME: Essential Information for a Successful Training Experience
  • Working with Macros
  • AutoExec Macro
  • Database Options
  • More Database Options
  • Renaming Database Objects
  • Basics & Understanding Data Types
  • Table and Field Properties
  • Validation Rules & Text
  • Understanding & Using Keys and Indexes
  • Data Normalization
  • Types of Relationships
  • Maintaining Relationships
  • Using & Understanding Queries
  • Complex Queries
  • Creating Queries and Using Join & Sub-Queries
  • Datasheet View
  • Creating & Working with Forms
  • Using Forms to Maintain Data
  • Command Buttons
  • Command Buttons Part 2
  • Form Features that Need VBA Code
  • Understanding When & How to Use VBA
  • More about VBA and Using It to Improve Database
  • VBA Language Structure & Making a Switchboard
  • Error Handling
  • Cleaning Up Before Distribution16
  • Security Techniques
  • External Data & Importng/Exporting Data
  • Linking to Excel & Linking to Another Database
  • Separating/Splitting Up Forms, Reports, etc from Database
  • Options for Making Changes When Database is Multi-User
  • Advanced Features for Reports
  • Advanced Features for Reports Part 2
  • Distributing Application
  • Access 2010 Advanced 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 - Infograph

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books