This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. For Private options, online or in-person, please send us details of your requirements: This Tableau Desktop Training course is a jumpstart to getting report writers and analysts with little or no previous knowledge to being productive. It covers everything from connecting to data, through to creating interactive dashboards with a range of visualisations in two days of your time. Having a quick turnaround from starting to use Tableau, to getting real, actionable insights means that you get a swift return on your investment of time and money. This accelerated approach is key to getting engagement from within your organisation so everyone can immediately see and feel the impact of the data and insights you create. This course is aimed at someone who has not used Tableau in earnest and may be in a functional role, eg. in sales, marketing, finance, operations, business intelligence etc. The course is split into 3 phases and 9 modules: PHASE 1: GET READY MODULE 1: LAUNCH TABLEAU Check Install & Setup Why is Visual Analytics Important MODULE 2: GET FAMILIAR What is possible How does Tableau deal with data Know your way around How do we format charts Dashboard Basics – My First Dashboard MODULE 3: DATA DISCOVERY Connecting to and setting up data in Tableau How Do I Explore my Data – Filters & Sorting How Do I Structure my Data – Groups & Hierarchies, Visual Groups How Tableau Deals with Dates – Using Discrete and Continuous Dates, Custom Dates Phase 2: GET SET MODULE 4: MAKE CALCULATIONS How Do I Create Calculated Fields & Why MODULE 5: MAKE CHARTS Charts that Compare Multiple Measures – Measure Names and Measure Values, Shared Axis Charts, Dual Axis Charts, Scatter Plots Showing Relational & Proportional Data – Pie Charts, Donut Charts, Tree Maps MODULE 6: MAKE TABLES Creating Tables – Creating Tables, Highlight Tables, Heat Maps Phase 3: GO MODULE 7: ADD CONTEXT Reference Lines and Bands MODULE 8: MAKE MAPS Answering Spatial Questions – Mapping, Creating a Choropleth (Filled) Map MODULE 9: MAKE DASHBOARDS Using the Dashboard Interface Dashboard Actions This training course includes over 25 hands-on exercises and quizzes to help participants “learn by doing” and to assist group discussions around real-life use cases. Each attendee receives a login to our extensive training portal which covers the theory, practical applications and use cases, exercises, solutions and quizzes in both written and video format. Students must use their own laptop with an active version of Tableau Desktop 2018.2 (or later) pre-installed. What People Are Saying About This Course “Excellent Trainer – knows his stuff, has done it all in the real world, not just the class room.”Richard L., Intelliflo “Tableau is a complicated and powerful tool. After taking this course, I am confident in what I can do, and how it can help improve my work.”Trevor B., Morrison Utility Services “I would highly recommend this course for Tableau beginners, really easy to follow and keep up with as you are hands on during the course. Trainer really helpful too.”Chelsey H., QVC “He is a natural trainer, patient and very good at explaining in simple terms. He has an excellent knowledge base of the system and an obvious enthusiasm for Tableau, data analysis and the best way to convey results. We had been having difficulties in the business in building financial reports from a data cube and he had solutions for these which have proved to be very useful.”Matthew H., ISS Group
Why Choose InDesign Evening Training Course? Course Link. If you aim to enhance your design abilities, acquire proficiency in a new software, or pursue a career in graphic design, an InDesign course is highly beneficial. Tailored for individuals with foundational knowledge of Adobe InDesign, this training is designed to further develop your existing skills. Duration: 10 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own hours of your choice, available from Mon to Sat between 9 am and 7 pm InDesign Evening Course Outline (10 hours) Introduction Getting Started with Adobe InDesign CC Advanced Course Adjusting Workspace for Maximum Efficiency Customizing Default Font Size for New Documents Utilizing Special Features for Typekit & Open Type Fonts Exploring Sources for Free Fonts in InDesign Mastering Fonts in Adobe InDesign CC Identifying Fonts with Font Guess Selecting Beautiful Font Pairings Incorporating Free Icons from Adobe Market Using the Color Theme Tool Understanding Colour Modes Importing and Setting Default Colors Finding Great Colors with Adobe Color Managing Appearance of Black & Proofing Colors Creating Multiple Shapes with Gridify Live Distribute Drawing Arrows in InDesign CC Designing Complex Flowers in InDesign CC Utilizing Auto Size for Auto-Expanding Text Boxes Exploring Placeholder Text Alternatives Adding Paragraph Borders & Shading Understanding Paragraph vs Single Line Composer Making Paragraphs Span 2 Columns Mastering Justification & Hyphenation Options Aligning Optical Margins Harnessing the Power of Keep Options Working with Advanced Anchored Objects Using Conditional Text Creating Pie Charts & Bar Graphs Pros & Cons of Interactive Types Creating Interactive PDFs Adding Interactive Page Transitions Adding Navigation to Interactive PDFs Understanding Publish Online in InDesign CC Publishing Adobe InDesign Documents Online Adding Video to InDesign Documents Creating Button-Triggered Animations Making Multi-State Objects Incorporating Adobe Animate CC to InDesign Files Adding Maps & Calendars to Interactive Documents Generating QR Codes in InDesign CC Exploring Essential Keyboard Shortcuts Automatically Placing Text on Multiple Pages Creating Cross References & Index Adding Document Name Automatically with Text Variables Utilizing Adobe InDesign CC Book Feature Changing Preferences for Advanced Users Speeding Up Workflow for Advanced Users Using Character Styles Advanced Paragraph Styles Mapping Word Styles with InDesign Styles Creating Nested Styles & Grep Styles Using Next Style Mastering Object Styles Best Practices for Working Across Multiple Documents Utilizing Adobe Stock with InDesign CC Cropping Images Inside Text Making InDesign Layouts with Adobe Comp CC Advanced Use of CC Libraries Integrating Photoshop & Illustrator in InDesign CC Creating PDF Forms in InDesign CC Advanced Use of the Pages Panel Placing InDesign Documents Inside Each Other Installing and Using Scripts in InDesign CC Improving InDesign Performance Advanced Exporting & Printing Tricks Bonus: Software Updates Adobe InDesign https://adobe.com › indesign › get-started Installing for the first time or on a new computer? Click Get InDesign below to begin downloading. Follow the onscreen instructions to sign-in and install.
Help with chronic pain – learn the powerful psychological and behavioural techniques that alleviate persistent pain and accelerate healing with pain specialist Dr Grahame Brown Accredited CPD Certificate: 6 hours Length: 1 day (9.30am - 4.00pm GMT) Fantastic to have the opportunity to train with this specialist. Thoroughly enjoyed this online course – the best I have attended...CLINCIAL HYPNOTHERAPIST Live online training – Join Dr Grahame Brown on Wednesday 24th April 2024 for this practical live online training event via Zoom, you will have plenty of opportunities to ask questions. Simply book your place and we will email you the Zoom link the day before the event. BONUS RECORDING – the training is recorded, in case anyone experiences technical difficulties on the day, so you will also get a recording for a limited time afterwards to maximise your learning. Can’t make this date? Register your interest and we’ll let you know when there’s another. Why you should attend Pain is endemic in our society and whatever the cause – back pain, migraine, arthritic pain, dental pain, irritable bowel (IBS), labour/menstrual pain, cancer pain, psychogenic pain, psychosomatic pain – it can be incapacitating. Chronic pain is any pain which lasts for more than three months and it is estimated that between 25–40% of our population suffer from persistent or chronic pain. The sociological and economic costs of this are enormous but it is in the personal human suffering involved – mental as well as physical – that the real costs should be measured. Many are desperate for effective help to relieve their pain and the associated effects, such as insomnia and depression. This online workshop – with leading pain and musculoskeletal medicine consultant Dr Grahame Brown – gives you important new information about how we experience pain – derived from the latest neuroscience – and a powerful range of psychological techniques for managing pain naturally, preventing it from escalating and speeding up healing. You will discover how people can be helped out of the vicious cycle of chronic pain and how, by working holistically through the bio-psycho-social model, suffering can be dramatically reduced. You don’t need to have any prior medical knowledge to learn from and enjoy the day – you will leave with a much clearer understanding of what is going on in the mind/body system, what you can do to reduce suffering when pain persists and ways to prevent chronic ongoing pain from developing. It is a key event if you work with people suffering from pain at any stage (from recent onset, recurrent to persistent) or if you would like to find out how to successfully manage pain without medication. You will learn a wide variety of pain management techniques, which can easily be integrated into your work, to help relieve pain and promote recovery – often in just one session. Dr Grahame Brown has a real gift for helping people heal themselves – I know: I’m one of them!CHRISTOPHER BUCKLEY, PROFESSOR OF RHEUMATOLOGY, UNIVERSITY OF BIRMINGHAM What will you learn An increased understanding of how we perceive pain (from the latest neuroscientific research) and what is happening in the mind/body system A road map for helping people out of the vicious cycle of chronic pain, or to stop it developing in the first place The confidence and skills to help patients suffering from persistent pain of whatever cause – no need to feel ‘heart-sink’ with some patients anymore An understanding of what is going on when pain persists – and what you can do about it How to reduce the risk of chronic pain developing – prevention is better than cure – and identify the factors that make it likely A range of psychological chronic pain management techniques to use with your patients or yourself The importance of the bio-psycho-social model in reducing pain and accelerating healing How to produce significant pain relief by changing the way people think about their pain – in minutes An understanding of the value of pain displacement and how to use the brain’s ‘reality simulator’ What the latest neuroscience tell us about the experience of pain How to use guided imagery, relaxation and distraction to promote chronic pain relief How to deal with constant pain and promote healing How healthcare professionals can make their consultations more therapeutic How to avoid labelling patients’ pain as ‘purely psychological’ The many myths about pain – and why some well-intentioned pain management techniques don’t work and more… No prior medical knowledge is needed for you to benefit from the day. Course Programme The ‘Effective Pain Management’ live online course starts at 9.15am and runs until 4.00pm. (GMT). 9.15am Join the Zoom meeting 9.30am Understanding pain 11.00am Comfort break and discussion 11.30am Assessing a person with persistent pain 1.00pm Lunch break 1.45pm Psychological & Behavioural treatment interventions 2.45pm Comfort break and discussion 3.00pm Practical demonstration of interventions 4.00pm Day ends Who is this course suitable for? This course is designed to enhance the skills and knowledge of health care professionals of any discipline who work on a regular or occasional basis with people in pain to improve outcomes, including: • doctors • surgeons • nurses • dentists • neurologists • osteopaths • chiropractors • palliative care workers • psychiatrists • midwives • physiotherapists • occupational therapists • psychologists • health visitors • support/care workers • psychotherapists • counsellors – it is perfect CPD If you personally experience persistent pain then you will gain much from the workshop but please be aware the programme is not designed to be a treatment day and the tutor will be unable to give opinions to individuals with pain problems unless (with consent) their problem can be discussed for the benefit of all participants Anyone who would like to understand more about their own experience of pain, or that of someone they care for, and what can be done to manage ongoing pain and alleviate suffering This course has been independently assessed by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.
Why choose SketchUp Basic to Intermediate Training Course? Click for more info SketchUp offers a user-friendly experience with its intuitive interface, enabling beginners to start smoothly and professionals to work efficiently. The software provides straightforward tools and shortcuts, ensuring precise and speedy creation of 3D models. Duration: 5 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm SketchUp is a popular and robust CAD solution designed for engineers, designers, architects, and more. Its powerful suite of tools includes customizable palettes, lighting effects, animations, textures, and access to the Trimble 3D warehouse. SketchUp Basic Training Course. 1 on 1 Training. 5 hours Understanding the Basics of SketchUpIntroduction to SketchUpNavigating the SketchUp EnvironmentExploring Zoom, Pan, and Rotate FunctionsFamiliarizing Yourself with the XYZ Axis Mastering SketchUp ToolsEfficient Toolbar SelectionsUtilizing Templates for ProjectsDrawing with Precision Using the Pencil ToolWorking with Fundamental Geometric ShapesTaking Accurate Measurements Advanced SketchUp TechniquesCreating Circles and ArcsHarnessing Sticky Geometry SolutionsUnveiling the Power of Tags (Formerly Layers)Streamlining Workflow with Keyboard ShortcutsAccurate Object Measurement within SketchUpInformation Management and Database UsageMoving and Copying ObjectsSimple Array TechniquesMastering Rotational ManipulationsEffortless Rotational CopyingFractional and Relative Scaling Component and Group CreationConstructing Components for ReusabilityCreating Efficient GroupsComparing the Advantages of Components and GroupsSaving and Reusing ComponentsImporting Components from Digital Repositories Advanced Modeling and GeometryLeveraging Push-Pull OperationsCreating Complex Shapes with the Follow Me ToolExploring Geometry IntersectionsDuplicating and Offsetting Faces, Edges, and PolygonsIncorporating 2D Polygons into Your DrawingsSkillful Use of the Paint Bucket Tool Materials and TexturesProficiency with the Materials EditorApplying High-Quality TexturesSourcing and Positioning TexturesGraphics and Bitmap ConsiderationsCrafting Scenes and StylesGenerating and Customizing ScenesManaging Scenes and Styles Introduction to Animation and PresentationAnimation ConceptsAdding Dimensions to Your SketchUp ModelsAnnotating Designs for ClarityPreparing Models for PrintingExporting Images and PDFs in 2D Formats
Designed for professional B2B salespeople to develop a modern approach to winning business
This comprehensive course covers all Scrum principles and frameworks necessary to help participants understand how to guide a team and manage projects in a fast-paced agile environment. The course is meant for professionals who want to attain the certification of Scrum Master with deep insight into how AI can be utilized in increasing the effectiveness of agile practices. In addition to mastery of the core Scrum methodology, participants will be taken through state-of-the-art advancements in AI and machine learning in order to understand how these technologies can automate routine tasks, enhance decision-making, and continuous improvement. Real-world case studies and hands-on exercises will illustrate how to practically apply AI within Scrum to realize high efficiency and innovation for teams. Whether for enhancing one's career as a Scrum Master or the integration of AI into Agile practices, this course provides that ideal combination of conceptual theory and practical skills, assuring success in today's technology-driven world. Key Highlights: Certified Scrum Master training with AI applications Case studies in the real world about integrating AI in Scrum Hands-on projects to implement AI-driven tools and methodologies Workflow optimization techniques that ensure better collaboration of agile teams, with speeding up project delivery by the power of AI. Ideal for Scrum Masters, Agile Coaches, Product Owners, and tech pros looking to stay ahead.
This course is very much a discussion, so be prepared to present and critically analyse your own and class mates work. You will also need to bring a few examples of work you have done in the past. Learning and applying best practice visualisation principles will improve effective discussions amongst decision makers throughout your organisation. As a result more end-users of your dashboards will be able to make better decisions, more quickly. This 2 Day training course is aimed at analysts with good working knowledge of BI tools (we use Tableau to present, but attendees can use their own software such as Power BI or Qlik Sense). It is a great preparation for taking advanced certifications, such as Tableau Certified Professional. Contact us to discuss the Visual Analytics Best Practice course Email us if you are interested in an on-site course, or would be interested in different dates and locations This Tableau Desktop training intermediate course is designed for the professional who has a solid foundation with Tableau and is looking to take it to the next level. Attendees should have a good understanding of the fundamental concepts of building Tableau worksheets and dashboards typically achieved from having attended our Tableau Desktop Foundation Course. At the end of this course you will be able to communicate insights more effectively, enabling your organisation to make better decisions, quickly. The Tableau Desktop Analyst training course is aimed at people who are used to working with MS Excel or other Business Intelligence tools and who have preferably been using Tableau already for basic reporting. The course includes the following topics: WHAT IS VISUAL ANALYSIS? Visual Analytics Visual Analytics Process Advantages of Visual Analysis Exercise: Interpreting Visualisations HOW DO WE PROCESS VISUAL INFORMATION? Memory and Processing Types Exercise: Identifying Types of Processing Cognitive Load Exercise: Analysing Cognitive Load Focus and Guide the Viewer Remove Visual Distractions Organise Information into Chunks Design for Proximity Exercise: Reducing Cognitive Load SENSORY MEMORY Pre-attentive Attributes Quantitatively-Perceived Attributes Categorically-Perceived Attributes Exercise: Analysing Pre-attentive Attributes Form & Attributes Exercise: Using Form Effectively Colour & Attributes Exercise: Using Colour Effectively Position & Attributes Exercise: Using Position Effectively ENSURING VISUAL INTEGRITY Informing without Misleading Gestalt Principles Visual Area Axis & Scale Colour Detail Exercise: Informing without Misleading CHOOSING THE RIGHT VISUALISATION Comparing and Ranking Categories Comparing Measures Comparing Parts to Whole Viewing Data Over Time Charts Types for Mapping Viewing Correlation Viewing Distributions Viewing Specific Values DASHBOARDS AND STORIES Exercise: Picking the Chart Type Exercise: Brainstorming Visual Best Practice Development Process for Dashboards and Stories Plan the Visualisation Create the Visualisation Test the Visualisation Exercise: Designing Dashboards and Stories This training course includes over 20 hands-on exercises to help participants “learn by doing” and to assist group discussions around real-life use cases. Each attendee receives an extensive training manual which covers the theory, practical applications and use cases, exercises and solutions together with a USB with all the materials required for the training. The course starts at 09:30 on the first day and ends at 17:00. On the second day the course starts at 09:00 and ends at 17:00. Students must bring their own laptop with an active version of Tableau Desktop 10.5 (or later) pre-installed. What People Are Saying About This Course "Steve was willing to address questions arising from his content in a full and understandable way"Lisa L. "Really enjoyed the course and feel the subject and the way it was taught was very close to my needs"James G. "The course tutor Steve was incredibly helpful and taught the information very well while making the two days very enjoyable."Bradd P. "The host and his courses will give you the tools and confidence that you need to be comfortable with Tableau."Jack S. "Steve was fantastic with his knowledge and knowhow about the product. Where possible he made sure you could put demonstrations in to working practice, to give the audience a clear understanding."Tim H. "This was a very interesting and helpful course, which will definitely help me produce smarter, cleaner visualisations that will deliver more data-driven insights within our business."Richard A. "Steve is very open to questions and will go out of his way to answer any query. Thank you"Wasif N. "Steve was willing to address questions arising from his content in a full and understandable way"Lisa L. "Really enjoyed the course and feel the subject and the way it was taught was very close to my needs"James G.
This Tableau Desktop Training intermediate course is designed for the professional who has a solid foundation with Tableau and is looking to take it to the next level. For Private options, online or in-person, please send us details of your requirements: This Tableau Desktop training intermediate course is designed for the professional who has a solid foundation with Tableau and is looking to take it to the next level. Attendees should have a good understanding of the fundamental concepts of building Tableau worksheets and dashboards typically achieved from having attended our Tableau Desktop Foundation Course. At the end of this course you will be able to communicate insights more effectively, enabling your organisation to make better decisions, quickly. The Tableau Desktop Analyst training course is aimed at people who are used to working with MS Excel or other Business Intelligence tools and who have preferably been using Tableau already for basic reporting. The course is split into 3 phases and 9 modules: Phase 1: AMPLIFY MODULE 1: CHECK ABILITIES Revision – What I Should Know What is possibleHow does Tableau deal with dataKnow your way aroundHow do we format chartsHow Tableau deals with datesCharts that compare multiple measuresCreating Tables MODULE 2: COMBINE DATA Relationships Joining Tables – Join Types, Joining tables within the same database, cross database joins, join calculations Blending – How to create a blend with common fields, Custom defined Field relationships and mismatched element names, Calculated fields in blended data sources Unions – Manual Unions and mismatched columns, Wildcard unions Data Extracts – Creating & Editing Data extracts MODULE 3: ADVANCED CALCULATIONS Row Level v Aggregations Aggregating dimensions in calculations Changing the Level of Detail (LOD) of calculations – What, Why, How Adding Table Calculations Phase 2: ANALYSE MODULE 4: EXPAND APPLICATION Making things dynamic with parameters Sets Trend Lines How do we format charts Forecasting MODULE 5: ADVANCED MAPPING Using your own images for spatial analysis Mapping with Spatial files MODULE 6: DATA COMPARISONS Advanced Charts Bar in Bar charts Bullet graphs Creating Bins and Histograms Creating a Box & Whisker plot Phase 3: ACT MODULE 7: ADVANCED DASHBOARDS Using the dashboard interface and Device layout Dashboard Actions and Viz In tooltips Horizontal & Vertical containers Navigate between dashboards MODULE 8: PRESENT STORIES Telling data driven stories MODULE 9: ENABLE DECISIONS What is Tableau Server Publishing & Permissions How can your users engage with content This training course includes over 25 hands-on exercises and quizzes to help participants “learn by doing” and to assist group discussions around real-life use cases. Each attendee receives a login to our extensive training portal which covers the theory, practical applications and use cases, exercises, solutions and quizzes in both written and video format. Students must bring their own laptop with an active version of Tableau Desktop 2018.2 (or later) pre-installed. What People Are Saying About This Course “Course was fantastic, and completely relevant to the work I am doing with Tableau. I particularly liked Steve’s method of teaching and how he applied the course material to ‘real-life’ use-cases.”Richard W., Dashboard Consulting Ltd “This course was extremely useful and excellent value. It helped me formalise my learning and I have taken a lot of useful tips away which will help me in everyday work.” Lauren M., Baillie Gifford “I would definitely recommend taking this course if you have a working knowledge of Tableau. Even the little tips Steve explains will make using Tableau a lot easier. Looking forward to putting what I’ve learned into practice.”Aron F., Grove & Dean “Steve is an excellent teacher and has a vast knowledge of Tableau. I learned a huge amount over the two days that I can immediately apply at work.”John B., Mporium “Steve not only provided a comprehensive explanation of the content of the course, but also allowed time for discussing particular business issues that participants may be facing. That was really useful as part of my learning process.”Juan C., Financial Conduct Authority “Course was fantastic, and completely relevant to the work I am doing with Tableau. I particularly liked Steve’s method of teaching and how he applied the course material to ‘real-life’ use-cases.”Richard W., Dashboard Consulting Ltd “This course was extremely useful and excellent value. It helped me formalise my learning and I have taken a lot of useful tips away which will help me in everyday work.” Lauren M., Baillie Gifford “I would definitely recommend taking this course if you have a working knowledge of Tableau. Even the little tips Steve explains will make using Tableau a lot easier. Looking forward to putting what I’ve learned into practice.”Aron F., Grove & Dean “Steve is an excellent teacher and has a vast knowledge of Tableau. I learned a huge amount over the two days that I can immediately apply at work.”John B., Mporium
Duration 4 Days 24 CPD hours This course is intended for This course is designed for network and software engineers and hold job roles such as: Network administrator Network engineer Network manager System engineer Project manager Network designer Overview After taking this course, you should be able to: Describe mobile network architecture basics List enabling technologies for 5G and describe 5G key use cases Perform basic operations on a Cisco 5G NSA mobile packet core Describe the Cisco 5G Converged SDN Transport Architecture Describe Cisco NFVI and perform basic operations using Cisco ESC and Cisco Virtualized Infrastructure Manager (VIM) Describe Cisco service provider automation and orchestration solutions to deploy and manage 5G network functions Describe the Cisco Ultra Cloud Core architecture and deploy the Cisco SMI Explain the 5G ready distributed Telco DC with Cisco ACI solution Describe the Cisco 5G security architecture The Cisco Service Provider 5G Technologies Foundations (SPMBL100) v1.0 course introduces mobile network components, basic 5G concepts, and features of 5G technology including faster data speeds, higher device capacity, and improved user experience. You will examine the mobile packet core solutions, 5G transport architecture, and Cisco© automation and orchestration tools used in 5G networks. You will also learn about the Cisco 5G Non-standalone (NSA) and the Cisco Ultra Cloud Core 5G standalone (SA) platform solutions, the Cisco 5G converged Software-Defined Networking (SDN) transport architecture, and Cisco edge computing solutions. You will study the Cisco Network Function Virtualization (NFVI) architecture, Cisco Network Services Orchestrator (NSO), and Cisco Elastic Services Controller (ESC). You will learn how 5G is distributed with Telco Data Center (DC) with Cisco Application Centric Infrastructure (Cisco ACI©). And finally, Zero-Touch Provisioning (ZTP), Cisco Crosswork?, and the Cisco 5G security architecture will also be presented. Mobile Network Fundamentals 5G Key Use Cases Examining Mobile Network Components Enabling Technologies for 5G Introduction to 5G NR Characteristics Cloud Radio Access network (RAN) Cisco 5G NSA Solution 5G NSA Basics 5G NSA StarOS Configurations Cisco 5G Converged SDN Transport Architecture Cisco 5G Transport Ready Devices Application Awareness and Network Slicing with Segment Routing Cisco NFV Infrastructure, Cisco Virtualized Network Functions (VNFs), Cisco VIM, and Cisco ESC NFVI and SDN Architecture Overview Cisco VIM Pod Configurations Cisco Service Provider Automation and Orchestration Telemetry Basics ZTP Fundamentals Cisco Ultra Cloud Core Cisco Ultra Cloud Core Basics Kubernetes and Docker Fundamentals 5G Ready Distributed DC with Cisco ACI Cisco ACI in Telco Data Centers 5GC Deployment Mitigating Threats in 5G Introduction to 5G Cybersecurity Risks Mitigating 5G Cybersecurity Risks
This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 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 11 Pivot tables Create a pivot table report Insert a pivot chart into a report