Excel training online how to#
Excel training online full#
Excel training online plus#

Keep reading to find out the top 5 reasons why Excel training is a wise investment. Most people aren’t using Excel at its best. If you’ve never had Excel training you could be making mistakes and wasting time. With training courses available for all experience levels, it’s easy to get trained up in VBA.ĥ reasons why you should invest in Microsoft Excel training With Microsoft VBA you can develop programs that control Microsoft Excel and Access, and other programs in Microsoft Office.

Excel training online how to#

Meet our trainer Alan Gilbert, a man who knows how to deliver excellent training courses for us, particularly in Microsoft Excel and Powerpoint. If you’d like to know a little bit more about the people delivering our training courses, read on.

Excel training online plus#

Or require any additional information, this is all part of the service and our team are here to help!ĮLearning package per user £39.99 Plus VATīuy now using the above PAYPAL links, once your payment is received we will email you your access details.Īlthough eLearning packages offer a great stand alone product we also offer anyone who attends a standard course the option of adding the complementing eLearning package for only £25.00.Who actually delivers the Go.Courses training? Meet our trainer - Alan Gilbert

Excel training online full#

We always include both video and exercises to help youĮach of our paid courses comes with our full support, if you get stuck, want to check your understanding Our experienced training team have designed each package from the ground up, to ensure it delivers Opening and editing spreadsheets automatically Text handling – property, functions, strings and variantsĪuto-Fill multiple spreadsheet from user-defined promptsĬhoices – option buttons, scroll bars, check boxes, list boxes, combo boxesĭialog Boxes – creating a dialog box, using a dialog box and dialog control The basic language – syntax, instructions, conditions and loops

Visual Basic definitions – general, event, function, sub procedures and modules Visual Basic controls – events, properties, text, methods, Forms, Focus Users will also have a greater understanding of Visual Basic, unlocking the door to the most popular used programming language throughout the world. By the end of the course, users will be able to create their automated procedures. This course aims to give users an introduction to Visual Basic Programming within the Excel application. Customising excels default settings Modify existing toolbarsĪ 2 Day VBA Programming Course (complex macros) aimed at Advanced Excel users.Introduces the user to the basics of macros. How to use the form controls to make filling in spreadsheets quicker and easier for your users. Connect to an extrernal Data Source using OBDC Connectors.Bringing together data from multiple sources.How to consolidate your excel data from multiple locations. Quick refresh on commonly used formulas in Excel. By the end of the course, users will be able use features including Goal Seek, Data Tables, Scenario Manager and Macros. This course aims to extend the users knowledge with more tools and commands. Restrict the formatting and editing of your spread sheets by users.Ĭreating, editing and understanding the Pivot Table tool in Excel.Ī 1 Day Advanced Course, aimed at users that have attended the previous stages or experienced users. Shows the functions of other programs through excel. Quick ways to professionalise your cells formatting and appearance.Įffective ways of working with sets of Data in Excel. Shows the user how to action the more enhanced commonly used formulas. By the end of the day users will be able to use features including sort, filters, PivotTables and Linking spread sheets. How to use your data in various chart types.Ī 1 Day course aimed at users that have attended the introduction course or are an experienced user currently creating and using excel within their role. Understanding and fixing complex spreadsheets that other users may have set up

Largest and smallest figures from a range of data. Sorting and Filtering your data to get more accurate statistics from your spreadhseet.Ĭhanging the look and feel of spreadsheets.Ĭreating and using simple formulae to return totals, averages, Introduces the user to the layout of Excel, identifying commonlyīuild confidence by performing simple tasks whilst navigating By the end of the day, users will be able to create, amend and manipulate their own spreadsheets. A 1 day Introduction Course, aimed to give users the confidence and knowledge to create and use Excel spreadsheets.