55 Courses in Edinburgh

This one-day workshop is intended for participants who have a basic understanding of Outlook but who want to know how to use its advanced features to manage their email communications, calendar events, contact information and other communication tasks. This course will help participants: Gain confidence using Outlook and its advanced features Organise and prioritise email messages Archive messages for safe-keeping Use rules to process received or sent messages automatically Manage scheduled meetings with others Give others permission to view and manage their folders and items Use contacts and commands to find out more about a person or company Prioritise work-flow using tasks and assigning tasks to others 1 Email messages Combining multiple clicks with quick steps Following up flag options Saving multiple attachments Attaching a folder of files Recalling and replacing a message Categorising messages with conditional formatting 2 Message options Adding options to messages Marking a message as private Receiving quick responses with voting buttons Directing replies to specific users Delaying sent messages Inserting links in messages 3 Stay organised with rules Using rules to automate message flow Moving messages with rules Using the rules wizard Setting up rules with conditions Using rules that work whilst you are away 4 Message clean-up Using conversation clean-up Using mailbox clean-up Moving messages to the archive folder Archiving folder properties Auto-archiving properties 5 Managing calendars Creating calendar groups Sharing calendars with permissions Setting up working days and times Managing time zones Categorise appointments with conditional formatting Publishing a calendar 6 Schedule meetings Scheduling a meeting Managing meeting responses Proposing new meeting times Adding attendees to a meeting Viewing multiple appointments 7 Using contacts Merging contacts to letters Merging contacts to labels Mail merging contacts in Word Exporting contacts to Excel 8 Managing tasks Organising your workload with tasks Categorising tasks Assigning tasks to others Sending a task status report Allocating time for tasks Regenerating a new task Viewing your tasks in the calendar 9 Adding message items Adding calendars to messages Adding business cards to messages 10 Email accounts Adding multiple user accounts Adding account permissions

This workshop will provide participants with the insight and skills to be more effective business networkers, face-to-face and online. The approach taken is to build on the strengths people already have and their successes. It is easier to develop what you already have than to try and develop skills that do not come easily. Being yourself is the most effective tool for business networking and building relationships. This course will help those attending: Appreciate the importance of networking, and different forms of networking Understand the dynamics of communication that are specific to networking Become more confident and assured when 'working' a room Improve their influencing skills, especially with people who are experts and in positions of authority 'Sell' themselves and promote their company Identify and manage their profiles using online social networking sites Use effective follow-up to maintain active contacts and connections Select the correct networking groups, clubs and events Create their own personal network 1 The importance, and different types, of networking Personal objectives and introductions Test networking session Examples of the importance, purpose and format of various types of networking, and benefits you can expect 2 How to work a room - preparation and strategy Three things to know before you attend any event Non-verbal communication and art of rapport Breaking the ice - worked examples with practical demonstration 3 Communication dynamics in networking - the power of the listening networker Why it is better to listen than talk Effective questioning and active listening Creating a natural and engaging conversation, 1-2-1 and in a larger group 4 Assumptions when networking How to use the 'instant judgement' of others to your advantage What assumptions are you making? How to keep an open mind 5 Business networking etiquette Meeting and greeting at a business networking event - approaching complete strangers and introducing yourself Socialising: joining and leaving groups easily Making a good first impression in 30 seconds The use of status when networking 6 Making connections Asking for cards, contact details and referrals Gaining a follow-up commitment Some tips and tricks 7 Business networking rehearsals Practice sessions 8 Personal business networking online Overview of different types of networking sites - there is a lot more out there than just Facebook! Examples of creating an effective profile Using social networking effectively - case studies and application 'Advanced' applications - blogs, articles, twitter, feeds, etc. Online demonstration and examples 9 Building relationships - follow-up and follow-through Maintaining a good database Developing a contact strategy with different types and levels of contact How to analyse your contact base

This course starts with the basics then moves seamlessly to an intermediate level. It includes a comprehensive yet balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to use the online Power BI service. It looks at authoring tools that enables you to connect to and transform data from a variety of sources, allowing you to produce dynamic reports using a library of visualisations. Once you have those reports, the course looks at the seamless process of sharing those with your colleagues by publishing to the online Power BI service. The aim of this course is to provide a strong understanding of the Power BI analysis process, by working with real-world examples that will equip you with the necessary skills to start applying your knowledge straight away. 1 Getting started The Power BI process Launching Power BI Desktop The four views of Power BI Dashboard visuals 2 Connecting to files Connect to data sources Connect to an Excel file Connect to a CSV file Connect to a database Import vs. DirectQuery Connect to a web source Create a data table 3 Transforming data The process of cleaning data Column data types Remove rows with filters Add a custom column Append data to a table Fix error issues Basic maths operations 4 Build a data model Table relationships Manage table relationships 5 Merge queries Table join kinds Merging tables 6 Create report visualisations Creating map visuals Formatting maps Creating chart visuals Formatting chart Tables, matrixes, and cards Control formatting with themes Filter reports with slicers Reports for mobile devices Custom online visuals Export report data to Excel 7 The power query editor Fill data up and down Split columns by delimiter Add conditional columns Merging columns 8 The M formula Creating M functions Create an IF function Create a query group 9 Pivot and unpivot tables Pivot tables in the query editor Pivot and append tables Pivot but don't summarise Unpivot tables Append mismatched headers 10 Data modelling revisited Data model relationships Mark a calendar as a date table 11 Introduction to calculated columns New columns vs. measures Creating a new column calculation The SWITCH function 12 Introduction to DAX measures Common measure categories The SUM measure Adding measures to visuals COUNTROWS and DISINCTCOUNT functions DAX rules 13 The CALCULATE measure The syntax of CALCULATE Things of note about CALCULATE 14 The SUMX measure The SUMX measure X iterator functions Anatomy of SUMX 15 Introduction to time intelligence Importance of a calendar table A special lookup table The TOTALYTD measure Change year end in TOTALYTD 16 Hierarchy, groups and formatting Create a hierarchy to drill data Compare data in groups Add conditional formatting 17 Share reports on the web Publish to the BI online service Get quick insights Upload reports from BI service Exporting report data What is Q&A? Sharing your reports 18 Apply your learning Post training recap lesson

Generating new leads and new business can be both time-consuming and frustrating. It's not easy - it takes skill, careful preparation and the creation of effective models and methods, even perhaps using formal approaches and scripts. Once generated, a new lead or enquiry must also be carefully managed to maximise the potential revenue it can generate. But it's crucial to get it right. If your company can afford not to worry about getting new business - congratulations! If your company is completely confident that it is performing at peak potential in generating new leads - again, congratulations! But if your company is working in the real world, couldn't your team do with some help, to become even just that little bit more effective, to make the process just that little less painful? This highly practical, intensive workshop gives sales teams the proven strategies and tactics they need to build a sustainable new business pipeline. This course will help participants: Develop a clear and consistent process for new business development and lead-generation Master the secret of effective new business development and lead-generation - 'only sell the appointment or next stage of the sales process, not your product or service' Set and achieve the right level of new business development and lead-generation activity to achieve your personal and organisational sales goals Apply the key principles of effective prospecting and pipeline management using a proven toolkit and approach Overcome the most common 'put-offs' when conducting telephone or face-to-face business-development and lead-generation activities Develop an engaging telephone voice and manner - and a 'networking personality' Qualify potential opportunities with more accuracy on a consistent basis Prioritise opportunities and manage their time when sourcing new business Discover online sources of leads, contacts and referrals Overcome psychological blocks to cold or warm calling - theirs and the client's Identify potential prospects - and decision-makers and influencers within target prospects - with greater accuracy Make outbound sales or appointment calls with improved confidence, control and results Improve the conversion of calls to appointments by using more effective questions and sales messages Get past gatekeepers and assistants more effectively Make the most of your CRM software and systems 1 Online marketing - what works! Workshop overview and learning objectives Choosing your social media channels LinkedIn for sales and marketing Designing and implementing an effective new business email campaign online Creating a lead-generation strategy online - with case studies Avoiding common mistakes in social media marketing Case study: 'Best practice in social media sales and marketing' Using blogs and video-based marketing (eg, YouTube) New trends and how to keep your finger on the 'social media' pulse Twenty essential websites and online marketing tools 2 Making appointments by telephone Planning the call, telephone techniques, integrating with email and online marketing Developing a clear and consistent process to appointment-making Setting and achieving the right level of telephone activity to achieve your appointment goals Applying the key principles of effective prospecting and pipeline management generation, using a proven toolkit and approach Overcoming the most common 'put-offs' to seeing or engaging with you Overcoming psychological blocks to cold or warm calling - yours and the client's Identifying potential prospects - and decision-makers and influencers within target prospects - with greater accuracy Making outbound sales or appointment calls with improved confidence, control and results Improving conversion of calls to appointments by using more effective questions and sales messages The five keys to developing an engaging telephone voice and approaching manner 3 Power networking Strategies for networking and B2B referral-based marketing The importance, and different types, of networking How to work a room - preparation and strategy Communication dynamics in networking - the power of the listening networker Assumptions when networking Business networking etiquette Making connections, asking for cards, contact details and referrals, gaining follow-up commitments Building relationships - follow-up and follow-through 4 Developing new leads Strategies for first-time sales calls Gaining rapport and opening first-time and new business sales calls effectively Advanced consultative selling - questioning techniques to quickly and efficiently uncover opportunities, need areas and preferences Presenting your solution to a new or first-time customer - creating an enthusiastic and compelling personalised and persuasive summary of your proposal Value message - differentiate your solutions clearly and accurately, with tailored value statements Presenting the right initial USPs, features and benefits and making them relevant and real to the customer Smart ways to position price, emphasise value and be a strong player without being the cheapest or leading on price Learn and use advanced techniques to determine customer needs, value and decision-making criteria in depth on a first-time call 5 Organised persistence - CRM and prospect-tracking Organised persistence - sales tracking, following up on 'sleeping' customers, gaining referrals, time and territory management Maintaining a good database for maximising new business ROI Developing a contact strategy with different types and levels of contact Analysing your contact base using state-of-the-art software and tools Making the most of your CRM systems and solutions Understanding that your attitude makes a difference when sourcing new business Setting SMART objectives for new business development and lead-generation Practical exercise - setting personal development and business goals Time management tips to improve daily productivity New business pipeline management strategies for peak sales performance 6 Workshop summary and close Practical exercise - developing your new business action plan Review and feedback

Web development training course description This three-day course helps build a foundation in the development of Web applications. This is not a HTML course but covers the technologies needed to develop web applications. Technologies covered include: ASP.NET, XML, AJAX and HTTP error codes. What will you learn Program Web applications. Work with data and services. Troubleshoot and debug Web applications. Work with client side scripting. Configure and deploy web applications. Web development training course details Who will benefit: Anyone looking for an introduction to web development. Prerequisites: None. Duration 3 days Web development training course contents Programming web applications Customise the layout and appearance of a web page CSS; tables; embedding images; page layout for navigation. Understand ASP.NET intrinsic objects Request; Server; Application; Session; Response; HttpContext. Understand state information in web applications Understand how state is stored based on application design and hardware; understand different types such as session state, view state, control state and application state. Understand events and control page flow Application and page life cycle events; page events; control events; application events; session events; cross-page posting; Response.Redirect; Server.Transfer; IsPostBack; setting AutoEventWireup. Understand controls Understanding various types of controls, including user, server, web and validation controls; know which is the appropriate type of control for a scenario. Understand configuration files Understanding the usage of web.config and machine.config, and the settings that can be made. Working with data and services Read and write XML data Understanding XML, XML validation Does not include: Web services; XPath syntax; XmlDocument; XPathNavigator; XPathNodeIterator; XPathDocument; XmlReader; XmlWriter; XmlDataDocument; XmlNamespaceManager. Distinguish between DataSet & DataReader objects The ability to choose the proper data object to use based on application requirements/design. Call a service from a web page Creating a basic WCF service or web service so that it can be consumed; App_WebReferences; configuration. Understand DataSource controls LinqDataSource: ObjectDataSource; XmlDataSource; SqlDataSource. Bind controls to data by using data binding syntax Ensure that data is updated and displayed in data-aware controls. Manage data connections and databases Database connections; connection objects; connection pools; transaction objects. Troubleshooting and debugging web applications Debug a web application Use in conjunction with custom error pages to display appropriate error information to the appropriate user; implement tracing of a web application, Trace.axd, Trace=True on @Page directive. Handle web application errors HTTP error codes. Working with client-side scripting Understand client-side scripting Purpose of client-side scripting; various client-side scripting languages. LE/370 and Intrinsic Functions. Understand AJAX concepts ASP.NET AJAX implementation; working with client-side libraries, EnablePartialRendering, Triggers, ChildrenAsTriggers, Scripts, Services, UpdateProgress, Timer, ScriptManagerProxy, extender controls. Configuring and deploying web applications Configure authentication and authorisation Forms authentication, Windows authentication; authorisation; file authorisation; impersonation Does not include: Windows Cardspace authentication, Passport (Windows Live ID) authentication, Custom authentication. Configure projects, solutions and reference assemblies Local assemblies; shared assemblies (GAC); web application projects; solutions; configuration files; AppSettings. Publish web applications Choosing the appropriate method to deploy an application based on existing or intended environment; updatable vs. not updateable; MSI deployment; Internet Information Server (IIS) installation and configuration. Understand application pools Purpose of application pools; effect of application pools on web applications.