Ultimate Microsoft Office BootCamp
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
59 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Ultimate Microsoft Office BootCamp to your Wishlist.

Add to Wishlist

Ultimate Microsoft Office BootCamp

Learn all the productivity tools for Microsoft Office(Excel/Access/PowerPoint/Outlook) in one place at one time.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
59 students enrolled
Created by Gaurav Chauhan
Last updated 8/2014
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 18.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • In this course, you will be able to learn Microsoft Powerpoint 2013,Outlook 2013, Excel 2010 & Excel 2013, Access 2013, SQL
  • You will get participation certificate which can be used for your career enhancements
View Curriculum
Requirements
  • You should have Microsoft Office 2013 installed on your system.If you do not have one you can always download the preview from Microsoft Website by following link http://office.microsoft.com/en-in/buy-microsoft-office-professional-2013-FX102918381.aspx
Description

Learn Microsoft Office 2016 - Powerpoint,Outlook,Excel, Access & SQL all at one place.

This course puts an end to going to different places to learn all the topics of Microsoft Office 2013, we present all the software of Microsoft Office 2013 in one place.

We use video tutorials - clear and concise, rather than boring long videos.

Course has 299 video sessions complete of all topics, which you can complete in 25+ hours.

You should take this course for following reasons:

a. Experience brought in our faculty- We have 3000+ hours of experience in teaching these topics

b. Save Money - You can save atleast $250 on Udemy itself, by taking only one complete course rather than taking each topic separately

c. Certification provided after completion of the course by Inditest Technologies

d. E-Books & Practice files to be on provided on request with no additional charge

Who is the target audience?
  • Course is intended for anyone who intends to learn MS Office 2013 and become an expert in MS office 2013!!
Students Who Viewed This Course Also Viewed
Curriculum For This Course
299 Lectures
18:31:54
+
Microsoft Powerpoint Basics -2013
9 Lectures 36:14



Create New Slides
03:32

Slide Shows
08:17

Edit Text in a presentation
03:57

Print a presentation
03:52

View Tab
03:44

Insert Comments
02:41
+
Microsoft PowerPoint - 2013 Advanced
14 Lectures 50:02
Advanced Slide Show
03:34

Slide Numbers and Times
04:01

Password Protect Presentation
02:12

Animations
04:43

Export as PDF
05:02

Insert Audio & Video
03:44

Insert Charts Part 1
03:23

Insert Charts Part 2
03:01

Insert Pictures
04:41

Insert Watermarks
02:27

Slide Transition Part 1
04:33

Slide Transition Part 2
03:16

Themes
02:23

Themes Variation
03:02
+
Microsoft Outlook 2013
13 Lectures 52:52
Overview of Outlook 2013
02:51

Email Overview
05:58

Create a Contact
05:43

Create new email
04:50

Format Text in an Email
06:52

Reply to an Email
03:10

Delete an Email
02:33

Creating new Appointment
04:48

Creating a new meeting request
03:34

Creating a new Task
03:19

Add an attachment
02:33

Print Emails
02:57

Spelling and Grammer Check
03:44
+
Microsoft Outlook Advanced 2014
12 Lectures 54:25
Exploring Calendar
02:54

Create Signature
04:22

Create Voting Ballet
03:19

Filtering and Sorting Emails
05:19

Giving Importance to Emails
01:41

Miscellaneous Options
05:01

Delivery and Read Receipts
04:45

Folders Part 1
03:32

Folders Part 2
04:17

Creating Hyperlinks
05:35

Rules Part 1
07:05

Rules Part 2
06:35
+
Microsoft Excel Basics
46 Lectures 03:06:51

Free Excel Shortcut,Practice and Ebook

Open a file in Excel
02:38

Open a Workbook
01:51

Enter Text and Numbers
03:07

Create New Workbook
00:55

Save and Save As
04:57

Saves as File Extension
04:57

Save and Saves as Buttons
06:51

save and Saves As buttons with Attributes
03:53

File Extensions
05:33

Data in Excel
04:58

Cut Copy and Paste
02:07

Print Workbooks
06:17

Sheet Tab Options
04:19

Insert, Rename & Delete Sheets
02:47

Move and Copy Worksheets
04:19

Find & Replace Functionality
05:16

Workbook Protection
03:23

Paste Special Options Part 1
06:41

Paste Special Options Part 2
03:41

Conditional Formatting Part 1
08:29

Conditional Formatting Part 2
03:24

Tab Colour and Hide
02:59

Put in Comments in Excel
01:35

Cell Formatting
02:53

Format Text in Excel
05:29

Format Numbers in Excel
04:32

Format Numbers as Currency
02:28

Putting Borders to Cells Part 1
05:11

Putting Borders to Cells Part 2
06:09

Adjusting Row Height and Column Width
04:12

Left Right and Middle Formatting
07:03

Insert Rows,Columns & Cells
03:43

Format Painter Part 1
03:17

Format Painter Part 2
02:32

Fill Styles in Excel
04:50

Format Table
02:33

Format Table Custom Style
04:25

Format Cells with a Cell Style
03:21

Format Cells with Custom Format
03:27

Operations Order
04:52

Cell Protection
03:32

Split Screens
01:36

Freezing Panes
03:55

Hide and Unhide Rows in Excel
02:51

Substitute and Replace
04:03

Find and Replace
05:00
+
Microsoft Excel - Functions
26 Lectures 01:22:54
Create Basic Formulas
03:56

Basic Formula Using Values Itself
02:31

Basic Formula Using Cell References
03:30

Order of Operations in Formulae
03:41

Average Function
02:42

If Function
04:35

If and OR function
04:04

Max Function
01:10

Min Function
01:19

Day Month Year Function
01:57

Date & Edate Function
03:35

Network Days Function
03:25

Power Function
02:36

Today And Now Functions
02:53

Sum Function
03:08

SumIf Function
04:25

Sum Product Function
04:01

Count Function
02:14

CountA Function
02:58

CountIf Function
03:02

Concatenate Function
02:33

Absolute and Relative References Part 1
04:43

Absolute and Relative References Part 2
03:33

Case Functions
03:16

Copy Paste Formula
03:42

Fill Formulas
03:25
+
Microsoft Excel - Charts
57 Lectures 03:12:40
Charts in Exel
01:58

Charts Fundamental
04:14

Column Chart in Excel
03:02

Stacked Column Chart
02:00

Percentage Stacked Column Chart
02:38

3D Column Charts
02:01

Cylinderical ,Conical and Pyramid Charts
02:36

Line Charts
02:53

stacked line charts
02:07

Line Charts with Markers and 3D Charts
03:14

Pie Charts in Excel
01:50

Exploded Pie Charts
01:17

Pie on Pie Chart
01:40

3D Pie Chart
02:07

Doughnut Charts
01:41

Area Charts
02:33

Stacked Area Charts
03:18

Stacked Area Charts in Excel
02:10

3D Area Charts in Excel
03:13

Simple Bar Chart
04:10

Stacked Bar Chart
03:42

Percent Stacked Bar Chart
03:01

3D Bar Charts
02:51

3D Conical Pyramidial Cylinderical Bar Chart
04:03

Scatter Charts
03:40

Scattered Curved Line Charts
02:39

Scattered Line Charts with or without Dots
02:25

Chart Option-Change Chart Type Option
03:20

Chart Options-Switch Row Column Option
01:46

Chart Options - Select Data
02:20

Chart Options-Chart Layout Part 1
05:31

Chart Options - Chart Layout Part 2
04:17

Chart Options - Chart Styles
03:02

Chart Options - Moving Charts
01:59

Chart Options - Chart Templates
04:12

Chart Options-Rolloing Back Changes in Charts
01:46

Chart Options - Drop Box Explained
02:49

Chart Options - Drop Box
04:48

Chart Options -Format Selection Fill Option
06:01

Chart Options-Format Selection Border
03:31

Chart Options-Format Selection Border Style
03:08

Chart Options-Format Selection Shadow
04:22

Chart Options-Format Selection Glow
04:01

Chart Options -Selection 3D Format
04:30

Chart Options-Format Selection Size
02:07

Chart Options -Format Selection Properties
04:35

Chart Options -Insert Menu
03:59

Chart Options- Chart Title 1
03:41

Chart Options - Chart Title 2
06:31

Chart Options Axis Titles 1
03:55

Chart Options Axis Titles 2
03:46

Chart Options -Legend Options
03:36

Chart Options -Data Labels
06:00

Chart Options - Data Table
03:51

Chart Options -Axes Options
02:53

Chart Options-Horizontal Axes Options
04:51

Chart Options -Vertical Axes Options
08:29
+
Microsoft Excel -Advanced Functions
27 Lectures 01:43:09
Autofill Options
04:48

Trace Precedents and Dependents
04:27

Error Checking
03:51

Calculations Options
04:36

Show and Evaluate Formula
03:47

Text to Columns Delimiter
03:24

Creating Name Range
05:41

Using Names in Formulas
02:18

Name Manager
04:43

Pivot Tables
06:41

IsBlank,Istext,IsNumber Function
03:59

Text to Columns Fixed Width
03:39

Vlookup Part 1
06:26

Vlookup Part 2
03:24

Hlookup Part 1
04:41

Hlookup Part 2
02:07

Index Match Function
05:04

Removing Duplicates Part 1
03:01

Removing Duplicates Part 2
02:12

Filtering in Excel Part 1
01:45

Filtering in Excel Part 2
02:10

Filtering in Excel Part 3
03:07

Sort Data with Filters
02:34

Sort Data with Filters Part 2
02:33

How to record Macros
06:01

Color Sort
01:17

Microsoft One Drive
04:53
+
Microsoft Access 2013 /SQL 2013 - Overview
33 Lectures 02:01:36
What is MS Access 2013?
02:06

What is a Database?
02:50

What is a Database Management System?
02:24

What are Tables in Databases?
02:52

What is Data?
02:52

How is Data Stored?
03:26

Data and Formats
04:38

Create a Blank Database
01:52

Open an Existing Database
02:24

Difference Between Excel and Access Tables
02:42

Overview of MS Access 2013
04:00

Introduction to Data Types
04:09

Numeric and Text Data Types
06:02

Creating New Variables
03:31

Adding Date and Caption & Defaults
04:32

Using Functions in Expression Builder
03:50

Converting Between Data Types Part 1
03:21

Converting Between Data Types Part 2
01:51

Fields Validation
03:41

Sort Ascending and Descending
02:44

Delete a table
02:06

Design View of Table
04:25

Exporting Data
06:04

Forms Part 1
02:52

Forms Part 2
08:05

Import Excel Data from Access Part 1
05:52

Import Excel Data into Access Part 2
04:10

Insert Into Statement
04:53

Primary Keys
05:58

Update Table Statement
05:15

Overview of SQL in MS Access
03:17

SQL_Its Classification
01:58

Basic SQL Syntax
00:54
+
MS ACCESS 2013 -SELECT
4 Lectures 17:34
Select Variables From
06:45

Select Variables Position in Results
02:42

Select All Variables from Table
02:27

Select Clause Create New Variables
05:40
3 More Sections
About the Instructor
Gaurav Chauhan
4.5 Average rating
3 Reviews
1,392 Students
3 Courses
Instructor

I am Lead IT professional for one of largest IT companies in the world. I have been trained and certified in various IT stream and analytics. I am ex- American Express, ex-Airtel. I have been working in IT domain for last 15 years and I have been a system administrator, Six Sigma expert & experienced project manager who has handled global projects on massive scale. 

I have software patents in my name and have been involved with IT industry for a long time.


Going forward, my courses would be based on cloud and analytics domain with new skills. I will start from basics and by the end of each courses you can become a proficient expert in that particular. Please add me on Linkedin or Follow me on Twitter.