![]() Format charts better to improve presentation.Work better with data linked to graphs/charts.Attendees should have previous experience with a Windows PC. Double-screen or wide-screen if you wish to follow the trainer, otherwise you just view.A headset with microphone is recommended.Your PC/laptop, with internet, sound enabled and speakers.Copies of all example files for your own work.Support for your questions after the session.Recording of the session for on-demand reviewing later.Interactivity – you can ask and answer questions.PDF workbook of step-by-step instructions.This is a 3-hour live, online session and participants will learn how to: Integrate data more efficiently and create live links.ĬLASS Training Excel Intermediate Course or experience with Excel (creating, editing, formatting basic spreadsheets, etc).Share workbooks and work with templates.Apply data-entry protection to data correctly.Use conditional formatting for ‘dashboard’ reporting.Use data validation to prevent data-entry errors.Edit macros and work with Visual Basic (VBA) code.Automate processes by creating and working with macros.Massage data automatically: convert text to numbers, change case, combine columns, etc.Use automated database features and SUBTOTAL functions.Add new data and have powerful formulas update automatically.Create complex ‘nested’ formulas to extract data better.Create and troubleshoot LOOKUP functions (V/H LOOKUP, the newer XLOOKUP).Create and work with IF functions (IF, COUNTIF, SUMIF, multiple IFs).And content/outcomes can be customised/tailor-made to your requirements.ĬLASS Training Excel Basics course or experience with Excel. Find duplicate data, view documents side-by-side.Ĭourses are delivered in our training rooms, or can be conducted in your training room onsite, or as live, online sessions.Add new data and make PivotTables reports update automatically.Create, edit and format powerful reports with PivotTables. ![]() Manage and copy sheets using shortcuts, calculate totals across sheets and link to files.Group and outline large data to summarise it easily.Use cell name ranges to create formulas more easily.Make formulas update automatically when adding new data.Sort and manipulate data more easily: change data, split and combine data, etc.Work with data linked to graphs/charts better.Format charts better with simple dashboards to improve presentation.Revise the important basics and shortcuts.This is a 1-day hands-on, face-to-face session and participants will learn how to: ![]() Participants are expected to have some knowledge of and experience with a Windows PC. No experience in using Excel is required nor assumed. See Benefits to the right for a list of services provided to all participants (depending on the course).įor more details or to inquire about a closed corporate or online program, use our inquiry form here or phone us on (02) 6041 2711. And content/outcomes can be customised/tailor-made to your requirements. OR, sessions can be conducted in your training room onsite, or as live, online sessions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |