150 Microsoft courses in Warlingham

This one-day workshop is ideal for those looking to work with existing databases as well as creating a new Access database. You will learn effective ways to enter and extract data and convert data into a well-presented format for reports. This course will help participants: Plan and create a database Sort and filter records Use field data types Work with tables Create and manage a query Create and work with forms, and use the form wizard View, create and print reports 1 Access introduced Planning a database Creating a blank database Opening an existing database Security warnings The navigation pane Previewing database components Closing an Access database 2 Tables introduced Viewing and navigating table data Navigating using keyboard shortcuts Editing table data Adding records to tables Selecting and deleting records Finding and replacing data Filtering tables Summing table data 3 Queries introduced Opening a query in datasheet view Opening a query in design view Adding fields to a query Sorting query results Modifying datasheet view Saving and closing queries 4 Forms introduced Working with form data Sorting records Filtering records Working in design and layout views Changing object attributes 5 Reports introduced Opening and viewing reports Viewing a report in design view Previewing and printing report data Creating reports with auto report Creating reports with the report wizard Changing field attributes 6 Creating a new database Creating database tables Creating table fields Selecting field data types 7 Table relationships Introducing relationships Establishing table relationships The one-to-many relationship type Establishing referential integrity 8 Creating queries Streamline query criteria using wildcards Creating summary queries Creating queries based on criteria Running date queries Formatting field properties Building queries from multiple tables Summing in queries 9 Creating forms Creating a new form Inserting form fields Working with the property sheet The command button wizard The command button wizard Programming without typing Creating forms with embedded sub forms Creating forms with the sub form wizard Creating forms with the form wizard 10 Creating reports What are report bands? Managing report controls Basing reports on multiple tables Basing reports on queries Sorting and grouping records

This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database. This workshop will help participants: Ensure the integrity of their databases Manage field properties Use the query functions effectively Save time with the query expression builder Create different types of query more quickly Design better forms Link expressions in forms Create better and more useful reports Import and export tables more easily 1 Table relationship integrity Identifying relationships Identifying criteria for data integrity Applying referential integrity Managing relationship join types 2 Table field properties Field properties overview Using input mask field Using default value fields Using field validation rules 3 Query functions Running aggregate function calculations Running sum, average, count, max and min functions Grouping calculated data 4 Query calculations Using query operators and expressions Adding calculated fields to a query Using the query expression builder 5 Action queries Creating make table queries Creating append queries Creating update queries Creating delete queries 6 Designing forms Adding form controls Aligning and arranging form controls Adding pictures and labels to forms Adding new fields to a form Controlling tab order Adding command buttons Adding a combo box control Formatting data using conditional formatting 7 Form expressions (calculations) Using the form expression builder Working with a property sheet within a form Linking expressions within a form 8 Working with reports Creating reports with the report wizard Inserting report fields Formatting fields Inserting report headers and footers Working with a property sheet within a report 9 Grouped reports Creating groups with the report wizard Sorting grouped data Grouping alphabetically Grouping on date intervals Creating sub reports Adding calculations to groups 10 Importing and exporting tables Importing tables into Access Exporting tables from Access Importing and linking data in Access

Autodesk Maya Basic to Fundamentals Training. Ideal for beginners, learn to navigate Maya's interface, create models, apply textures, animate objects, and delve into advanced topics. Engage in interactive in-person or online sessions. Access recorded lessons for review and receive lifelong email support. Learn 3D modeling and animation - enroll today! Click here for more info: Website Duration: 10 hours of immersive learning. Method: Personalized 1-to-1 sessions and Choose your own day and time Monday to Saturday 9 am to 7 pm. Course Overview: I. Introduction to Maya (1 hour) Maya overview and applications Basic interface and navigation tools Project creation and management II. 3D Modeling Techniques (2 hours) Polygon modeling fundamentals Creating, editing, and refining objects Advanced techniques like extrusions and bevels III. Texturing and Materials (1 hour) Introduction to texturing concepts Material creation and application Texture mapping, UV unwrapping, and image importing IV. Lighting and Rendering (1.5 hours) Basic lighting techniques and composition setup Rendering images and animations effectively Output options and file formats V. Animation Skills (2.5 hours) Keyframe animation and animation curves Character rigging and animation Special effects: particles, fluids, explosions, and smoke VI. Intermediate Modeling Techniques (1 hour) NURBS modeling basics and advanced curves/surfaces manipulation Creating organic shapes with NURBS and sculpting tools VII. Conclusion and Next Steps (0.5 hours) Course review and recap Further learning resources and tips Q&A and feedback session Autodesk Maya Basic to Fundamentals Training Course Key Learning Areas: Advanced modeling techniques: Surfaces, Polygons, Subdiv Modeling, etc. Deformation methods: Twist, Lattice, Flare, Bend Shape manipulation: Lines, Pen tools, Revolve, Loft, Planer, Text in Maya Animation: Keyframes, Path animations, Timeline Texturing and Rendering: Diffuse, Reflections, Transparency, Shaders, Resolution settings Lighting and Camera: Basic & advanced lights, Shadows, Camera effects, Path animation Note: The course content and duration are adaptable to cater to learners' needs and proficiency levels.   Maya Interface Proficiency: Participants will develop a comprehensive understanding of Maya's interface, tools, and workflow, allowing them to navigate seamlessly and manage projects efficiently. 3D Modeling Skills: Students will be equipped with polygon modeling techniques to create both basic and complex 3D models with precision. They will master the art of shaping and refining objects, elevating their creativity in 3D design. Texturing and Materials Mastery: Learners will gain expertise in texturing, applying materials, and incorporating images to enhance the visual appeal of their 3D models. They will create captivating surfaces with colors, textures, and reflectivity. Lighting and Rendering Expertise: Participants will learn essential lighting techniques to illuminate their scenes effectively. They will set up cameras and produce high-quality still images and dynamic animations with Maya's powerful rendering capabilities. Animation Techniques: Students will explore the world of animation, utilizing keyframe techniques and animation curves to bring their creations to life. They will delve into character rigging, animating characters with sophistication and realism. Special Effects and Dynamics: Learners will unleash their creativity with mesmerizing particle systems, fluid simulations, and dynamic effects. They will craft captivating visuals, such as explosions and smoke, adding depth and excitement to their projects. Intermediate Modeling Techniques: Participants will refine their skills with NURBS modeling, mastering curve and surface manipulation. They will create intricate organic shapes, pushing the boundaries of their artistic expression. Creative Problem-Solving: Throughout the course, students will tackle real-world projects, facing challenges that foster creative problem-solving skills. They will gain confidence in overcoming obstacles in 3D modeling and animation. Maya Essentials Basic to Fundamental Training Program: Course Focus: Autodesk Maya Essentials, covering fundamental concepts and techniques. Duration: Flexible scheduling, tailored to individual learning pace. Method: Personalized 1-1 training, interactive sessions, hands-on projects. Curriculum Highlights: Introduction to Maya (1 hour): Interface overview, navigation, project management. 3D Modeling Techniques (2 hours): Polygon basics, object creation, advanced editing. Texturing and Materials (1 hour): Texture mapping, material application, UV unwrapping. Lighting and Rendering (1.5 hours): Lighting fundamentals, composition setup, effective rendering. Animation Skills (2.5 hours): Keyframe animation, character rigging, special effects. Intermediate Modeling (1 hour): NURBS modeling, organic shapes, sculpting tools. Conclusion and Next Steps (0.5 hours): Course review, learning resources, Q&A session. These resources will complement your training, providing additional support and insights as you explore the world of Autodesk Maya. Explore the World of 3D Animation: Master the intricacies of 3D computer graphics and animation using Autodesk Maya. Delve into modeling, texturing, animation, and rendering to bring your creative visions to life. Practical Learning Experience: Dive into hands-on projects refining your skills. Craft 3D models, apply textures, animate characters, and produce polished renders. Recognized Industry Expertise: Gain proficiency in Autodesk Maya, a leading software in entertainment, gaming, and animation. Enhance your employability with highly sought-after skills, opening doors to diverse career paths. Endless Applications: Uncover Maya's versatility in entertainment, architectural visualization, product design, and more. Tailor your expertise to align with your passions and career aspirations. Reinforcement through Recordings: Access comprehensive lesson recordings for thorough review. Revisit specific topics, reinforcing your grasp of Autodesk Maya at your own pace. Continuous Guidance: Receive lifetime email support for ongoing mentorship. Seek answers, clarifications, and expert advice, ensuring your continuous growth even after completing the course.

This one-day workshop focuses on building a professional presentation from scratch, giving you essential hints and tips on how to utilise the key features of PowerPoint, including speaker notes, inserting charts, diagrams and pictures, and utilising slide transitions and animation. You will also learn about PowerPoint templates and themes to ensure your presentations have the best impact. This course will help participants: Using Slide Master Create a presentation using a template Insert slides and change the layout Manage slides and control formats Enhance slides using animation, pictures, charts and graphics Work with tables, rows, cells and columns Create and control paragraph lists Insert titles and labels Effectively use slide show controls and presenter view Print slides, handouts and notes 1 Introduction to PowerPoint Navigating the features Creating a simple presentation Inserting new slides and changing layouts Creating speaker notes 2 Using Layouts in Slide Master Editing templates in slide master Adding a design theme Adding transitions, pictures and logos Using Slide Show View 3 Drawing shapes and SmartArt Using Drawing Tool Formats Creating shapes Aligning shapes and stacking order Creating a cycle graphic Creating an organisation chart 4 Animation Visually enhancing slides with animation Using text and object animation Adding animation to lists Making animation work for you 5 Presenting Confidently running a presentation Using presenter view Using the slide show controls

This one-day workshop is designed to enhance your PowerPoint skills to achieve dynamic presentations that work with you, making it easier to deliver a polished, professional presentation. You will learn advanced PowerPoint skills that will save you time and elevate your presentations. This course will help participants: Create custom shows to personalise presentations for individual clients Make the Slide Master work collectively with slide layouts and themes Seamlessly interact with external content using links Work with advanced animations and transitions, and video/audio tools 1 Themes and Masters Add a Design theme to a presentation Make changes to the Slide Master Delete layouts from the slide master Saving a slide master with themes as a template 2 Advanced graphics and diagrams Drawing, duplicating and resizing shapes Grouping, aligning and stacking shapes and graphics Using SmartArt for diagrams and organisation charts 3 Graphs and charts Inserting and formatting a chart Linking an Excel chart to a slide Linking Excel tables to a slide Animating charts 4 Video, Custom animation and Hyperlinks Adding and editing video Animating pictures and drawings Hyperlink to another Slide or Website Compressing and optimising media 5 Presenting Reuse slides Hide slides Rehearsing timings Enabling a presentation to run continuously

For Excel users. Extend the capabilities of Excel with Macros and VBA code.

This Excel Introduction course is a very good introduction to essential fundamental programming concepts using Excel as programming language. These concepts are daily used by professionals and are essential in most jobs. By the end, you'll be comfortable with Excel concepts, ribbons, formulas, and the Functions Wizard. You will gain hands-on practical experience creating a spreadsheet from scratch on your own.

Most people only use a fraction of Excel's capabilities. This workshop shows what you've been missing! This course will help participants: Nest formulas Get the most from pivot tables Use conditional formatting Write array formulas Explore the lookup functions Calculate by criteria Use 'goal seek' and 'scenario manager' for what-if analysis Record macros 1 Nesting formulas Principles of nesting formulas together Using IF with AND or OR to answer questions Nesting an AND function in an IF Nesting an OR function in an IF 2 Advanced pivot table reports Grouping dates, numerical and text items Running percentage analyse Running analyses to compare data Inserting Field calculations Finishing off with a user-friendly dashboard 3 Advanced conditional formatting Colour table rows based on criteria in it Applying colour to approaching dates Exploring the different rule types 4 Lookup functions Going beyond the VLOOKUP function Lookups that retrieve data from left or right The versatile INDEX and MATCH functions Retrieving data from columns with duplicates 5 Calculate by criteria Using SUMIFS to sum by criteria Finding an average by criteria with AVERAGEIFS Use SUMPRODUCT to multiply then add different values 6 What-if analysis Use Goal Seek to meet targets Forecast reports with the Scenario Manager 7 Recording Macros Macro security Understanding a Relative References macro Recording, running and editing macros Saving files as Macro Enabled Workbooks Introduction to VBA code Making macros available across workbooks Add a macro button to the Quick Access toolbar

professional financial modelling and data analysis courses

This one-day course focuses on issues such as writing formulas and accessing help while writing them, and taking formulas to the next level by nesting one inside another for a powerful formula result. It also looks at ways of analysing data with reports, summarised by varying criteria. A range of time-saving tips and tricks are shared. This course will help participants: Calculate with absolute reference Group worksheets Link to tables Use the function library effectively Get to grips with the logical IF function Use conditional formatting Create pivot table reports Use data validation Master the VLOOKUP function 1 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 2 Grouping worksheets Grouping sheets together Inputting data into multiple sheets Writing a 3D formula to sum tables across sheets 3 Linking to tables Linking to a source table Using paste link to link a table to another file Using edit links to manage linked tables 4 The function library Benefits of writing formulas in the function library Finding the right formula using insert function Outputting statistics with COUNTA and COUNTBLANK Counting criteria in a list with COUNTIFS 5 Logical IF Function Outputting results from tests Running multiple tests for multiple results The concept of outputting results from numbers 6 Conditional formatting Enabling text and numbers to standout Applying colour to data using rules Managing rules Copying rules with the format painter 7 View side by side Comparing two Excel tables together Comparing two sheets together in the same file 8 Pivot table reports Analysing data with pivot tables Managing a pivot table's layout Outputting statistical reports Controlling number formats Visualising reports with pivot charts Inserting slicers for filtering data 9 Data validation Restricting data input with data validation Speeding up data entry with data validation 10 VLOOKUP function Best practices for writing a VLOOKUP A false type lookup A true type lookup Enhance formula results with IFNA 11 Print options Getting the most from print Printing page titles across pages Scaling content for print