3402 Courses

Description: This Microsoft Office 2007 Excel Advanced - Complete Video Course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager and subtotals. Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts and record basic macros. You will also learn to use key advanced financial, logical, text, statistical and math, and lookup functions, audit formulas for errors, analyze data using subtotals, goal seek and the scenario manager, use custom and conditional formatting, manage data with tables, filtering and sorting, create, edit and format PivotTables and PivotCharts, import and export date to and from a workbook, create and use macros. So, by taking this course you will have a complete understanding of the higher functions of Excel. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2007 Excel Advanced - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2007 Excel Advanced - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Advanced Functions Logical Functions FREE 00:08:00 Math and Statistical Functions 00:06:00 Financial Functions 00:03:00 Displaying and Printing Formulas 00:02:00 Lookups and Data Tables Using Lookup Functions 00:03:00 Using MATCH and INDEX 00:01:00 Creating Data Tables 00:03:00 Advanced List Management Validating Cell Entries 00:01:00 Exploring Database Functions 00:01:00 PivotTables and PivotCharts Working with PivotTables 00:04:00 Rearranging PivotTables 00:02:00 Formatting PivotTables 00:02:00 PivotCharts 00:01:00 Exporting and Importing Exporting and Importing Text Files 00:07:00 Exporting and Importing XML Data 00:02:00 Querying External Databases 00:03:00 Analytical Options Goal Seek and Solver 00:05:00 The Analysis ToolPak 00:01:00 Scenarios 00:02:00 Views 00:01:00 Macros and Custom Functions Running and Recording a Macro 00:02:00 Working with VBA Code 00:01:00 Creating Functions 00:05:00 Conditional Formatting and SmartArt Conditional Formatting with Graphics 00:03:00 SmartArt Graphics 00:02:00 Mock Exam Mock Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Final Exam Final Exam- Microsoft Office 2007 Excel Advanced - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Definitive Ethernet switching course description A hands on comprehensive look at Ethernet switches with extensive coverage of VLANs. The course focuses on the technology and not any one manufacturers product enabling delegates to configure switches from any manufacturer. What will you learn Configure and troubleshoot switches using: Console port telnet HTTP TFTP Configure and troubleshoot switch features such as: Duplex/speed Port based MAC security Spanning Tree Link aggregation Tagged ports Configure and troubleshoot VLANs. Definitive Ethernet switching course details Who will benefit: Technical staff. Prerequisites: Intro to data communications & networking. Duration 3 days Definitive Ethernet switching course contents What is Ethernet? LANs, network cards and cables, CSMA/CD, Ethernet frames, Ethernet evolution, 802.3. Hands on: ping, Ethernet speeds, CSMA/CD. Ethernet layer 2 Layer 2 functions, NICs, MAC addresses, unicasts, multicasts and broadcasts, frame formats. Hands on: Configuring NICs, Analysing MAC addresses with Wireshark IP and Ethernet Relationship Hands on: ARP. What is a switch? Switches connect multiple devices, switches versus hubs, simultaneous conversations, switches work at layer 2, the forwarding database, how the forwarding database is built, broadcast and collision domains Hands on: Difference between hubs and switches. Switch configuration Switch configuration Managed/unmanaged switches, configuration methods, reasons to configure switches. Console ports, HyperTerminal (and alternatives). Hands on: Using the console port to troubleshoot and configure switches. Switches in more detail Latency, forwarding mechanisms, switch fabrics. Hands on: Using telnet and HTTP to switches. Ethernet extensions Auto negotiation, Power over Ethernet. Hands on:Configuring and troubleshooting switch ports: Speed, duplex and security. Redundant links Loops, broadcast storms, STP, BPDU format, STP convergence. Hands on: Tracking blocked ports. STP convergence. Backbone links Architectures, link aggregation, LACP, load sharing, resilience. Hands on: fail over times. VLANs Virtual versus physical LANs, Why have VLANs? Broadcast domains, Creating VLANs, Assigning ports to VLANs. Hands on: Analysing the effect of VLANs on traffic. Enterprise VLANs VLANS are internal, multiple VLANs, Load balancing, Default VLAN, VLAN registration protocols: VTP, GVRP, MVRP. Hands on: VLANs on multiple switches. Tagging/Trunking Reason for tagging, terminology, tagging process, 802.1Q, Tag format, VLAN stacking. Hands on: Configuring and troubleshooting tags. STP variants RSTP, Common STP, Multiple STP, PVST, ring alternatives. Hands on: RSTP. Inter VLANs Layer 3 switching, IP addressing rules, Interconnecting VLANs. Hands on: Routing between VLANs. Troubleshooting Ethernet Methods, tools, locating faults, layer 1 issues, layer 2 issues Hands on: Fixing the network.

SIP in IMS training course description The IP Multimedia Core Network Subsystem (IMS) is defined by 3GPP as a new mobile infrastructure. This advanced course looks at the use of SIP in the IMS. What will you learn Describe the role of SIP in the IMS. Explain how SIP works in the IMS Describe the SIP architecture in the IMS. Explain how SIP and SDP are used in basic IMS procedures. SIP in IMS training course details Who will benefit: Technical telecommunications staff. Prerequisites: SIP for engineers. Duration 2 days SIP in IMS training course contents Introduction SIP review, SIP elements, Simple SIP call flow, What is IMS? Why IMS? Why SIP in the IMS? SIP and IMS relationship. Standards 3GPP, IETF, 3GPPr5, 3GPPr6, 3GPP SIP extensions. SIP and IMS IMS architecture, SIP interfaces. Server functions Registration, home and away, location and directory services, stateful and stateless servers. SIP servers P-CSCF, I-CSCF, S-CSCF, PSTN gateways SIP registration in the IMS SIP REGISTER, IMS identities, registration process, P-CSCF discovery, S-CSCF assignment, IMS subscriber and IMS registrar signalling flow. IMS routing in the registration process. Re and De-registration. SIP sessions in the IMS SIP INVITE, Establishing IMS SIP sessions, User at home network, user roaming, IMS offer answer architecture, SIP preconditions, QoS, reserving resources, IMS bearer network interactions, IMS subscriber and IMS service signalling flow. Typical call flows. SIP services in the IMS IMS specifications, IMS service procedures, call scenarios, call services. IMS multimedia related procedures. IMS presence, IMS messaging, IMS conferencing, IMS PoC. SIP-T SIP and the PSTN, URIs and ENUM, NAPTR, SRV, ISUP numbers and URI mapping, IAM and INVITE, SIP to PSTN/ISUP mapping, PSTN/ISUP to SIP mapping, PSTN to PSTN over SIP. MIME media types for ISUP, DTMF transmission, CLIP and CLIR in SIP, ring tone, split gateways SIP-I ISO standards, translation versus tunnelling. IMS SIP extensions Security (RFC 3310, 3329), Resource reservation (RFC 3312), Media authorisation (RFC 3313), SigComp (RFC 3320), P Headers (RFC 3325, 3455), Mobile registration (RFC 3327, 3608), Reg event (RFC 3680), Preconditions (RFC 4032) Security IMS security architecture, identities, HTTP digest, TLS. Affect of security on SIP media sessions.

Learn to use Excel’s most powerful features on this 2-day advanced Excel training course. This course is hands-on. It includes plenty of time to experiment with what you are being taught and ask questions. By the time you finish, you’ll be an expert Excel user.  ✔ A complete course that covers all of Excel’s most advanced functions.  ✔ Friendly expert trainers, small groups and a comfortable place to learn.  ✔ Ongoing support & help with any issues you may have after the course. Our courses are delivered in Guildford, London, Online, or even on-site at your offices!

You do not need any lectures regarding the importance of Maths and English, do you? To suffice, one is the language of science, and the other is the international language. Unfortunately, we often struggle in both, thanks to the lack of a solid base. Our Learning Maths & English GCSE bundle can give you a firm foundation or help you to pass your GCSE exam with flying colours! This Learning Maths & English GCSE bundle consists of 12 individual courses. This bundle can be primarily divided into two parts. The first part, consisting of six courses, covers fundamentals and advanced mathematics. You will learn the basic concepts of Algebra, high school maths, as well as advanced maths and calculus. The other six courses deal with English language essentials. You will gain an understanding of GCSE English, TESOL, spelling, punctuation, and basics of grammar etc. Moreover, you will learn 200 common English idioms and phrases along with essay writing in English. Be the master of numbers and letters, then? Enrol immediately in this Learning Maths & English GCSE and firm your base. Happy learning! Along with this Learning Maths & English GCSE Course - CPD Accredited course, you will get 11 premium courses, an originalhardcopy, 12 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Learning Maths & English GCSE Course - CPD Accredited Bundle Consists of the following Premium courses: Course 01: Functional Skills Maths Level 2 Course 02: Mathematics Fundamentals Course 03: Algebra Fundamentals Course 04: Calculus Level 1 - Learn Differentiation Course 05: Advanced Mathematics Course 06: High School Math Course 07: GCSE English Course 08: Diploma in TEFL/TESOL Course 09: Functional Skills: English Course 10: English Spelling, Punctuation, and Grammar Basic Course Course 11: 200 Common English Idioms and Phrases Course 12: Essay Writing in English Learning Outcome Upon completion of this Learning Maths & English GCSE bundle, you will be able to - Learn about major mathematical concepts such as Decimal numbers, Rational Numbers, Approximation etc Understand the BODMAS Simplification Rule Consolidate your understanding of fundamental mathematics Learn differential calculus Understand advanced mathematical ideas such as Matrices, Trigonometric Functions and Trigonometric Functions Comprehend the rudiments of English Grasp sentence structure, verb usage, capitalisation and punctuation rules in detail Learn 200 common English idioms and phrases Enrol now in Learning Maths & English GCSE Course - CPD Accredited to advance your career, and use the premium study materials from Apex Learning. Curriculum of the Bundle Course 01: Functional Skills Maths Level 2 Module 1: Numbers and Negative Numbers Module 2: Multiples Factors Module 3: Fractions and Power Module 4: Percentages Module 5: Expressions Module 6: Decimals Module 7: Ratio and Proportion Module 8: Exponents and Radicals Module 9: Graphs Module 10: The Profit and Loss Module 11: Perimeter and Area Module 12: Averages Module 13: Probability Course 02: Mathematics Fundamentals Integers (Directed Numbers) Factors and Multiples Fractions Simplification Rule : BODMAS Decimal numbers Rational Numbers Approximation Estimation and Scientific Notation or Standard form Percentage Ratio and Proportion Unitary Method and its Applications Profit , Loss, discount and Tax Course 03: Algebra Fundamentals Introduction Fundamental concepts on Algebraic Expressions Operations on Algebraic Expressions Indices ( Exponents) Multiplication and Division of Algebraic expressions Brackets in Algebra Linear equations in one variable Algebraic Identities Formula : Change of subject of formula Linear Inequalities Resolve into factors Algebraic Fractions Coordinate axis - points and Line graph System of simultaneous linear equations in two variables Polynomials Quadratic Polynomials Quadratic Equations Course 04: Calculus Level 1 - Learn Differentiation Section 01: Introduction Section 02: Fundamental Rules for Differentiation Section 03: Differentiation of Trigonometric Functions Section 04: Differentiation of Exponential Functions Section 05: Differentiation of Logarithmic Functions Section 06: Revision Section 0on Chain Rule Section 07: Differentiation of inverse Trig Function Section 08: Differentiation of Hyperbolic Trig Functions Section 09: Differentiation of Implicit functions Section 10: Logarithmic Differentiation Section 11: Differentiation of Parametric Functions Section 12: Differentiation of Higher order derivatives Course 05: Advanced Mathematics Unit 01: Introduction Unit 02: Mathematical Logic Unit 03: Matrices Unit 04: Trigonometric Functions Unit 05: Pair of Straight Line Unit 06: Lines & Planes Unit 07: Linear Programming Course 06: High School Math Introduction Functions Quadratic Equations Co-ordinate Geometry Sequence and series Binomial Theorem Differentiation Tangents and Normals Stationary Points & Curve Sketching Second Derivative Test (Maximum & Minimum Points) Simultaneous Linear equations Essential Revision Course 07: GCSE English Module 01: Introduction to GCSE English Module 02: Edexcel English Section A Part 01 Module 03: Edexcel English Section A Part 02 Module 04: Edexcel English Section B Module 05: Edexcel English Section C Module 06: Cambridge English Exercise 1-4 Module 07: Cambridge English Exercise 5 Module 08: Cambridge English Exercise 6 Course 08: Diploma in TEFL/TESOL Module 01: Introduction to English Language Teaching & Learning Module 02: Linguistics Module 03: English Pronunciation Module 04: Teaching Grammar and Vocabulary Module 05: Language Teaching Methodologies Module 06: Teaching Receptive Skills: Reading Module 07: Teaching Productive Skills: Writing Module 08: Teaching Receptive Skills: Listening Module 09: Teaching Productive Skills: Speaking Module 10: Lesson Planning and Creating Materials Module 11: Use of Games and Activities Module 12: Technology in Second Language Teaching & Learning Module 13: Classroom Management and Student Motivation Module 14: Teaching English: Situational Approach Module 15: Professional Development and Employment Course 09: Functional Skills: English Module 1: Introduction to the Course Module 2: Basics of Grammar Module 3: The Basics of Sentence Module 4: Structure of Sentence Module 5: Question Module 6: Punctuation & Capitalisation Module 7: Spelling Module 8: Common Mistakes & Ways to Improve Course 10: English Spelling, Punctuation, and Grammar Basic Course Module 1: Introduction to the Course Module 2: The Basics of Grammar Module 3: The Basics of Sentence Module 4: Structure of Sentence Module 5: Question Module 6: Punctuation and Capitalisation Module 7: Spelling Module 8: Common Mistakes & Ways to Improve Course 11: 200 Common English Idioms and Phrases Section 01: Introduction Section 02: Idioms and Phrases Unit 1 Section 03: Idioms and Phrases Unit 2 Section 04: Idioms and Phrases Unit 3 Section 05: Idioms and Phrases Unit 4 Section 06: Idioms and Phrases Unit 5 Section 07: Idioms and Phrases Unit 6 Section 08: Idioms and Phrases Unit 7 Section 09: Idioms and Phrases Unit 8 Section 10: Idioms and Phrases Unit 9 Section 11: Idioms and Phrases Unit 10 Course 12: 200 Common English Idioms and Phrases Module 01: Introduction Module 02: The Narrative Essay Module 03: The Narrative Essay / part 2 Module 04: Introduction to the Essay 'Shooting an Elephant' Module 05: A reading of 'Shooting an Elephant' Module 06: Discussion on 'Shooting an Elephant' Module 07: Introduction to 2nd Essay - 'Most Important Day' Module 08: A reading - 'Most Important Day' Module 09: Discussion - 'Most Important Day' Module 10: Prompt for your own Narrative Essay CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Learning Maths & English GCSE Course - CPD Accredited bundle. Requirements This Learning Maths & English GCSE Course - CPD Accredited course has been designed to be fully compatible with tablets and smartphones. Career path Building a solid foundation in maths and English will benefit you in every career prospect. Specifically, This Learning Maths & English GCSE course will lead you to some particular career opportunities, such as; Teacher - £30,000 - £41,000 Annually Private Tutor - £20,00 - £25.00 Annually Finance Manager - £50,000 - £60,000 Annually Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Functional Skills Maths Level 2) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

LTE Architecture and Protocols course description This course provides a comprehensive tour of the LTE architecture along with services provided and the protocols used. What will you learn Describe the overall architecture of LTE. Explain the information flows through LTE. Describe the LTE security. Describe LTE mobility management. Recognise the next steps for LTE. LTE Architecture and Protocols course details Who will benefit: Anyone working with LTE. Prerequisites: Mobile communications demystified Duration 3 days LTE Architecture and Protocols course contents Introduction History, LTE key features. The 4G ITU process. The LTE 3GPP specifications. Specifications. System Architecture LTE hardware architecture. UE architecture and capabilities. E-UTRAN and eNB. EPC, MME functions, SGW, PGW and PCRF. System interfaces and protocol stacks. Example information flows. Dedicated and default bearers. EMM, ECM, RRC state diagrams. Radio transmission and reception OFDMA, SC-FDMA, MIMO antennas. Air interface protocol stack. Logical, transport and physical channels. Frame and slot structure, the resource grid. Resource element mapping of the physical channels and signals. Cell acquisition, data transmission and random access. MAC, RLC, PDCP protocols. LTE spectrum allocation. Power-on procedures Network and cell selection. RRC connection establishment. Attach procedure, including IP address allocation and default bearer activation. LTE detach procedure. Security in LTE networks LTE security features, identity confidentiality, ciphering and integrity protection. Architecture of network access security in LTE. Secure key hierarchy. Authentication and key agreement procedure. Security mode command procedure. Network domain security architecture. Security associations using IKE and IPSec. Mobility management RRC_IDLE, RRC_CONNECTED. Cell reselection, tracking area updates. Measurement reporting. X2 and S1 based handovers. Interoperation with UMTS, GSM and non-3GPP technologies such as cdma2000. QoS, policy control and charging QoS in LTE, EPS bearers, service data flows and packet flows. The architecture and signalling procedures for policy and charging control. Data transport using GPRS, differentiated services and MPLS. Offline and online charging in LTE. Delivery of voice and text messages over LTE Difficulties and solutions for Voice over LTE. Architecture and call setup procedures for circuit switched fallback. Architecture, protocols and call setup procedures in IP multimedia subsystem. Enhancements in release 9 LTE location services. Multimedia broadcast / multicast service and MBSFN. Cell selection, commercial mobile alert service. LTE Advanced and release 10 Impact of carrier aggregation on LTE air interface. Enhanced MIMO processing on uplink and downlink. Relaying. Release 11 and beyond. OAM and self organising networks Operation, administration, maintenance and provisioning for LTE. Self-configuration of base station parameters. Fractional frequency re-use, inter-cell interference co-ordination. Self-optimisation of base station procedures. Self-healing to detect and recover from faults.

This hands-on course on SQL starts with the basics, and gradually delves deep into SQL, ensuring a well-rounded learning experience. Practical examples and real-world applications will be at the heart of your learning. No prior experience or specific software installation is necessary. Just bring your enthusiasm to learn and get started.

NPORS Marine Knuckle Boom Crane (N014)

Microsoft Excel for Beginners Course Are you seeking to boost your career potential by acquiring practical knowledge in one of the most indispensable tools in modern business - Microsoft Excel? Or perhaps you are a student aiming to supplement your educational endeavors with this ubiquitous software? Then you've landed on the right course. Our Microsoft Excel for Beginners Certificate Course is designed to introduce learners to the essential functions and features of Excel, starting from the basics. This comprehensive online course offers step-by-step instructions on how to create, navigate, and manage worksheets and workbooks effectively. You'll embark on a journey from understanding the Excel interface, all the way to manipulating datasets and performing complex calculations with ease. Whether it's data sorting, cell formatting, creating tables, or crafting detailed charts, you'll learn how to do it all. You'll also become adept at employing powerful Excel functions and formulas, opening doors to seamless data analysis and interpretation. Course Highlights: Foundational Excel Knowledge: Familiarize yourself with Excel's interface, and learn how to create and manipulate worksheets and workbooks. Formatting and Styles: Learn how to use Excel's rich formatting options to emphasize and clarify your data. Tables and Data Features: Master the art of sorting and filtering data, as well as creating and formatting tables. Charts and Graphics: Acquire the skills to create visually appealing charts and graphics that communicate your data effectively. Functions and Formulas: Delve into the core functions and formulas, including VLOOKUP, SUM, AVERAGE, and more. Data Analysis: Discover the power of Excel's data analysis tools, and learn how to use them to derive meaningful insights from your data. Real-world Application Scenarios: Engage with interactive exercises and projects that reinforce your learning and allow you to practice your skills in realistic settings. This course is designed for absolute beginners, so no previous experience with Excel is required. Upon completion of the course, you'll receive a certificate to showcase your newfound proficiency. Furthermore, the course is self-paced and accessible 24/7, so you can learn at a time and pace that suits you best. Unlock your potential today with our Microsoft Excel for Beginners Certificate Course. Empower yourself with valuable skills that will serve you in any professional setting.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that 97% of UK businesses use Microsoft Office? Mastering Microsoft Word is a valuable skill for almost any job role. Do you struggle with formatting documents, creating professional layouts, or using mail merge? This comprehensive Complete Microsoft Word bundle can help! This complete Microsoft Word bundle offers a variety of courses designed to take you from beginner to expert. Learn the fundamentals of creating, editing, and formatting documents. Discover advanced features like tables, mail merge, macros, and more. Beyond Word, the bundle includes additional courses on Excel, PowerPoint, Microsoft Teams, and Outlook, giving you a well-rounded skillset for office productivity. Our Microsoft Office Bundle Course contains 10 of our popular courses for one discounted price: Course 01: Learn Microsoft Word, PowerPoint & Outlook Course 02: Complete Microsoft Word Course 03: Microsoft Excel Complete Course Course 04: PowerPoint Course 05: The Ultimate Microsoft Teams Complete Training Bundle (2020) Course 06: Microsoft Outlook Advanced Course Course 07: Excel Training: Depreciation Accounting Course 08: Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Learn from relevant industry professionals and quickly equip yourself with the specific knowledge and skills needed to excel in your chosen career through the Microsoft Office bundle training. Expand your expertise with high-quality training - study the Microsoft Office course and get an expertly designed training experience. Learning Outcomes of Complete Microsoft Word Create professional documents with effective formatting. Utilise tables, charts, and graphics to enhance communication. Automate tasks with formulas and macros (Excel). Collaborate seamlessly with colleagues using Microsoft Teams. Manage emails efficiently with advanced Outlook features. Develop presentations that engage and inform your audience (PowerPoint). You'll get a Free Student ID card by enrolling in this Bundle course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. Enrolling on the Bundle will ensure that you land your dream career faster than you thought possible. Stand out from the crowd and train for the job you want with the Bundle Course. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Microsoft Word Get a free student ID card with Microsoft Word Training program (£10 postal charge will be applicable for international delivery) The Microsoft Word is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Microsoft Word course materials The Microsoft Word comes with 24/7 tutor support Start your learning journey straight away with this Bundle course and take a step toward a brighter future! ****Course Curriculum**** Course 01: Learn Microsoft Word, PowerPoint & Outlook Microsoft Word Essentials New Word Document and Templates Tabs, Ribbons and Groups Zoom and Rulers in Word Editing the Word Document Insert Pictures with Word Insert Shape and Text Box in Word Review Tab in Word Layout in Word File Options in Word Closing and Reopening in Word Course 02: Complete Microsoft Word Manipulating Images Integrate Pictures and Text Adjust Image Appearance Insert Other Media Elements Using Custom Graphic Elements Create Text Boxes and Pull Quotes Add WordArt and Other Text Effects Draw Shapes Create Complex Illustrations with SmartArt Collaborating on Documents Prepare a Document for Collaboration Mark Up a Document Review Markups Merge Changes from Other Documents Adding Document References and Links Add Captions Add Cross References Add Bookmarks Add Hyperlinks Insert Footnotes and Endnotes Add Citations and a Bibliography Securing a Document Suppress Information Set Formatting and Editing Restrictions Restrict Document Access Add a Digital Signature to a Document Using Forms to Manage Content Create Forms Modify Forms Automating Repetitive Tasks with Macros Automate Tasks by Using Macros Create a Macro Course 03: Microsoft Excel Complete Course Microsoft Excel 2019 New Features Introduction to Microsoft Excel 2019 New Features CONCAT IFS MAXIFS MINIFS SWITCH TEXTJOIN Map Chart Funnel Chart Better Visuals Pivot Table Enhancements Power Pivot Updates Getting Started with Microsoft Office Excel Navigate the Excel User Interface Use Excel Commands Create and Save a Basic Workbook Enter Cell Data Use Excel Help Performing Calculations Create Worksheet Formulas Insert Functions Reuse Formulas and Functions Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows Search for and Replace Data Use Proofing and Research Tools Formatting a Worksheet Apply Text Formats Apply Number Format Align Cell Contents Apply Styles and Themes Apply Basic Conditional Formatting Create and Use Templates Printing Workbooks Preview and Print a Workbook Set Up the Page Layout Configure Headers and Footers Managing Workbooks Manage Worksheets Manage Workbook and Worksheet Views Manage Workbook Properties Working with Functions Work with Ranges Use Specialized Functions Work with Logical Functions Work with Date & Time Functions Work with Text Functions Working with Lists Sort Data Filter Data Query Data with Database Functions Outline and Subtotal Data Analyzing Data Apply Intermediate Conditional Formatting Apply Advanced Conditional Formatting Visualizing Data with Charts Create Charts Modify and Format Charts Use Advanced Chart Features Using PivotTables and PivotCharts Create a PivotTable Analyze PivotTable Data Present Data with PivotCharts Filter Data by Using Timelines and Slicers Working with Multiple Worksheets and Workbooks Use Links and External References Use 3-D References Consolidate Data Using Lookup Functions and Formula Auditing Use Lookup Functions Trace Cells Watch and Evaluate Formulas Sharing and Protecting Workbooks Collaborate on a Workbook Protect Worksheets and Workbooks Automating Workbook Functionality Apply Data Validation Search for Invalid Data and Formulas with Errors Work with Macros Creating Sparklines and Mapping Data Create Sparklines MapData Forecasting Data Determine Potential Outcomes Using Data Tables Determine Potential Outcomes Using Scenarios Use the Goal Seek Feature Forecasting Data Trends Excel Templates Excel Templates =========>>>>> And 5 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*8 = £103) CPD Hard Copy Certificate: £29.99 CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Students Graduates Admin Staff Business Professionals Entrepreneurs Freelancers Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Office Manager Virtual Assistant Data Analyst Project Manager Marketing Specialist Business Analyst Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee.