What you'll learn:
- Fundamentals of Microsoft Excel.
- Data entry and modification.
- Automation in your daily tasks by using formulas.
- Inserting images, templates and shapes in your excel worksheet.
- Use of different formulas and templates.
Course offers:
- One on one Live interactive sessions by our team of experts.
- Personalized live classes and feedback.
- Doubt removal sessions
- Daily assignments
- 24x7 immediate customer support
Requirements:
- Before learning Microsoft Excel, you must have the basic knowledge of Computer Fundamentals.
Course content:
Duration : 24h
-
Class #1: Introduction to Microsoft Excel 2018
-
Class #2: Worksheets and Workbooks
-
Class #3: Formatting Cells and Data
-
Class #4: Editing Worksheets and Cells
-
Class #5: Introduction to Formulas
-
Class #6: Creating a What-If Analysis
-
Class #7: Adding Images and Graphics
-
Class #8: Charts and Diagrams
-
Class #9: Creating Data Lists
-
Class #9:Pivot Tables and Charts
-
Class #10: Templates and Macros
-
Class #11: Retrieving External Data
-
Class #12: Sorting and Filtering
-
Class #13: Common Useful Functions
-
Class #14: Introduction to VBA
Projects you will do:
Excel is typically used to organize data and perform financial analysis. It is used across all business functions and at companies from small to large.
Excel is typically used to organize data and perform financial analysis. It is used across all business functions and at companies from small to large.
Description:
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
Skills you will acquire:
- Microsoft Excel expert.
- Managing business stuff.
- Inserting and manipulating of formulas.
- Entering and modification of data.
- Top skills to work on Excel worksheet.
Description:
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
$138 $154 10% off
Buy Now
