Description
**This course includes practice exercises and LIFETIME access**** Feb 2020 - Excel Beginners for Mac 2019 Course added!**Everything you need to become a spreadsheet guru in Microsoft Excel 2019/365 from Beginner to Advanced users by Excel experts Simon Sez IT. Excel for Beginners 2019With this 7-hour Microsoft Excel 2019/365 course, you'll gain a fantastic grounding in Microsoft Excel. This in-depth course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. This course is perfect if you're brand new to Excel or are upgrading from an older version. What You'll LearnWhat's new in Excel 2019Creating workbooksEntering text, numbers and working with datesNavigating workbooksPage setup and print optionsWorking with rows, columns and cellsCut, Copy and PasteIntroduction to functions and formulasFormatting in Excel, including formatting cells and numbersCreating charts and graphsSorting and FilteringIntroduction to PivotTablesLogical and lookup formulas - the basicsAdvanced Excel 2019With this 8-hour, expert-led video training course, you'll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information. What You'll LearnWhat's new/different in Excel 2019Advanced 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 Charts***Exercise and demo files included in both courses***This 3-course bundle includes:20-hours of video tutorialsOver 200 individual video lecturesExercise files to practice what you learnedDemo files used by the trainerCertificates of completionThis Excel mega bundle is designed for students of all Excel capabilities. If you are brand new to Microsoft Excel or who are upgrading from a previous version and want to keep up to date with Excel 2019 and 365 developments, then the start at the beginning. If you already have a good understanding of MS Excel then you might want to start in the Advanced section where the expert author will help you take your spreadsheeting skills to the next level. Contents and OverviewThrough 200+ lectures and over 20-hours of content, this course will teach you to understand spreadsheet basics, including: Creating your first workbook and how to navigate ExcelPage and print setup - just print the bits of Excel you mean to! Moving data around and adding and deletingIntroduction to formulas and functions, what you need to know. How to create amazing looking charts and graphsBefore moving onto the most business-relevant advanced functions and formulas you might need. This includes: Financial functions (interest depreciation etc.)Statistical functionsHow to best visualize your data using PivotTables and Pivot ChartsAdvanced chartingAnd so much more... Upon completion of this course, you'll have a great grounding in Excel formulas and functions. You'll be confident in navigating, sharing and using spreadsheets in a variety of ways. You'll be able to create charts that have an impact from databases that communicate data and financial records efficiently and effectively. You will be able to report data in various formats including: tables, graphs and PivotTables. Once completed you'll have advanced understanding of Excel that will positively impact your professional capability. Here's what our students are saying…★★★★★ A comprehensive and well structured course, and the examples and explanations are clearly presented; and the instructor is very engaging, easy to listen to and even entertaining (which is always a plus for keeping ones interest." - Arnold Schwartz★★★★★ "Instructor explains topics in clearly. The course is relevant and is helpful to people who have no or little experience with Excel like me. Update: The instructor makes learning fun and simple, I have been learning many different functions that are necessary when applying to real life business situations." - Daniel Trujillo★★★★★ "One of the BEST courses I have taken on Excel. This course takes the student through all of the options for charting and data visualization. The examples are structured so there is no redundancy and time wasting steps. Well done!"- Jim TibbettsDid 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!
