| For more info call 0208 559 8097 |  |
 |
 |
Category Archives: IT Training |
Getting Started Introduction to MS Project Project terminology What is the Critical path Uses of baselines The Basics Open/Closing a Project Plan Navigating the Project window Working with the Ribbon Backstage view Tell me Zoom Slider Creating a Project Set the project start date Working with the project’s calendar(s) Entering Non-working time Project properties Saving a project Entering & Editing Tasks Understanding & specifying the task mode (manually or auto-scheduled)…
Working with lists creating a list maintaining a list editing records using the data form filtering a list assignment Working with macros and user-defined functions recording and using macros assigning macros using user-defined functions assignment Using basic analysis tools performing ‘What If’ analyses working with scenarios assignment Using advanced analysis tools and external data querying a database importing, exporting files protecting data using data validation using worksheet protection password protecting a…
Action Queries types of query the crosstab query the make table query the append query the delete query the update query Customising Forms manipulating data in the form creating a new form using the form wizard creating a form with a subform modifying and redesigning the form Reports the report wizard creating a report with summary totals using the label wizard modifying and redesigning the report publishing access data on…
Introduction to databases database concepts database layout launching access the access menu system dialog boxes getting help creating a new database closing a database (vs exit access) opening a database Tables database design creating tables using the table wizard creating tables in the datasheet view creating tables in the design view data types field properties data display format vs input mask the input mask data entry problems moving and copying…
Managing the Project management criteria managing time examine an existing Project managing resources Special Features & Advanced Analysis use the course development Project modifying the display (shortcuts) task usage and resource usage views charting data importing into Project ‘grouping’ recurring tasks Templates, Wizards & Macros templates use a sample template global template Customising MS Project customisation custom reports custom tables adding columns to tables custom filters Macros Overview macros creating…
Managing the Project and understanding Project views customising the Gantt Chart bars displaying the Critical Path using the Formatting Tab of the ribbon using Network Diagrams displaying tables inserting and hiding columns creating a new table applying filters using AutoFilters understanding and viewing WBS codes Examining & Updating the Project amending tasks using various views using resource levelling understanding baseline and interim plans view Project baseline information compare baseline &…
First Steps using MS Project 2013 what is MS Project 2013 the opening MS Project 2013 screen Project help screen Using MS Project 2013 the MS Project 2013 screen the ribbon closing MS Project opening an existing Project document changing Project views using templates closing the current Project document Setting up a Project editing your Project file properties inputting start and finish dates selecting a Project calendar type saving a…
What is Social Media? Social Media Platforms Case Studies and Statistics Evolution of marketing communications Broadcast (1 to many) Viral (1 to many to many) Social (many to many) Understand your Customers Business Objectives (4 objectives) Show the world Spread the word Support the Community Humanize the brand Customer behaviour and profiling Market segmentation Social Media optimization Marketing Principles The digital marketing mix Effective channel selection Creating and implementing a…
Introduction A Case Study Traditional versus Agile Approaches What you need to know Agile in a nutshell Why is Agile effective Why don’t more organisations use Agile Agile, sounds good but… 12 Core principles underpinning Agile that will revolutionise your organisation Responsive planning Business value driven work Hands-on business outputs Direct stakeholder engagement Immovable deadlines Management by self motivation ‘Just in time’ communication Immediate status tracking Waste management Constantly measurable…
Using multiple worksheets/workbooks using multiple worksheets creating and using functions inserting new worksheets deleting worksheets creating multiple views freezing panes viewing and arranging multiple worksheet windows navigating in multiple workbooks selecting and viewing multiple workbooks creating and opening a workspace managing multiple worksheets and workbooks selecting multiple worksheets moving and copying data between worksheets linking data between worksheets creating a 3-D formula assignment Charting  using charts creating a chart changing…