Excel 2016

- 1. Course Detail
- 2. Course Curriculum
- 3. Certificate
₹ 999.00

M.R.P: 3999.00

Save: 3000.00 (75%)

Inclusive of all taxes

Take this course

course enquiry

Course Details
Course Curriculum
Sample Certificate
Review

Course Curriculums

You will learn about starting with excel, Excel Ribbons, quick access toolbar, different tabs in excel, how to use data functions, work with texts, pivot tables, important excel tools and new charts option in Advanced Excel 2016.

Section 1: Basic Excel 2016

1	Overview
2	Opening an Excel Worksheet
3	Ribbons and Quick Access Toolbar
4	Ribbons and Quick Access Toolbar continued
5	Case Study
6	Data entry in excel
7	Data entry in excel continued
8	Populating the Case Study in Excel
9	Calculations
10	Formulas- SUM MAX MIN AVERAGE
11	Formulas continued
12	Formatting- Number Formats
13	Formatting Table formats
14	Updating a Calculation
15	Percentage and Absolute references
16	Conditional Formatting
17	IF Function
18	COUNTIF and SUMIF Function
19	Graphs and Charts
20	Graphs & Charts part 2
21	Graphs & Charts part 3
22	Pie Chart
23	Sort Function
24	Filter Function
25	Pivot table
26	Pivot table part 2
27	Freeze & Split
28	Table Formats
29	Indents and Formatting Charts
30	Printing the Worksheet and Print Layout
31	Shortcuts in excel
32	Shortcuts- Navigation
33	Shortcuts- Workbook Basics
34	Shortcuts- Selection
35	Shortcuts- Working with Data
36	Shortcuts- Formula
37	Common errors

Section 2 Advance Excel 2016

38	Paste Special
39	Logical functions – IF AND OR
40	Arithmetic functions MAX MIN ABS etc
41	COUNT COUNTIF COUNTA COUNTBLANK
42	Cell Information ISERROR ISBLANK etc
43	CHOOSE Function
44	VLOOKUP Function
45	HLOOKUP Function
46	MATCH and INDEX
47	Database functions DSUM DAVERAGE DCOUNT
48	OFFSET- Example 1
49	OFFSET Function- Dynamic
50	One Dimensional Data Tables
51	Two dimensional Data Tables
52	Solver
53	Goal Seek
54	Array Function Example 1
55	Array Function Example 2
56	Array functions rows and columns
57	TRANSPOSE
58	Frequency
59	PROPER UPPER LOWER LEFT RIGHT MID
60	FIND CLEAN REPT CONCATENATE
61	Pivot Table Slicer
62	Pivot Charts
63	Naming a Cell and a Range
64	Naming Dynamic Ranges
65	Naming a Cell and a Range
66	Naming Dynamic Ranges
67	Group boxes and option buttons
68	Check boxes
69	List and combo boxes
70	Scroll chart
71	Text to Columns
72	Grouping Tabs
73	Subtotal Function
74	Hyperlinks
75	Data Validation
76	Random Numbers
77	Custom View
78	Protecting the worksheet
79	Protecting the workbook
80	Excel Sparklines
81	Waterfall chart
82	Box and Whisker chart
83	Treemap chart
84	Sunburst chart

Ask a question and start a new topic!

The Author will answer this query shortly.

Questions

- Jonna
- 02 Dec
In how many weeks the course will completed
- 0 Comment
Answer

Section 1: Basic Excel 2016

1	Overview
2	Opening an Excel Worksheet
3	Ribbons and Quick Access Toolbar
4	Ribbons and Quick Access Toolbar continued
5	Case Study
6	Data entry in excel
7	Data entry in excel continued
8	Populating the Case Study in Excel
9	Calculations
10	Formulas- SUM MAX MIN AVERAGE
11	Formulas continued
12	Formatting- Number Formats
13	Formatting Table formats
14	Updating a Calculation
15	Percentage and Absolute references
16	Conditional Formatting
17	IF Function
18	COUNTIF and SUMIF Function
19	Graphs and Charts
20	Graphs & Charts part 2
21	Graphs & Charts part 3
22	Pie Chart
23	Sort Function
24	Filter Function
25	Pivot table
26	Pivot table part 2
27	Freeze & Split
28	Table Formats
29	Indents and Formatting Charts
30	Printing the Worksheet and Print Layout
31	Shortcuts in excel
32	Shortcuts- Navigation
33	Shortcuts- Workbook Basics
34	Shortcuts- Selection
35	Shortcuts- Working with Data
36	Shortcuts- Formula
37	Common errors

Section 2 Advance Excel 2016

38	Paste Special
39	Logical functions – IF AND OR
40	Arithmetic functions MAX MIN ABS etc
41	COUNT COUNTIF COUNTA COUNTBLANK
42	Cell Information ISERROR ISBLANK etc
43	CHOOSE Function
44	VLOOKUP Function
45	HLOOKUP Function
46	MATCH and INDEX
47	Database functions DSUM DAVERAGE DCOUNT
48	OFFSET- Example 1
49	OFFSET Function- Dynamic
50	One Dimensional Data Tables
51	Two dimensional Data Tables
52	Solver
53	Goal Seek
54	Array Function Example 1
55	Array Function Example 2
56	Array functions rows and columns
57	TRANSPOSE
58	Frequency
59	PROPER UPPER LOWER LEFT RIGHT MID
60	FIND CLEAN REPT CONCATENATE
61	Pivot Table Slicer
62	Pivot Charts
63	Naming a Cell and a Range
64	Naming Dynamic Ranges
65	Naming a Cell and a Range
66	Naming Dynamic Ranges
67	Group boxes and option buttons
68	Check boxes
69	List and combo boxes
70	Scroll chart
71	Text to Columns
72	Grouping Tabs
73	Subtotal Function
74	Hyperlinks
75	Data Validation
76	Random Numbers
77	Custom View
78	Protecting the worksheet
79	Protecting the workbook
80	Excel Sparklines
81	Waterfall chart
82	Box and Whisker chart
83	Treemap chart
84	Sunburst chart

1. Course Detail

2. Course Curriculum

3. Certificate

Ask a question and start a new topic!

Recommended Courses