Excel intermediate courses

...If you have some Excel knowledge, or no Excel knowledge, this course takes you quickly from basic knowledge to a greater understanding of Excel's features. It touches on Beginner, Intermediate and Advanced features...

...This course covers how to create and use If Statements, Lookups and PivotTables to improve your spreadsheets and efficiency. Topics include: If/Or/And/IsError/NestedIf/VLookups/HLookups/Conditional Functions/Countif/PivotTables and Charts. Suitable for: Excel users who, at intermediate or advanced...

...this Excel course will enable you to develop and retain expert skills to help you add real value to your career. This Excel course programme covers the City and Guilds Spreadsheet Processing Techniques Intermediate exam as well as the Microsoft Certified Application Specialist test (MCAS) and...

...The course delves deeper into the Query Editor and the DAX language; it discusses Excel and PowerPoint integration; and whows delegates how to use bookmarks and custom visuals to construct interactive data narratives for their audience... Learn about: MS Excel, Power Query, Auto Date...

...If you have some Excel knowledge, or no Excel knowledge, this course takes you quickly from basic knowledge to a greater understanding of Excel's features. It touches on Beginner, Intermediate and Advanced features...

... Text boxes Word Art AutoShapes Linking and embedding objects Microsoft Excel charts and data Other objects... Learn about: Envelopes and Labels, Microsoft Word, Word Art...

...Our Microsoft Excel 2010 Advanced course is suitable for those with a sound working knowledge of Excel who wishes to progress to the most complicated functions and features... Learn about: Office IT, Ms Office...

...In this Excel 2013 – Frequently Used Formulas & Functions online training series, you’ll learn how to set-up formulas to ensure you’re using all the features Microsoft® Excel® 2013 has to offer.... Learn about: Simulations & Solver, Conditional Formatting, MS Excel...

...Purchase the MOS Excel 2016 Essentials and Expert Courses together for the discounted price of £225.00. This will allow students to aim for the MOS Excel 2016 Essentials 77-727 exam and the MOS Excel 2016 Expert 77-728 exam... Learn about: Creating Spreadsheets, Manage Tables, Create Advanced Formulas...

...Includes indexation patterns, rent caps, discounts/premiums to indexation, rent free periods, as well as how to deal with costs during vacancy Modelling... Learn about: Financial Modelling, Cash Flow, Profit calculations...

... with calculations, applying regular and conditional formatting, creating custom formats, using names, leveraging the power of tables and charts and outputting your work. These are the skills every Excel user needs to know no matter how new or how experienced you may... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...

...In this Excel 2016 for PC – Protecting Your Spreadsheets online training series, you’ll learn about how to protect your Excel cells, worksheets, and workbooks in Excel 2016... Learn about: Pivot tables, VBA & Macros, Advanced Charting...

...metrics Review accounting principles as applied to Real Estate Funds Model dividend policy and distributions under various scenarios Analyse risk using metrics... Learn about: Private equity, Related metrics, Equity Fund model...

...Microsoft Excel 2013 is a spreadsheet developed by Microsoft which allows you to create worksheets and workbooks to manage and manipulate data easily. User can cut, copy, and paste data. You can also navigate within data cells, and worksheets. User can also group, color-code, and organize... Learn about: Advanced Formulas, Microsoft Office, Advanced Charting...

...Course Outline Day One Modelling international variations in real estate income streams i.e. Includes indexation patterns, rent caps, discounts/premiums to indexation... Learn about: Development Finance, Investment analysis, Rent function...

...Microsoft Excel 2013 is a spreadsheet developed by Microsoft which allows you to create worksheets and workbooks to manage and manipulate data easily. User can automate using Macros, do What-if analysis... Learn about: Conditional Formatting, Microsoft Office, Office IT...

...Learn the skills every Microsoft Excel user needs to know - no matter how new (or how experienced) you are... Whether you want to learn Excel 2016, 2013, 2010, 2007, or upgrade from one version to the next, our expert instructors will use a hands-on, engaging approach to teach you all of Excel's... Learn about: Microsoft Excel, Excel Formula, Microsoft excel training...

... this course, you won't just know Excel; you'll be an Excel rock star, and your co-workers will be jealous. You will know how to create worksheets for different types of tasks, and how to set up calculations used in different fields and professions. You'll also know how to analyze large amounts of data so they... Learn about: Microsoft excel training, Microsoft Excel, Data analysis...

... code to customize and automate your work. Does EVERY Excel user need to know these skills? No. But if you want to use Excel beyond simple data entry and calculations to its fullest potential and therefore be able to reach your own full potential, this series will help get you there... Learn about: MS Excel, IT Auditing, Microsoft Excel...

... to use it more effectively whether you are using Excel 2013 or Excel 2016. Understand how to manipulate data within a spreadsheet, validate and present information using the built in structure and functions of Microsoft Excel... Learn about: Microsoft excel training, Microsoft Excel, MS Excel...