Ultimate Microsoft Office BootCamp

Name: Ultimate Microsoft Office BootCamp
Rating: 3.8 (26 reviews)

Learn all the productivity tools for Microsoft Office(Excel/Access/PowerPoint/Outlook) in one place at one time.

Created byGaurav Chauhan

Last updated 4/2019

English

What you'll 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

Course content

13 sections • 300 lectures • 18h 32m total length

Open a presentation in PowerPoint 20134:18
New Presentation in Powerpoint 20131:34
Save A presentation4:19
*** Update on Udemy Review ***0:45
Create New Slides3:32
Slide Shows8:17
Edit Text in a presentation3:57
Print a presentation3:52
View Tab3:44
Insert Comments2:41

Open a file in Excel2:38
Free Excel Shortcut,Practice and Ebook
Open a Workbook1:51
Enter Text and Numbers3:07
Create New Workbook0:55
Save and Save As4:57
Saves as File Extension4:57
Save and Saves as Buttons6:51
save and Saves As buttons with Attributes3:53
File Extensions5:33
Data in Excel4:58
Cut Copy and Paste2:07
Print Workbooks6:17
Sheet Tab Options4:19
Insert, Rename & Delete Sheets2:47
Move and Copy Worksheets4:19
Find & Replace Functionality5:16
Workbook Protection3:23
Paste Special Options Part 16:41
Paste Special Options Part 23:41
Conditional Formatting Part 18:29
Conditional Formatting Part 23:24
Tab Colour and Hide2:59
Put in Comments in Excel1:35
Cell Formatting2:53
Format Text in Excel5:29
Format Numbers in Excel4:32
Format Numbers as Currency2:28
Putting Borders to Cells Part 15:11
Putting Borders to Cells Part 26:09
Adjusting Row Height and Column Width4:12
Left Right and Middle Formatting7:03
Insert Rows,Columns & Cells3:43
Format Painter Part 13:17
Format Painter Part 22:32
Fill Styles in Excel4:50
Format Table2:33
Format Table Custom Style4:25
Format Cells with a Cell Style3:21
Format Cells with Custom Format3:27
Operations Order4:52
Cell Protection3:32
Split Screens1:36
Freezing Panes3:55
Hide and Unhide Rows in Excel2:51
Substitute and Replace4:03
Find and Replace5:00

Create Basic Formulas3:56
Basic Formula Using Values Itself2:31
Basic Formula Using Cell References3:30
Order of Operations in Formulae3:41
Average Function2:42
If Function4:35
If and OR function4:04
Max Function1:10
Min Function1:19
Day Month Year Function1:57
Date & Edate Function3:35
Network Days Function3:25
Power Function2:36
Today And Now Functions2:53
Sum Function3:08
SumIf Function4:25
Sum Product Function4:01
Count Function2:14
CountA Function2:58
CountIf Function3:02
Concatenate Function2:33
Absolute and Relative References Part 14:43
Absolute and Relative References Part 23:33
Case Functions3:16
Copy Paste Formula3:42
Fill Formulas3:25

Charts in Exel1:58
Charts Fundamental4:14
Column Chart in Excel3:02
Stacked Column Chart2:00
Percentage Stacked Column Chart2:38
3D Column Charts2:01
Cylinderical ,Conical and Pyramid Charts2:36
Line Charts2:53
stacked line charts2:07
Line Charts with Markers and 3D Charts3:14
Pie Charts in Excel1:50
Exploded Pie Charts1:17
Pie on Pie Chart1:40
3D Pie Chart2:07
Doughnut Charts1:41
Area Charts2:33
Stacked Area Charts3:18
Stacked Area Charts in Excel2:10
3D Area Charts in Excel3:13
Simple Bar Chart4:10
Stacked Bar Chart3:42
Percent Stacked Bar Chart3:01
3D Bar Charts2:51
3D Conical Pyramidial Cylinderical Bar Chart4:03
Scatter Charts3:40
Scattered Curved Line Charts2:39
Scattered Line Charts with or without Dots2:25
Chart Option-Change Chart Type Option3:20
Chart Options-Switch Row Column Option1:46
Chart Options - Select Data2:20
Chart Options-Chart Layout Part 15:31
Chart Options - Chart Layout Part 24:17
Chart Options - Chart Styles3:02
Chart Options - Moving Charts1:59
Chart Options - Chart Templates4:12
Chart Options-Rolloing Back Changes in Charts1:46
Chart Options - Drop Box Explained2:49
Chart Options - Drop Box4:48
Chart Options -Format Selection Fill Option6:01
Chart Options-Format Selection Border3:31
Chart Options-Format Selection Border Style3:08
Chart Options-Format Selection Shadow4:22
Chart Options-Format Selection Glow4:01
Chart Options -Selection 3D Format4:30
Chart Options-Format Selection Size2:07
Chart Options -Format Selection Properties4:35
Chart Options -Insert Menu3:59
Chart Options- Chart Title 13:41
Chart Options - Chart Title 26:31
Chart Options Axis Titles 13:55
Chart Options Axis Titles 23:46
Chart Options -Legend Options3:36
Chart Options -Data Labels6:00
Chart Options - Data Table3:51
Chart Options -Axes Options2:53
Chart Options-Horizontal Axes Options4:51
Chart Options -Vertical Axes Options8:29

Autofill Options4:48
Trace Precedents and Dependents4:27
Error Checking3:51
Calculations Options4:36
Show and Evaluate Formula3:47
Text to Columns Delimiter3:24
Creating Name Range5:41
Using Names in Formulas2:18
Name Manager4:43
Pivot Tables6:41
IsBlank,Istext,IsNumber Function3:59
Text to Columns Fixed Width3:39
Vlookup Part 16:26
Vlookup Part 23:24
Hlookup Part 14:41
Hlookup Part 22:07
Index Match Function5:04
Removing Duplicates Part 13:01
Removing Duplicates Part 22:12
Filtering in Excel Part 11:45
Filtering in Excel Part 22:10
Filtering in Excel Part 33:07
Sort Data with Filters2:34
Sort Data with Filters Part 22:33
How to record Macros6:01
Color Sort1:17
Microsoft One Drive4:53

What is MS Access 2013?2:06
What is a Database?2:50
What is a Database Management System?2:24
What are Tables in Databases?2:52
What is Data?2:52
How is Data Stored?3:26
Data and Formats4:38
Create a Blank Database1:52
Open an Existing Database2:24
Difference Between Excel and Access Tables2:42
Overview of MS Access 20134:00
Introduction to Data Types4:09
Numeric and Text Data Types6:02
Creating New Variables3:31
Adding Date and Caption & Defaults4:32
Using Functions in Expression Builder3:50
Converting Between Data Types Part 13:21
Converting Between Data Types Part 21:51
Fields Validation3:41
Sort Ascending and Descending2:44
Delete a table2:06
Design View of Table4:25
Exporting Data6:04
Forms Part 12:52
Forms Part 28:05
Import Excel Data from Access Part 15:52
Import Excel Data into Access Part 24:10
Insert Into Statement4:53
Primary Keys5:58
Update Table Statement5:15
Overview of SQL in MS Access3:17
SQL_Its Classification1:58
Basic SQL Syntax0:54

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 this course is for:

Course is intended for anyone who intends to learn MS Office 2013 and become an expert in MS office 2013!!

Ultimate Microsoft Office BootCamp

What you'll learn

Explore related topics

Course content

Microsoft Powerpoint Basics -201310 lectures • 37min

Microsoft PowerPoint - 2013 Advanced14 lectures • 50min

Microsoft Outlook 201313 lectures • 53min

Microsoft Outlook Advanced 201412 lectures • 54min

Microsoft Excel Basics46 lectures • 3hr 7min

Microsoft Excel - Functions26 lectures • 1hr 23min

Microsoft Excel - Charts57 lectures • 3hr 13min

Microsoft Excel -Advanced Functions27 lectures • 1hr 43min

Microsoft Access 2013 /SQL 2013 - Overview33 lectures • 2hr 2min

MS ACCESS 2013 -SELECT4 lectures • 18min

Requirements

Description

Who this course is for: