Distance and online learning Excel courses

...new Interface and the new Backstage View Enter labels and values Edit data Add rows and columns Check spelling Open, close, and save workbooks... Learn about: MS Excel, Basic IT, Basic IT training...

...(profit and loss) on your profit and loss statement and Balance sheet Depreciation model which I have prepared for the course is quite robust and takes... Learn about: Tax Returns, MS Excel, Fixed Assets...

...highly interactive and dynamic GUI. Bookmark Management System - You can bookmark important lessons to watch them again. Self-assessments with instant results... Learn about: Office IT, Microsoft Office, How to use Excel...

...number formats Using functions to format text Working with styles Working with themes Other advanced formatting Outlining and subtotals Outlining and consolidating... Learn about: Ms Office, Office IT, MS Excel...

...million rows of data visually on Bing maps in 3-D format from an Excel table or Data Model in Excel. Discovering data insights: you will gain new understandings... Learn about: Data analysis, Microsoft excel training, Power Maps...

...for:Anyone interested in finance, accounting or related fields Identify key elements in building interactive dashboard with clickable buttons for detail... Learn about: Financial Reporting, Financial Training, MS Excel...

...& Replacing Empty Values Sorting Data Sorting Multiple Columns Filtering Data Lesson III USING FORMATTING TECHNIQUES 22:45 Formatting Numbers & Dates Formatting... Learn about: Advanced Charting, Pivot Reporting, Excel Productively...

...We’ll also encounter examples of using formulas to build formulas; mega formulas, sometimes dozens of lines long, which would be very hard to write manually... Learn about: Excel Formulas, Nesting VLOOKUP, Optimizing Lookup...

...so you'll know the exact steps for your own projects. Course Fast Facts: Only 18 hours to complete this course 260 tutorial videos Expert instructors... Learn about: Microsoft excel training, MS Excel, Skills and Training...

...which is up-to-date and easy to understand. This course is comprised of professional learning material, all delivered through a system that you will... Learn about: MS Excel, Office IT, Microsoft Excel...

...(prior to Office 2007), then there are a lot of features and changes you need to be aware of to fully utilize this software. Chapter I: GETTING COMFORTABLE WITH EXCEL... Learn about: Simulations & Solver, Conditional Formatting, Excel Productively...

...Creating a sparkline. Editing and auditing formulae to ensure they are delivering accurate calculation results. Sorting and filtering data to display pertinent... Learn about: Page Orientation, Summing Cells, Changing Cells...

...learn how to develop a whole new appreciation for the information in your spreadsheets and gain insights into what it might mean. You’ll also learn how to create Pivot Charts... Learn about: MS Excel, PC training, Database training...

...as well as use other auditing tools Create and work with charts Create Pivot Tables and Pivot Charts Record and run macros Solve formula errors Use... Learn about: IT Auditing, Database training, MS Excel...

...Validation rules Clearing existing Data Validation rules C. Conditional Formatting Understanding conditional formatting Managing Conditional Formatting... Learn about: Conditional Formatting, Tables & Formatting, Advanced Formulas...

...learning led by IAP, so you can be assured that the material is high quality, accurate and up-to-date. So, if you want more information about this programme... Learn about: Vlookup and Hlookup, Excel Sheets, Microsoft Excel...

...and move between cells B. Working with Cells and Data Sort data Filter data Search data Set cell ranges Enter values in a cell range Use AutoFill Create... Learn about: Advanced Formulas, Simulations & Solver, VBA & Macros...

...Charts and Graphics, Formatting Charts, Scenarios and Goal Seeking, Advanced Data Analysis. After completion you will find yourself with increased knowledge... Learn about: Data analysis, MS Excel...

...Using Text Functions Breaking Apart Text Entries Using Date & Time Functions Using the Net Workdays Function Using Logical Functions & Fixing Errors Using... Learn about: Simulations & Solver, Advanced calculation, Advanced Formulas...

...2 Hiding and unhiding worksheets B. Controlling the Worksheet View Zooming in and out of a worksheet Viewing a worksheet in multiple windows Splitting... Learn about: VBA & Macros, Tables & Formatting, Advanced Charting...