Excel training brochure v0.01

50 %
50 %
Information about Excel training brochure v0.01

Published on July 1, 2016

Author: mahimakandar

Source: slideshare.net

1. TRAINING MANUAL Excel/ VBA Training JUNE 7, 2016 WWW.ORANETECH.COM +91 80 4145 6644

2. Page 1 of 12 Creating value addition in young software engineers!! Orane N A Chambers, 1st Floor, 3 J, 3rd cross, 7th C Main, 3rd block, Koramangala, Bangalore- 560034 www.oranetech.com T: +91 80 4145 6644 Orane is an emerging force in the IT industry with a global foot print. Our objective is to create an organization with a philosophy that is carefully aligned to affable culture, our growth strategy and most importantly sound value for people. To provide the requisite impetus for ORANE and to deliver unique value preposition to the young, bright and creative engineers. We have developed the internship/ training which caters to the fresh engineers as a stepping stone towards their academic and career success. We hope that, by providing the outline, details and practical experience insights of our successful Training/ Internship Programs, the esteemed organization will be encouraged to join us in providing meaningful work experiences to engineering resources. Our staffs sincerely enjoys working with your team and contributing meaningfully to their growth as engineers. The peer’s enthusiasm energizes us, and we have observed many occasions where our co- workers spontaneously develop informal mentoring relationships outside the formal team structure we have provided in our program. Upcoming Events May 1 Launch of new training modules May 31 Quiz day June 17 Hi- tea party for trainers Work In Progress Complete execution of documentation project for a large company. Company: Mars India- Bangalore Task:  SRS Document  DD Document  Master Document Trained expertise:  Business Analyst  Techno-Functional Consultant  Documentation Specialist

3. Page 2 of 12 Most Important Paint a picture Training expands the concept of learning beyond simply educating the staff we already have on board, to include reaching out to train candidates we’d all like to have on board full-time someday. Given the competition for an ever-dwindling number of qualified entry-level engineers, it’s an innovative investment worth considering. We also are happy to report that we are finding the “grow our own” approach successful. We just hired our first official intern, who has now graduated, as a full-time member of our engineering staff. Leading the team in complex project execution. Be a step closer to higher level Training on key technologies provides a hands on experience to our team and who doesn’t wish to have a team that excels in internal activities, thus enabling us to raise above the rest. They provide us the edge in representing ourselves as the most wanted vendor to our clients. When engineers elevate their skills, they bring more confidence, energy and enthusiasm into work. They better their execution at all levels of activities. This perhaps, is the most important internal factor, why few organization are ahead of others… Recent Achievements Christ University- Bangalore Group of international students were part of our internship program, hailing from Korea. Orane was one of the chosen vendors to deliver internal training and also internship for these young engineers. We are happy to inform our success, because we see couple of them hired into prominent positions in MNCs as a key member in project execution. Training/ Internship Focused Training on Data Analytics, Business Intelligence- Data warehousing. Tools: Tableau, Qlikview, Power BI

4. Page 3 of 12 Contents Upcoming Events.................................................................................................................................................. 1 May 1.................................................................................................................................................................. 1 May 31................................................................................................................................................................ 1 June 17 ............................................................................................................................................................... 1 Work In Progress .................................................................................................................................................... 1 Most Important ..................................................................................................................................................... 2 Recent Achievements ......................................................................................................................................... 2 Christ University- Bangalore ............................................................................................................................. 2 Training/ Internship............................................................................................................................................ 2 Be a step closer to higher level....................................................................................................................... 2 Excel/ Spreadsheet .............................................................................................................................................. 4 Benefits of Excel / Spreadsheet ...................................................................................................................... 4 Excel, Macros and VBA ....................................................................................................................................... 5 Difference between VB and VBA…................................................................................................................... 5 Access Training ..................................................................................................................................................... 6 Advance Access Programming......................................................................................................................... 8 Other Courses We Offer ...................................................................................................................................... 9 Orane Projects .................................................................................................................................................... 11 Orane- Services................................................................................................................................................... 12

5. Page 4 of 12 Excel/ Spreadsheet Microsoft Excel allows you to manipulate, manage and analyze data helping assist in decision making and creating efficiencies that will directly affect your bottom line. Whether you’re using it for business or to help manage personal database and expenses Microsoft Excel gives you the right tools to enable you to accomplish all your needs. Microsoft Excel is a versatile program present on most computers at home and in computer clusters. It is a business tool for accounting and managing large sets of data. It can also simplify graphing and analyzing data from the labs. By the end of the training, we will be sure about: 1. Starting Excel 2. Using Help 3. Workbook Management 4. Cursor Management 5. Manipulating Data 6. Using Formulae and Functions 7. Formatting Spreadsheet 8. Printing and Layout 9. Creating Charts and Graphs Benefits of Excel / Spreadsheet Easy and effective comparisons - With the powerful analytical tools included within Microsoft Excel you have the ability to analyze large amounts of data to discover trends and patterns that will influence decisions. Powerful analysis of large amounts of data - Recent upgrades to the Excel spreadsheet enhance your ability to analyze large amounts of data. With powerful filtering, sorting and search tools you are able to quickly and easily narrow down the criteria that will assist in your decisions. Combine these tools with the tables, Pivot Tables and Graphs you can find the information that you want quickly and easily even if you have hundreds of thousands of data items. Working Together - With the advent of the Excel Web App you can now work on spreadsheets simultaneously with other users. The ability to work together enhances your ability to streamline processes and allows for ‘brainstorming’ sessions with large sets of data – the collaboration tools allow you to get the most out of the sharing capabilities of Microsoft Excel. The added bonus is that as the Excel Worksheet is web based you can collaborate anywhere – you are no longer tied to your desk but can work on spreadsheets on the go – this is ideal for a businessman on the go. Microsoft Excel Mobile & iPad Apps - With the advent of the tablet and the smart phone it is now possible to take your worksheets to a client or a meeting without having to bring along your Laptop. The power of these mobile devices now allows you to manipulate data and update your spreadsheets and then view the spreadsheets immediately on your phone or tablet.

6. Page 5 of 12 Figure 1: Excel- Course Details & Hours Excel, Macros and VBA VBA is a programming language created by Microsoft to automate operations in applications that support it, such as Excel. VBA is an enormously powerful tool that enables you to control Excel in countless ways that you cannot do—or would not want to do—manually. In fact, VBA is also the language that manipulates Microsoft Office applications in Access, Word, PowerPoint, and Outlook. For the purposes here, VBA is the tool you use to develop macros and manipulate objects to control Excel and to control other Office applications from Excel. Back in the day, a programming language was often called a “macro language” if its capabilities included the automation of a sequence of commands in spreadsheet or word-processing applications. With Microsoft's release of Office 5, VBA set a new bar for how robust a programming language can be, with capabilities extending far beyond those of earlier programming languages, such as the ability to create and control objects within Excel or to have access to disk drives and networks. So VBA is a programming language, and it is also a macro language Difference between VB and VBA… With all the acronyms bandied about in the world of computing, it's easy to get some terms confused. VB stands for Visual Basic, and it is not the same as VBA. Though both VB and VBA are programming languages derived from BASIC and created by Microsoft, they are otherwise very different. Overview-(Part1&Part2) Part 1- 8hrs •Introducing Excel •Entering and Editing Worksheet Data •Essential Worksheet Operations •Working with Cells and Ranges •Introducing Tables • Worksheet Formatting •Understanding Excel Files •Using and Creating Templates •Printing Your Work Part 2- 12 hrs •Introducing Formulas and Functions •Creating Formulas That Manipulate Text •Working with Dates and Times •Creating Formulas That Count and Sum • Creating Formulas That Look Up Values •Creating Formulas for Financial Applications •Miscellaneous Calculations •Introducing Array Formulas • Performing Magic with Array Formulas Hands-on(Part3) Part 1- 9hrs •Getting Started Making Charts •Learning Advanced Charting •Visualizing Data Using Conditional Formatting • Creating Sparkline Graphics •Enhancing Your Work with Pictures and Drawings DeveloperTools(Part4&Part 5) Part 1- 9 hrs •Customizing the Excel User Interface •Using Custom Number Formats •Using Data Validation •Creating and Using Worksheet Outlines •Linking and Consolidating Worksheets • Excel and the Internet •Protecting Your Work •Making Your Worksheets Error Free Part 2- 7 hrs •Importing and Cleaning Data •Introducing Pivot Tables •Analyzing Data with Pivot Tables •Performing Spreadsheet What-If Analysis •Analyzing Data Using Goal Seeking and Solver

7. Page 6 of 12 VB is a language that enables you to create standalone executable applications that do not even require its users to have Office or Excel loaded onto their computers. VBA cannot create standalone applications, and it exists within a host application such as Excel and the workbook containing the VBA code. For a VBA macro to run, its host application workbook must be open. This book is about VBA and how it controls Excel. Figure 2: Excel- Macros- VBA- Course Details & Hours Access Training Access is an excellent (many would say logical) next step for the analyst who faces an ever- increasing data pool. Access takes very few performance hits with larger datasets. It has no predetermined row limitations. And it can effectively manage the relationships between disparate data tables. In addition, Access comes with tools that help you build your own distributable applications. Today, when we have more data than ever and more demands for complex data analysis, power analysts need to add some tools to their repertoire in order to get away from being simply “spreadsheet mechanics.” That's why this book is such an important step in the evolution of your skillset. Throughout this book, not only will you get an introduction to Access, but you'll also learn various ways in which you can use Access to improve your daily data management and analysis. Overview(Part1toPart3Ch-2) Part 1- 5 hrs •Excel 2010: Where It Came From •Excel in a Nutshell •Formula Tricks and Techniques • Understanding Excel Files Part 2- 3 hrs •What Is a Spreadsheet Application? •Essentials of Spreadsheet Application Development Part 3- 11 hrs • Introducing Visual Basic for Applications •VBA Programming Fundamentals Hands-on(Part3-Ch-3toPart4) Part 3- 10 hrs •Working with VBA Sub Procedures •Creating Function Procedures •VBA Programming Examples and Techniques Part 4- 10 hrs •Custom Dialog Box Alternatives •Introducing UserForms • UserForm Examples •Advanced Userform Techniques DeveloperTools(Part5toPart7) Part 5- 10 hrs • Developing Excel Utilities with VBA • Working with Pivot Tables • Working with Charts • Understanding Excel's Events •Interacting with Other Applications •Creating and Using Add-Ins Part 6- 4 hrs • Working with the Ribbon •Working with Shortcut Menus •Providing Help for Your Applications •Developing User-Oriented Applications Part 7- 9 hrs • Compatibility Issues • Manipulating Files with VBA •Manipulating Visual Basic Components • Understanding Class Modules • Working with Colors • Frequently Asked Questions About Excel Programming

8. Page 7 of 12 Figure 3: Access Course Details & Hours Part 1- Access Building Blocks| 3 hrs •An Introduction to Database Development •Getting Started with Access Part 2- Understanding Access Tables| 8 hrs •Creating Access Tables •Understanding Table Relationships •Working with Access Tables •Importing and Exporting Data •Linking to External Data Part 3-Working with Access Queries| 6 hrs •Selecting Data with Queries •Using Operators and Expressions in Access Part 4- Analyzing Data in Access| 7 hrs •Transforming Data in Access •Working with Calculations and Dates •Performing Conditional Analyses •Fundamentals of Using Access SQL •Subqueries and Domain Aggregate Functions •Running Descriptive Statistics in Access Part 5- Working with Access Forms and Reports| 8 hrs •Creating Basic Access Forms •Working with Data on Access Forms •Working with Form Controls •Presenting Data with Access Reports •Advanced Access Report Techniques

9. Page 8 of 12 Advance Access Programming Figure 4: Advanced Access Course details & Hours Advanced Access Programming Techniques 10 hrs Debugging Your Access Applications -Organizing VBA Code -Testing Your Applications -Traditional Debugging Techniques -Using the Access Debugging Tools -Trapping Errors in Your Code Accessing Data with VBA Code -Working with Data -Understanding ADO Objects -Understanding DAO Objects -Writing VBA Code to Update a Table Advanced Data Access with VBA -Adding an Unbound Combo Box to a Form to Find Data -Filtering a Form Integrating Access and SQL Server -Introducing SQL Server Express -Understanding Data Types in SQL Server -Installing SQL Server Express -Connecting to SQL Server -Working with SQL Server Objects Customizing the Ribbon -The Ribbon Hierarchy -Editing the Default Ribbon -Working with the Quick Access Toolbar -Developing Custom Ribbons -Creating a Custom Ribbon -The Basic Ribbon XML -Adding Ribbon Controls -Attaching Ribbons to Forms and Reports Completely Removing the Ribbon Preparing Your Access Application for Distribution -Defining the Current Database Options -Developing the Application -Polishing Your Application -Bulletproofing an Application Securing the Environment

10. Page 9 of 12 Other Courses We Offer 1. Business Intelligence / Data warehousing 2. Data Analytics 3. Data Analysis 4. Business Analysis Tools & Applications: 1. Microsoft Office: a. MS-Excel & Macros (VBA) b. MS-Access & Macros (VBA) c. VBA for PowerPoint d. Access e. MS Sql Server 2005, 2008, 2012, 2014 f. T-SQL Programming g. Sql Server Reporting Services 2005 to 2014 h. Power BI (Power Pivots, Power View, Power Designer, Power Maps) 2010, 2013, 2016 i. Statistics using Excel Data Analysis Toolpak 2. Tableau 8.0 to 9.3 Desktop, Server, Online, Public, Reader 3. Sisense v6.0 with Elasticube 4. Qlik Tech Products a. Qlikview 11 b. Qliksense 2.2 5. Database: a. RDBMS b. SQL c. Dimensional modelling 6. Domain Specific a. Financial Modeling b. Cost Modeling c. Spend Analytics d. Retail Analytics e. HR Analytics f. Healthcare/Pharma Analytics g. PMO h. Infrastructure Management (ITO) 7. Big Data – Hadoop, 8. HDFS (Hadoop File System) 9. Oracle a. Oracle BRM b. Oracle suite

11. Page 10 of 12 10. Technical Writing 11. Business Analysis 12. Project Consulting and academic project assistance and final year project certification Web & Mobile Technologies Web Development: Tools & Applications 1. ASP.NET 2. C#.NET 3. Python 4. D3.JS 5. Java scripting 6. JQuery 7. PHP 8. JSP 9. Content Management using WordPress & Joomla 10. HTML5 11. CSS3 12. Bootstrap 13. Rest API implementation using PHP 14. Google Cloud Messaging Server using PHP 15. APNS server implementation using PHP 16. Additional API, Web Connectors creation using Python & PHP Mobile Application: (All Platforms) 1. AngularJS 2. Server development of Android and iPhone application 3. Mobile Application 4. MySQL 5. SQLite Testing Modules: 1. Black Box Testing 2. White Box Testing 3. Selenium 4. QTP

12. Page 11 of 12 Orane Projects Mobile Apps: Mars Telecom- a Hyderabad based IT company, providing solutions to various industries across the globe has been kind to utilize Orane’s ever efficient and skilled consultants to deliver Mobile application, solution that is part of the Mumbai municipal authority. The app was focused on enable the authorities of the MUDA community to effectively use technology for its project completion and approval online. The mobile app was designed to work with Samsun mobile phones and tablets. Training & Internship Programs Christ University- Bangalore, is known for its vast knowledge sharing and goodness to accommodate the aspiring student from across the world to complete their graduate and under-graduate programs. By decades of excellence and mastery into the academic system, Christ has carved a niche in the education field. Today they also cater to masters and PhD degrees in variety of subjects. Orane is pleased to have been their chosen vendors to deliver internship & training program to Korean students, under their CART- “Center for Advance Research and Training” department. Website, Social Media & CRM Solutions Stratum Ventures LLP- A Land Development company based in Bangalore, working towards investment properties for short and long term investors from across the globe. Orane shares its gratitude to Stratum Ventures LLP team to have shortlisted us to deliver their end-to-end IT solution, starting from Website to CRM implementation Orane – Global IT Consulting and Services Industries Served Manufacturing Energy and Petrochemical Banking and Finance Government Services Offered BI/DW & EPM ERP Enterprise Products and Solutions Mobile Device Development Consulting, Managed Service Support Testing, Maintenance and Upgrade Value Proposition Relationship driven Business Agility Delivery ROI Quick Response

13. Page 12 of 12 Orane Intelli Solutions N.A Chambers, 1st Floor 3 J, 7th C Main Road, 3rd Block 3rd Cross Road, Koramangala, Bangalore-560034 Email: info@oranetech.com| Web: www.oranetech.com| Ph: +91 80 4145 6644 Large- Enterprise Solutions Big Data Data Visualization BI/ DW ERP Enterprise Mobile App Enterprise Solutions for Medium Scale Data Visualization Analytics ERP- Standalone/ Cloud Application Dev Mobile apps Small Industries Cloud Solutions Application Dev Enterprise Portals Mobile apps Orane- Services Offshore Development Centers | Outsourced Product Development | Staff Augmentation |Trainings Fact Sheet Orane, founded in year 2011- primarily focused in providing Business Intelligence and ERP solutions Headquartered in Bangalore, having strong alliance across various geographies Strong and experienced management with several years of industry experience and solid leadership Ensuring quality delivery and support Projects Completed: Al-Shirawi Ent, Modern Plastics Industry, Kanva Fashions, The Address Makers In the pipeline: SCANIA Bangalore, Bristle Cone, Batavia’s Textile, Live-in- Space Pvt Ltd etc

Add a comment