Microsoft Excel : Base to Advance

4 out of 5
4
6 reviews

Microsoft Excel was released in 1985 and has grown to become arguably the most important computer program in workplaces around the world. Whether you are budgeting, organizing client sales lists, or need to plan an office social gathering, Excel is a powerful tool that has become entrenched in business processes worldwide.

A working knowledge of Excel is vital for most office based professionals today, and stronger Excel skills can open the door to promotion and leadership opportunities. Excel is a powerful tool but cannot function alone. It takes a savvy computer user to take advantage of everything Excel has to offer to provide the best results for their company.

Main Features:

  • Master Microsoft Excel from Beginner to Advanced
  • Build a solid understanding on the Basics of Microsoft Excel
  • Learn the most common Excel functions used in the Office
  • Maintain large sets of Excel data in a list or table like a pro
  • Create dynamic reports by mastering one of the most popular tools: PivotTables and Pivot Charts
  • Wow your boss by unlocking dynamic formulas with IF ELSE, VLOOKUP, INDEX, MATCH functions and many more

Importing Data and General Formatting

1
Introduction to Excel
2
Conditional Formatting
3
General formatting Options
4
Data Validation
5
Using basic sort, basic filter option

Conditional formatting and Data Validation

1
Conditional Formatting on the numeric and textual columns
2
Applying conditions and data coloring scheme to the different types of data
3
Data validation for pre-existing data
4
Setting new rules for validation
5
Removing Duplicates from a group of values
6
Getting unique values
7
Advanced filter option
8
Advanced sort option
9
Applying Group Total
10
Subtotal to a group of related data

Functions VLookup and HLookup

1
Formulas and Functions-Concept
2
System defined function
3
Numeric functions- SUM, SUMIF, SUMIFS, COUNT, COUNTIF, COUNTIFS, COUNTBLANK
4
Text functions- LEN, LEFT, RIGHT, UPPER, LOWER
5
VLOOKUP, HLOOKUP, ADVANCED VLOOKUP
6
IF CLAUSE, ADVANCED IF CLAUSE
7
Creating user defined formulas through AND, OR Clause

Formatting table ranges and columns

1
Create and manage tables
2
Create an Excel table from a cell range
3
Convert a table to a cell range
4
Add or remove table rows and columns
5
Manage table styles and options
6
Apply styles to tables
7
Configure table style options
8
Insert total rows
9
Filter and sort a table
10
Filter records
11
Sort data by multiple columns
12
Change sort order
13
Remove duplicate records

Inserting objects

1
Working with Illustrations
2
Working with Clip Art
3
Using Shapes
4
Working with SmartArt
5
Working with Clip Art
6
Adding Shapes
7
Application of the topics learnt

What If Analysis

1
Concept of What if Analysis
2
Concept of Goal Seek
3
Concept of Data table
4
Concept of Scenario Manager
5
Areas where What if analysis is used

Different concepts in Excel

1
Name concept
2
Trace dependants
3
Trace precedents
4
Error Checking concept
5
Remove Arrows
6
Working with Clip Art
7
Adding Shapes

Pivot Table

1
Concept of Pivot Table
2
Why is it important, where it is used?
3
Calculations in pivot table
4
Subtotals in pivot table
5
Dynamic pivot table -adding rows to existing pivot table using OFFSET function

Various charts in excel

1
Concept of chart-various charts in excel
2
Different chart types-line chart
3
Bar chart
4
Grouped bar chart
5
Stacked bar chart
6
Pie chart and applications
7
Line chart
8
Bullet Chart
9
Radar Chart
10
Combination Chart
11
Area Chart
12
Heat Map

Dashboard Creation

1
Concept of dashboard
2
How to apply dashboard
3
Combining multiple pivot charts to form a dashboard
4
Concept of slicer, why it is required, Application of dashboard, dynamic chart
5
Assignments and Case Studies
Faq Content 1
Faq Content 2

Productivity Hacks to Get More Done in 2018

— 28 February 2017

  1. Facebook News Feed Eradicator (free chrome extension) Stay focused by removing your Facebook newsfeed and replacing it with an inspirational quote. Disable the tool anytime you want to see what friends are up to!
  2. Hide My Inbox (free chrome extension for Gmail) Stay focused by hiding your inbox. Click "show your inbox" at a scheduled time and batch processs everything one go.
  3. Habitica (free mobile + web app) Gamify your to do list. Treat your life like a game and earn gold goins for getting stuff done!


4
4 out of 5
6 Ratings

Detailed Rating

Stars 5
3
Stars 4
0
Stars 3
3
Stars 2
0
Stars 1
0

{{ review.user }}

{{ review.time }}
 

Show more
Please, login to leave a review
Add to Wishlist
Enrolled: 34 students
Duration: 40 hours
Lectures: 76
Video: 9 hours
Level: Intermediate

Archive

Working hours

Monday 9:30 am - 7.00 pm
Tuesday 9:30 am - 7.00 pm
Wednesday 9:30 am - 7.00 pm
Thursday Closed
Friday 9:30 am - 7.00 pm
Saturday 9:30 am - 7.00 pm
Sunday 9:30 am - 7.00 pm
WhatsApp chat