Learn how to input data using shortcuts, manipulate data, and quickly answer a range of questions relating to the data. Its very easy to set up your home or work computer via a simple link well send you. Virtual Classroom Training option: This course is delivered online with an expert trainer in a virtual environment. Interrogating and manipulating lists of business data are important skills. Microsoft Excel Level 1 Starter Introduction. Lists of business data (Input, edit and question your data) Learn how to use a range of formatting techniques to create structure in your spreadsheet. Formatting techniques (Simplify your data) Learn common mistakes – Use different techniques to create formulas – BODMAS – AutoSum – Insert Function – Formulas tab – Percentage calculations – Validate simple formulas – Referencing cells – Managing sheets. Learn a few important facts about Excel – Techniques for selecting cells and data – Enter spreadsheet data – use shortcuts – Prepare the quick access toolbar – Saving to local – 365 SharePoint – OneDrive. Introduction to Excel (Get to know Excel) The files below will be used during training to help improve your performance. Microsoft Excel & Windows Shortcut and Training Files Post course support relating to course content.
#Learn excel online handbook software#
There will be a 15 minute break in the morning and afternoon, with 45 minutes for lunch. Free training downloads are provided to all delegates on completion of the course. The lessons are structured using sample data that relates to your course handbook. The training will be delivered using the latest version of Microsoft Excel on our computers. The course is informal but structured and you will be encouraged to ask questions as the course develops. Prior knowledge of Excel is not essential but is beneficial. This covers the widely used basic functions of Microsoft Excel at introduction level.