0
Trainer Name

Start-Tech Academy

Skill Area

Reviews

4.8 (6 Rating)

Course Requirements

You will need a PC with any version of Excel installed in it

Course Description

7 Reasons why you should choose this Excel course
Carefully designed curriculum teaching you only the most used functionalities of Microsoft Excel in business environment
Concise - you can complete this Microsoft Excel course within one weekend
Business related examples, data analysis and case studies solved using Advanced Excel.
You will learn various data analysis techniques using MS Excel
Ample practice exercises on data analysis, MS excel (basic & advanced), because Excel requires practice
Downloadable resources comprising important MS Excel techniques and functionalities
Your queries will be responded by the Instructor himself
Start using Excel to its full potential to become proficient at your Excel tasks today!
Either you're new to Microsoft Excel, or you've played around with Excel since long but want to get more comfortable with MS Excel's advanced features, or maybe you want to enhance your data analysis skills using Microsoft Excel. Either way, this Excel course will be great for you.

Course Outcomes

1.A Beginner's Guide to Microsoft Excel - Microsoft Excel, Learn Excel, Spreadsheets, Formulas, Shortcuts, Macros
2.Knowledge of all the essential Excel formulas
3.Become proficient in Excel data tools like Sorting, Filtering, Data validations and Data importing
4.Master Excel's most popular lookup functions such as Vlookup, Hlookup, Index and Match
5.Harness full potential of Excel by creating Pivot tables with slicers
6.Make great presentations using the Conditional and Table formatting options
7.Visually enchant viewers using Bar charts, Scatter Plots, Histograms etc.
8.Increase your efficiency by learning how to create and use important Excel shortcuts
9.Explore fun and exciting use cases of Excel

Course Curriculum

1 Introduction


1 Textual Formulas


2 Basic Formula Operations


3 Mathematical Formulas


4 Logical Formulas


5 Date Time Formulas


6 Lookup Formulas ( V Lookup, Hlookup, Index-Match )


1 Basics


2 Worksheet Basics


3 Entering values and Formulas


4 Data Formats


5 Data Handling Basics Cut, Copy and Paste


6 Saving and Printing Basics


1 Data Tools


1 Formatting data and tables


1 Pivot Tables


1 Frequency Distribution and Histograms


2 The Easy way of creating charts


3 Bar and column charts


4 Formating charts


5 Line Charts


6 Area Charts


7 Pie and Doughnut Charts


8 Why we should avoid Pie charts


9 Scatter plot or XY chart


10 Elements of charts


11 Excel Charts Categories of messages that can be conveyed


1 Pivot Charts


1 Named Ranges


2 Indirect Function


1 Shortcuts


1 Macros


1 Advance Excel


2 Waterfall Charts


Trainer

Trainer Name

Start-Tech Academy

4.8 Rating
6 Reviews

More Courses by Author

Learner Feedback

Zero Microsoft Excel Complete 2020

5

Course Rating
100.00%
0.00%
0.00%
0.00%
0.00%

Log In or Sign Up as learner to post a review

Shopping Cart

Loading...