Description
**This course includes practice exercises and LIFETIME access**If you need to manipulate large buckets of data and turn them into meaningful business decisions, then this 4-course bundle showing you how to use both Access and Excel to an advanced level is for you. We start with the basics in each program before moving onto more complex functionality such as importing data into Excel from an Access database. Access 2016 BeginnersWhat you'll learn: What's new in Access 2016How to add records, and save and delete data. Using Access to set-up a database (desktop or web). To explore the Ribbon interface and how to work with touch devices. Create and work with forms and sub-forms. Sorting data in MS Access and running queries in Access. How Macros work in Access 2016 and how to use them. How to import data from external sources. Access 2016 AdvancedWhat you'll learn: How to effectively link to other data sources outside of AccessHow to split a database by splitting the frontend and backend. Dive into options for packaging your application for distribution. Learn to create, update and maintain macros. Explore the use of Visual Basic for Applications (VBA). Learn the advanced options for forms and queriesExcel 2016 BeginnersWhat you'll learn: How to get started with workbooks whether using a mouse or touch device. The new and improved features in Excel 2016. How to create sophisticated charts and graphs using custom visuals or templates. How to personalize your use of Excel 2016. To use autofill and flash fill to enter data quickly. How to apply themes and cell styles. Practical methods in which you can backup and recover your Excel spreadsheets. How to format dates and numbersExcel 2016 AdvancedWhat you'll learn: Advanced charting and graphing in ExcelHow to use detailed formatting toolsLookup and advanced lookup functionsFinancial functions including calculating interest and depreciationStatistical functionsConnecting to other workbooks and datasets outside of Excel e. g. MS Access and the web. How to create awesome visualizations using sparklines and data barsMastery of PivotTables and Pivot ChartsScenario Manager, Goal Seek and SolverAdvanced charts such as Surface, Radar, Bubble and Stock ChartsThis bundle includes:4 courses covering Excel & Access 201636 hours of video tutorialsOver 240 individual video lecturesExercise files to practice what you learnedDemo files used by the trainerCertificate of completionHere's what our students are saying…"I took this class as a requirement for a new job. I have never touched access before and I was able to pick it up very quickly with this video. The course flowed very nicely and started with the very basic information first before moving on to more complicated tasks. The instructor was very easy to understand and everything was presented at great pace. Since learning how to use access with this class, I have been to create my own database to practice my skills and learn new ones. I would recommend this class to anyone who would like to get a great understanding of access."- Greg Wehner"Time and money well invested! I have been learning by trial and error by myself watching youtube clip. Nevertheless, I never had the impression that I mastered Access or even its basic fundamentals. One day you start to doubt that you may not have the right approach at all. A moment has come to take a break and put the time to learn things well. With this course I feel that I master the basics, but also all the little details very useful that simplifies life. We also learn several tips and tricks to start a project well and avoid getting bogged down later. Above all, I learned a lot of things that I never doubted possible. The instructor is easy to understand and easy to listen to. I devoured the sections without seeing the time pass. In short it is a very complete course and pleasant to follow. I recommend."- Gabriel Beaulieu"Brilliant. Enjoyed it immensely. Learned everything I needed to know."- Brenda BellDid you know?Simon Sez IT teaches all sorts of software, including: - Microsoft Excel- Microsoft PowerPoint - Microsoft Word - Microsoft Project- Microsoft Outlook- QuickBooks- Photoshop Elements - Web Development Languages- And so much more!
