Excel : Microsoft Excel 2016 essentials

Excel : Microsoft Excel 2016 essentials

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 3 Hours | 502 MB

A comprehensive Excel Training course for those who want to improve their Microsoft Excel skills & shine at the office!

Microsoft Excel is probably one of the most widely used softwares in the world. And rightly so. Microsoft Excel is so versatile that it can be used in practically any area. From simply counting numbers to calculating astronomical data, to put satellites in the orbit. I’m not kidding. I worked as a structural engineer and we used Microsoft Excel in many calculations including analysis of framed structures.

This Microsoft Excel is a comprehensive course that teaches you all the general aspects of Microsoft Excel and some areas in particular. Here is a list of areas that we will cover in this Microsoft Excel course.

  • Microsoft Excel worksheets, menus, and formulas.
  • The different ribbon options inside Microsoft Excel .
  • The different formatting options inside Microsoft Excel , including conditional formatting and more.
  • Basic and advanced mathematical operations inside Microsoft Excel .
  • Data analysis and Financial Calculations inside Microsoft Excel .
  • Logical Functions and Looking up Data inside Microsoft Excel , using VLOOKUP and conditional statements.
  • Pivot Tables inside Microsoft Excel . Gathering data and freeze panes inside Microsoft Excel .
  • Using Macros inside Microsoft Excel .
  • Data Validation and Linking inside Microsoft Excel
  • Printing a document and exporting documents to different formats inside Microsoft Excel.
Table of Contents

Microsoft Excel 2016 All the Basic Stuff
1 Microsoft Excel 2016 interface Worksheets menus and tabs in Microsoft Excel
2 Microsoft Excel 2016 Introduction to formulas inside Microsoft Excel
3 Microsoft Excel 2016 Ribbon Display Options inside Microsoft Excel
4 Microsoft Excel 2016 Autofill and selecting cells to apply a formula
5 Microsoft Excel 2016 Maximum Minimum Average and Count functions in Excel

Microsoft Excel 2016 Formatting options inside Microsoft Excel
6 Microsoft Excel 2016 Formatting cells and data inside Microsoft Excel
7 Microsoft Excel 2016 Conditional Formatting of cells inside Microsoft Excel
8 Microsoft Excel 2016 Font styles and Sizes in Microsoft Excel
9 Microsoft Excel 2016 Adjusting Column width and Row height inside Excel
10 Microsoft Excel 2016 Aligning and wrapping text inside Microsoft Excel
11 Microsoft Excel 2016 Drawing Borders for Cells inside Microsoft Excel
12 Microsoft Excel 2016 Formatting numbers and Currency inside Microsoft Excel
13 Microsoft Excel 2016 Formatting Date and Time inside Microsoft Excel
14 Microsoft Excel 2016 Conditional Formatting in detail inside Microsoft Excel
15 Microsoft Excel 2016 Creating and working with tables inside Microsoft Excel
16 Microsoft Excel 2016 Using Slicers in a table inside Microsoft Excel

Microsoft Excel 2016 Important basic operations in Microsoft Excel
17 Microsoft Excel 2016 Basic mathematical operations in Microsoft Excel 2016
18 Microsoft Excel 2016 Mixed Referencing inside Microsoft Excel 2016
19 Microsoft Excel 2016 Using Charts inside Microsoft Excel
20 Microsoft Excel 2016 The Flash Fill Feature inside Microsoft Excel 2016
21 Microsoft Excel 2016 Cross sheet and Named References inside Microsoft Excel
22 Microsoft Excel 2016 Calculating Percentages inside Microsoft Excel

Microsoft Excel 2016 Data analysis and financial calculations in Excel 2016
23 Microsoft Excel 2016 Calculating Payment per period PMT inside Microsoft Excel
24 Microsoft Excel 2016 PPMT and IPMT Calculation inside Microsoft Excel
25 Microsoft Excel 2016 Goal seeking inside Microsoft Excel 2016
26 Microsoft Excel 2016 Using the Solver for Data Analysis in Microsoft Excel

Microsoft Excel 2016 Logical Functions look up inside Microsoft Excel 2016
27 Microsoft Excel 2016 Using the IF conditional Statement inside Microsoft Excel
28 Microsoft Excel 2016 Using VLOOKUP for approximate matches in Microsoft Excel
29 Microsoft Excel 2016 Using VLOOKUP for exact matches in Microsoft Excel 2016
30 Microsoft Excel 2016 Countif Sumif and Averageif functions in Microsoft Excel

Microsoft Excel 2016 Pivot Tables inside Microsoft Excel
31 Microsoft Excel 2016 Creating and modifying Pivot Tables in Microsoft Excel
32 Microsoft Excel 2016 Gathering data from external sources in Microsoft Excel
33 Microsoft Excel 2016 Freeze Panes inside Microsoft Excel 2016

Microsoft Excel 2016 Macros inside Microsoft Excel 2016
34 Microsoft Excel 2016 Introduction to Macros inside Microsoft Excel 2016
35 Microsoft Excel 2016 Creating a Macro inside Microsoft Excel 2016
36 Microsoft Excel 2016 More about Macros inside Microsoft Excel 2016
37 Microsoft Excel 2016 Assigning a macro to a button inside Microsoft Excel 2016

Microsoft Excel 2016 Printing inside Microsoft Excel 2016
38 Microsoft Excel 2016 Setting and Adding to Print Area in Microsoft Excel 2016

Microsoft Excel 2016 Security Features inside Microsoft Excel 2016
39 Microsoft Excel 2016 Password Protect a workbook inside Microsoft Excel 2016

Microsoft Excel 2016 Data Validation and Linking Inside Microsoft Excel 2016
40 Microsoft Excel 2016 Data Validation Inside Microsoft Excel 2016
41 Microsoft Excel 2016 Data Linking an Excel Spreadsheet with a Word Document
42 Microsoft Excel 2016 Working with CSV files inside Microsoft Excel 2016
43 Microsoft Excel 2016 Exporting a spreadsheet as PDF inside Microsoft Excel

Microsoft Excel 2016 Conclusion
44 Microsoft Excel 2016 The Conclusion