Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Learning Microsoft Excel 2016

Video Introducing this tutorial

Start Here
Get Started With Excel 2016 08m 14s
New: Tell Me Feature 05m 04s
Excel Workbook And Worksheets 05m 57s
Customizing Color Schemes And Quick Toolbar 05m 05s
Using The Included Working Files 02m 18s
About The Author 01m 28s
How To Access Your Working Files 01m 15s


Managing Workbooks And Worksheets
Creating And Saving New Workbooks 05m 46s
Opening Workbooks And Save As Options 05m 37s
Saving And Opening Onedrive Files 04m 32s
Navigating An Excel Workbook 05m 55s
Adding Removing And Renaming Worksheets 07m 25s
Using The 2016 Templates 05m 30s


Entering And Editing Data In Cells
Entering And Editing Text Numbers And Dates 08m 46s
Cut Copy Paste Vs Drag And Drop 07m 38s
Special Features Of The Fill Handle 09m 30s
Managing Columns And Rows 09m 46s
Searching Within A Worksheet Workbook 07m 21s


Math: The Basics
Normal Mathematic Operators 10m 06s
Starting With Basic Functions 09m 05s
Copying Formula 06m 54s
Displaying Formula And Functions 04m 57s


Formatting
Cell And Range Selection 06m 59s
Modifying Typeface Size Colors 07m 52s
Number Formats Alignment And Orientation 08m 28s
Merging And Wrapping Cell Contents 05m 47s
Cell Borders 06m 23s
Applying Editing Date Formats 06m 14s
The Format Painter 06m 39s
Clearing Finding And Replacing Formatting 03m 59s


Workbook And Worksheet Management
Worksheet Navigating Copying Moving And Tab Color 07m 31s
Side By Side Comparison Of Worksheets 03m 48s
Modifying More Than One Sheet At A Time 07m 31s


Page Setup And Printing
Controlling Print And Screen Headings 04m 47s
Orientation Margins And Scaling 06m 02s
Headers And Footers 06m 43s
Using Page Break And Page Layout Views Effectively 06m 27s
Printing Parts Of A Worksheet 04m 37s
Spellchecking And Smart Lookup 05m 25s


Mathematical Formulas
The Sum Function 06m 15s
Other Mathematical Functions Average Min Max 06m 25s
Various Count Functions 03m 49s
Absolute Referencing 06m 16s
Formula Across Multiple Sheets 08m 51s
3D Referencing In Action 09m 34s
The Advantages Of Named Cells And Ranges 07m 32s


Security
Protection Of Whole Or Part Worksheets 07m 14s
Protection For The Whole Excel Workbook 05m 54s


Charts In Excel
Using The Recommended Charts Option 06m 41s
Create A Chart Quickly Or Slowly 05m 57s
Formatting A Chart 05m 48s
Modifying The Chart Type 05m 11s
Formatting Chart Elements 07m 13s
Adding A Trendline 06m 36s
The Pie Chart 07m 40s
Sparklines Mini Charts 06m 24s
The New Forecast Sheet 04m 52s
New To 2016 Chart Types 09m 11s


Graphics Objects
Inserting And Enhancing Images 05m 50s
Inserting Shapes And Screenshots 08m 18s
Using SmartArt Graphics 08m 54s
Formatting Graphical Objects 05m 26s
Stacking Grouping And Flowcharts 08m 15s
A Mathematical Formula With A Graphic Object 03m 33s


Excel As A Database
Fixing Onscreen And In Print Rows And Columns 05m 36s
Sorting Data 06m 59s
Filter Data To Reduce Dataset Size 07m 49s
Removing Duplicate Entries 03m 08s
Using Subtotals In A Worksheet Of Data 07m 06s
Using Text To Columns 06m 02s
The New Get And Transform For Using Web Data 05m 35s


Advanced Formula
Using An IF Formula 06m 55s
New IFs For Multiple Criteria 05m 30s
DATEDIF A Useful Hidden Function 07m 25s
Text Manipulation Functions 08m 35s
Use Of Text To Format Numbers 04m 59s
Date Manipulation Functions 05m 44s
Introducing SUMIF COUNTIF AVERAGEIF 08m 50s
Use Of Rank To Calculate Placings 08m 06s
Flash Fill The Magic Touch 05m 26s


What's Next
Office Apps For Excel 2016 05m 40s
Are You Ready To Go Advanced 03m 02s

You Have Got Gift 25% OFF

Use this Coupon Code “J3JKN396