- Build a solid understanding on the basics of Microsoft Excel. Writing formulas and performing calculations
- SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, TRANSPOSE functions. Inserting headers and footers, and adjusting margins
- Color code data that meet certain criteria with Conditional Formatting.
- Create different variations of charts and graphs that can be used to represent real life scenarios.
- Analyze and sort/filter data to create powerful and captivating pivot tables.
- Introduction to Excel worksheets, workbooks, and toolbar: Learn the basics of Excel and how to navigate a spreadsheet.
- Become an advanced Excel wizard by writing your own programmed tasks directly in Excel to automate complicated tasks.
- Save time applying formatting to other cells with shortcuts
- Manipulate data to gather useful action-oriented information
- Implement formulas, functions and calculations to improve productivity with spreadsheets.
Advance Excel Master’s Program Training covers all of Excel´s must-know features which include the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA (Visual Basic for Applications), Data Validation. During this course, you will build a foundation of working with Excel, Excel Macros and VBA. This foundation will be built as you engage and participate in project-based Excel Macro/VBA exercises, detailed throughout the lectures within this course. Each of the projects will build upon one another, introducing a new concept each time, starting with the basic building blocks of automating any task within Excel and ending with a fully customized Excel VBA project that will automate a series of Excel tasks.VBA stands for Visual Basic for Applications, an event-driven programming language from Microsoft. It is now predominantly used with Microsoft Office applications such as MSExcel, MS-Word and MS-Access. This tutorial teaches the basics of VBA. Each of the sections contains related topics with simple and useful examples.
- ADVANCED EXCEL
- EXCEL VBA
- EXCEL B.I WITH POWER PIVOT & POWER VIEW
For more inquiries, visit our near BIT Training center or e-mail on inquiry@bitbaroda.com or visit one of the BIT Training Centers located in Vadodara (Manjalpur, Sayajigunj, Waghodiya).
- Basic Computer Knowledge.
Write a public review