Syste
m (Hardware/Software)
Requirements
Operating
Software | Windows XP or
Higher
| Processor | Minim
um P4 or Higher
| RAM | 1 GB or
Higher
| Browser | Any
| Recommended Internet
Speed | Minimum 1MBPS
| Supported Browser
Plug-ins | * Updated
Flash Player, * Update Java
| Other
Requirements | Speaker or
headphone | |
Prdocut DescriptionThis course starts from scratch. So, even if you are a starter in Excel 2013, you will get it in this course. By the completion of this Comprehensive Microsoft Excel 2013 training, you will be comfortable with most of the powerful features and functions of Excel 2013. Working files are included, allowing you to follow along with the author throughout the lessons.
This course begins with taking care of all excel functions and formulas in a comprehensive manner with lots of examples and case studies. To make you understand the importance of Excel in our day to day life, the course starts with a case study and how that case study is being taken completely on an excel spread sheet. You will learn everything from data entry to calculations to formula, formatting, if, sumif, graphs and charts, sorts, pivot table, freeze and split etc. We will also give you lots of shortcuts in excel to make your life easier. Then, the course will take you through some of the most useful functions of Excel 2013, gradually takes you through prominent features like What if Analysis, Arrays, Functions for Working with Text, Pivot Table. Important functions like Pivot Table has been taken comprehensively for better understanding. We will also be covering other smart features like Charts and Graphs, Dashboard and Financial Functions in this course.
This course is ideal for Students, MBA's, BBA's, Gradates & Post- graduates, Working Professionals from HR, Marketing, Sales and Operation etc., Entrepreneurs, Prospective Finance Analyst, Market Analyst, Research Analyst, Investment Banker. There is no Pre-requisite to this course. A complete beginner can start with this course. Our objective with this course is to make you understand what excel is and to know its importance in the current business world. The only requirement from you is to be passionate to learn, be committed to the training and invest your time.
We will be covering the following modules in this online course on Comprehensive Microsoft Excel 2013.
OverviewGetting StartedCase StudyData EntryCalculationsFormulasFormattingFormatting Table formatsUpdating a CalculationPercentages & Absolute ReferencesConditional FormattingIF FunctionCOUNTIFSUMIFGraphs & ChartsPie ChartSortsFilter FunctionPivot tableFreeze & SplitPresentationPrintShortcutsCommon errorsWhat If AnalysisArraysFunctions for Working with TextExcel 2013 - Pivot TableSummarizing Data Using Pivot TableData FilteringBasics Pivot Table FormattingAdvanced Pivot Table FormattingIntroduction of Pivot ChartHow to Print the Pivot TableUsing Macros In Pivot TablesIntroduction of Power PivotDAX in Power PivotIntroduction of Power ViewNames and Dynamic RangeAuditing and Trouble Shooting FormulasImportant Excel ToolsExcel 2013 - Charts & GraphsChart ConceptBasic ChartFine Tuning of ChartsChart OptionsFormat TabAdjustment of Specific Chart TypesChanging Chart SourcesSpecialised Charts & GraphsExcel 2013 - Excel DashboardCreating Basic ChartsLearning Pivot Table, Pivot Chart and SlicerUsing Form ControlsBasic MacrosAssigning Macros to Buttons to Navigate and DashboardFinancial functions using ExcelFuture Value, SI, CI, PV, NPER, RATECourse Curriculum
Section1:Introduction to Excel Dashbord
Lecture1:Introduction to Dashboard
Lecture2:Concepts of Excel Dashboard
Section2:Excel Functions
Lecture3:Vlookup
Lecture4:Hlookup and Sum product
Lecture5:Hlookup and Sum product Continues
Lecture6:Choose Function
Lecture7:Lookups Without Solution (DOWNLOAD)
Lecture8:Lookups With Solution (DOWNLOAD)
Section3:Creating Basic Charts
Lecture9:3D Charts
Lecture10:Area and Bar Chart
Lecture11:Combination Charts
Lecture12:Different Typs
Lecture13:Types of Charts Without Solution (DOWNLOAD)
Lecture14:Types of Charts With Solution (DOWNLOAD)
Section4:Learning Pivot Table, Pivot Chart and Slicer
Lecture15:Pivot Table
Lecture16:Pivot Chart and Slicer
Lecture17:Pivot Charts and Slicer New Without Solution (DOWNLOAD)
Lecture18:Pivot Charts and Slicer New With Solution (DOWNLOAD)
Section5:Using Form Controls
Lecture19:Checkbox
Lecture20:Check and Scroll 1
Lecture21:Scroll Chart
Lecture22:Check and Scroll Without Solution (DOWNLOAD)
Lecture23:Check and Scroll With Solution (DOWNLOAD)
Section6:Basic Macros
Lecture24:Basic Macro Part 1
Lecture25:Macro Example Without Solution (DOWNLOAD)
Lecture26:Macro Example With Solution (DOWNLOAD)
Section7:Assigning Macros to Buttons to Navigate and Dashboard
Lecture27:Basic Macro Part 2
Lecture28:Macro Navigation
Lecture29:Dashboard End
Lecture30:Macro chart Example and Navigation Without Solution (DOWNLOAD)
Lecture31:Macro Chart Example With solution (DOWNLOAD)
Lecture32:Macro Navigation With Solution (DOWNLOAD)
Benefits
eduCBA e-campus
Virtual campus powered by robust LMS which enables to study through internet with cutting edge features
Online Video Training Material
Presentation Slides
USP of the product
* 24 x 7 online access* Learn from tutorials curated by expert industry professionals and trainers* Certificate of Completion* Practical application oriented skillsHow to use? (Steps to use Study Material)
Step 1 - eduCBA sends the redemption coupon along with the registration link. Step 2 - Student will register with his register email id and coupon Step 3 - Student receive the course access and password on his/her email idStep 4 - Login using your email id and password and start learningTo get more information, you may want to watch the video below
Learn Everything, Anywhere, Anytime
India's Largest Online Education Marketplace