Distance and online learning Excel courses

...Auto-fill cell references Format cell data Cut and paste data C. Create Formulas Create multiple calculation formulas Use AutoSum Create an averaging formula... Learn about: MS Excel, Advanced Charting, Tables & Formatting...

...accurate and up-to-date." On receiving your request, one of our stuff members will call you or send you a message by explaining everything about the course... Learn about: Business Ownership, PA professionals, MS Excel...

...macros Using the macro recorder Viewing and editing macro VBA... Learn about: Ms Office, Office IT...

..."Create new spreadsheets Edit and format sheets Add and delete columns and rows Move columns and rows Freeze columns and rows Add, remove and rename sheets... Learn about: Sheet content, Google Slides, Advanced excel training...

...Return Analysis Earned Value Management EXAM Candidates opting for Vskills certification, will undergo the assessment exam at Vskills centers... Learn about: MS Excel, Critical Path Analysis, Value Management...

...then this course contains all the information you need, and it will help you to get up to speed with simple tasks and the more difficult projects... Learn about: Sort multiple columns, Formula Basics, Find data...

...Managing Worksheets & Workbooks; Navigating Worksheets & Workbooks; Formatting Worksheets & Workbooks; Customisation Options; Configuration Options... Learn about: Formatting worksheets, Lookup Data Using Functions;, Business Intelligence Features...

...1. Acquaint the student with the basic scientific understanding of foods and food processing as determined through biochemistry, chemistry, microbiology... Learn about: Food Packaging, Food safety, Food Microbiology...

...dates into a cell Formatting date entries Displaying the current date Generating a series of dates Using date related functions Entering times into a... Learn about: VBA & Macros, Conditional Formatting, IT Auditing...

...Messages and variables Input boxes and message boxes Declaring variables Option Explicit Scope of variables Constants Visual Basic explained The Excel... Learn about: Messages & variables, Looping over collections, Automating Excel...

...Your work can be sent to your course tutor by email. The course contains valuable tips to prepare for the MOS exam and includes free access to the number... Learn about: Troubleshooting Formulas, Time functions, Pplying Advanced Date...

...Anyone looking to develop their Microsoft Excel 2016 skills. By choosing online learning instead of a classroom based course, it eliminates the need for time away from... Learn about: Office IT, Microsoft excel training, MS Excel...

...a data validation range Create a data validation drop-down list Find cells that contain Data Validation rules Clear existing Data Validation rules... Learn about: VBA & Macros, Advanced Formulas, Data validation...

...This extensive course is designed for microsoft excel professionals who are aspiring to specialise in microsoft excel. Earn industry-recognised credentials... Learn about: Microsoft Excel, MS Excel, Microsoft excel training...

...Linking and Consolidating Worksheets Create a link formula within the same workbook Create a link formula to another workbook Consolidate values from multiple... Learn about: VBA & Macros, Simulations & Solver, Consolidating Worksheets...

...Anyone looking to develop their Microsoft Excel 2013 skills. By choosing online learning instead of a classroom based course, it eliminates the need for time away from... Learn about: Ms Office, Microsoft excel training, Microsoft Excel...

...Custom Appearance & Layout Add and remove field from a pivot table Add and use the page field Change the data area number format Change how empty cells... Learn about: VBA & Macros, Pivot Reporting, Tables & Formatting...

...and workbooks in Excel 2016. A. Protecting Your Spreadsheet Protecting a worksheet Unprotecting a workbook Using a password to protect a worksheet Unprotecting... Learn about: Tables & Formatting, Locking & unclocking, Advanced Formulas...

...and Number Formats in Excel 2010 Organizing Data and Objects in Excel 2010 Verifying Excel 2010 Data and Formulas Automating Excel 2010 Tasks Using Macros... Learn about: Data Organizing, Advanced Formulas, Conditional Formatting...

...commands in Access 2007. Try out the new built-in Date Picker control which can be used for any date fields. Explore how to enter a date into a field on datasheets... Learn about: Email and scheduling, Office IT, Spreadsheet analysis...