MS Excel 2016

Description

Microsoft Excel is a spreadsheet which features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms. 

What will you learn
  • You will learn interface, creating and opening workbooks, entering text and numbers.

  • You will gain the knowledge of working with formulae and how to efficiently add functions and formulae.

  • You will learn basic formatting, inserting charts and graphics.

  • You can share and print workbooks.


Requirements
  • No previous knowledge is required

Lessons

  • 17 Lessons
  • 07:25:56 Hours
  • Introduction, Getting Started , Manage Working Windows. 00:21:10
  • Clipboard, Text Properties00:51:57
  • Text Alignment, Cell Format, Cell Field. 00:30:16
  • Conditional Format, Table Format, Cell Styles. 00:30:40
  • Insert Row & Column, Delete Row & Column, Format cell. 00:19:12
  • Auto Sum, Fill, Find and Replace, Sorting Order. 00:22:14
  • Pivot Tables, Table Style, Table Format, Insert Table. 00:33:21
  • Insert Picture, Picture Format, Picture Effect.00:24:40
  • Insert Shapes, Shape Design, Shape Format. 00:21:05
  • Insert Smart Art, Smart Art Analysis , Smart Art Layout. 00:21:26
  • Insert Chart, Recommended Chart, Pivot Chart, Chart Styles, Chart Format. 00:31:35
  • Hyperlink, Header and Footer, Symbols, Equation. 00:31:27
  • Basic Calculation, Fill Method. 00:32:51
  • Dollar Symbol, If Function, Multi set Formula, Date Formulas, Text Formulas. 00:34:28
  • Record and Insert Macro, Visual Basic , Command Button. 00:25:04
  • Export, Print, Security. 00:14:30
  • Ms Excel : Assessment

About instructor

Instructor
Name : Mr. Manikandan M
Reviews : 842 Reviews
Student : 1390 Students
Courses : 15 Courses

Reviews

5
Based on 783 Reviews

Safiya Banu - Mon, 04-Apr-2022

Assessment has some error pls check that

Adaikkalam A - Thu, 22-Jun-2023