3017 Office Skills courses delivered On Demand

PowerPoint has gained its popularity since it widely used in both businesses and classrooms. By taking this Microsoft PowerPoint 2016 for Beginners course, you will learn how to use the built-in graphics and tools for creating as well as presenting impressive visual presentations. Besides, you will also learn about the interface of the PowerPoint and how to deliver PowerPoint Presentation, add graphical components, adjust objects, join tables, charts and so on. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post.   Course Content Getting Started with PowerPoint Navigate the PowerPoint Environment 00:30:00 ACTIVITY - NAVIGATING THE POWERPOINT 2016 USER INTERFACE 00:05:00 Create and Save a PowerPoint Presentation 00:15:00 ACTIVITY - CREATING AND SAVING A POWERPOINT PRESENTATION 00:05:00 Use Help 00:15:00 ACTIVITY - USING POWERPOINT HELP 00:05:00 Developing a PowerPoint Presentation Select a Presentation Type 00:15:00 ACTIVITY - SELECTING A PRESENTATION TYPE 00:05:00 Build a Presentation 00:15:00 ACTIVITY - BUILDING A PRESENTATION 00:05:00 Lay Out a Presentation 00:15:00 ACTIVITY - LAYING OUT A PRESENTATION 00:05:00 Edit Text 00:15:00 ACTIVITY - EDITING TEXT 00:05:00 View and Navigate a Presentation 00:15:00 ACTIVITY - VIEWING A PRESENTATION 00:05:00 Performing Advanced Text Editing Format Characters 00:15:00 ACTIVITY - FORMATTING CHARACTERS 00:05:00 Format Paragraphs 00:30:00 ACTIVITY - FORMATTING PARAGRAPHS 00:05:00 Format Text Boxes 00:15:00 ACTIVITY - FORMATTING TEXT BOXES 00:05:00 Adding Graphical Elements to Your Presentation Insert Images 00:30:00 ACTIVITY - INSERTING IMAGES 00:05:00 Insert Shapes 00:15:00 ACTIVITY - INSERTING SHAPES 00:05:00 Insert WordArt 00:15:00 ACTIVITY - INSERT WORDART 00:05:00 Modifying Objects in Your Presentation Edit Objects 00:30:00 ACTIVITY - EDITING OBJECTS 00:05:00 Format Objects 00:15:00 ACTIVITY - FORMATTING OBJECTS 00:05:00 Group Objects 00:15:00 ACTIVITY - GROUPING OBJECTS 00:05:00 Arrange Objects 00:15:00 ACTIVITY - ARRANGING OBJECTS 00:05:00 Animate Objects 00:15:00 ACTIVITY - ANIMATING OBJECTS 00:05:00 Adding Tables to Your Presentation Create a Table 00:15:00 ACTIVITY - CREATING A TABLE 00:05:00 Format a Table 00:15:00 ACTIVITY - FORMATTING A TABLE 00:05:00 Insert a Table from Other Microsoft Office Applications 00:15:00 ACTIVITY - INSERTING A TABLE FROM MICROSOFT EXCEL 00:05:00 Adding Charts to Your Presentation Create a Chart 00:15:00 ACTIVITY - CREATING A CHART 00:05:00 Format a Chart 00:15:00 ACTIVITY - FORMATTING A CHART 00:05:00 Manipulate a Chart 00:15:00 ACTIVITY - MANIPULATING A CHART 00:05:00 Insert a Chart from Microsoft Excel 00:15:00 ACTIVITY - INSERTING A CHART FROM MICROSOFT EXCEL 00:05:00 Preparing to Deliver Your Presentation Review Your Presentation 00:30:00 ACTIVITY - REVIEWING YOUR PRESENTATION 00:05:00 Apply Transitions 00:15:00 ACTIVITY - APPLYING TRANSITIONS 00:05:00 Print Your Presentation 00:15:00 ACTIVITY - PRINTING YOUR PRESENTATION 00:05:00 Deliver Your Presentation 01:00:00 ACTIVITY - DELIVERING YOUR PRESENTATION 00:05:00 Activities Activities - Microsoft PowerPoint 2016 for Beginners 00:00:00 Mock Exam Mock Exam- Microsoft PowerPoint 2016 for Beginners 00:20:00 Final Exam Final Exam- Microsoft PowerPoint 2016 for Beginners 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Register on the Advanced SAS Programming Using MacrosSQL today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Advanced SAS Programming Using MacrosSQL is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Advanced SAS Programming Using MacrosSQL Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Advanced SAS Programming Using MacrosSQL, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Advanced SAS Programming Using MacrosSQL Unit - 1 Section 0-00- Why SAS 00:01:00 Unit - 2 Section 2-02- SAS Studio through SAS OnDemand- Registration 00:04:00 Section 2-03- Logging-in to SAS after installation 00:01:00 Section 2-04- SAS Interface and windows 00:06:00 Unit - 3 Section 3-00- Section Overview - Macros 00:01:00 Section 3-01-Macro Variables - introduction 00:14:00 Section 3-02-Application of macro variables 00:13:00 Section 3-03-01-Nested macro vars 00:11:00 Section 3-03-02-More on Ampersand resolutions using a cool example 00:09:00 Section 3-04-00-SAS Macros - introduction 00:10:00 Section 3-04-01-SAS Macros - Examples 00:07:00 Section 3-04-02-Keyword positional and mixed params 00:06:00 Section 3-04-03-Conditional Logic in Macros 00:11:00 Section 3-05-Macro Functions 00:12:00 Section 3-05-Options Statement- mprint-mlogic-symbolgen 00:13:00 Section 3-07-Connecting the two worlds - Call Symput - Symget 00:14:00 Section 3-09-01-02- Bringing data into SAS using Import Wizard 00:04:00 Section 3-09-02- Bringing data into SAS using LIBNAME statement 00:05:00 Section 3-09-03- Bringing data into SAS using FILENAME 00:05:00 Unit - 4 Section 4-00- Section Overview - Proc SQL 00:01:00 Section 4-01-01-Proc SQL - copying data 00:13:00 Section 4-01-02-Proc SQL - filtering data 00:07:00 Section 4-01-03-Proc SQL - sorting data 00:08:00 Section 4-01-04-Proc SQL - removing duplicates 00:05:00 Section 4-02-01-Proc SQL - Union 00:09:00 Section 4-02-02-Proc SQL - Except 00:04:00 Section 4-02-03-Proc SQL - Intersect 00:02:00 Section 4-03-00-Merging data using Joins-Introduction 00:08:00 Section 4-03-01-Proc SQL - inner join 00:14:00 Section 4-03-02-Proc SQL - full join 00:08:00 Section 4-03-03-Proc SQL - left and right joins 00:07:00 Section 4-04-01-Proc SQL - creating macro vars 00:07:00 Unit - 5 Section 5-00- Bonus lecture 00:02:00 Resources Resources - Advanced SAS Programming Using MacrosSQL 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Description: This diploma in C++ and Python programming course is a great way to get started in programming. It covers the study of the C++ and Python group of languages used to build most of the world's object oriented systems. The course is for interested students with a good level of computer literacy who wish to acquire programming skills. It is also ideal for those who wish to move to a developer role or areas such as software engineering. This is a great course to develop your coding skills. It teaches key features of imperative programming using C and is an ideal preliminary to the Object-Oriented Programming using Python. Join the course now! Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. 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. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. 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. Python 3 Beginners Module 01 Introduction FREE 00:29:00 Starter Examples 00:33:00 Learning C Concepts 00:13:00 Module 02 Data Types and Inference 00:20:00 Sizeof and IEEE 754 00:33:00 Constants L and R Values 00:11:00 Operators and Precedence 00:25:00 Literals 00:26:00 Module 03 Classes and Structs FREE 00:22:00 Enums 00:14:00 Unions 00:16:00 Introduction to Pointers 00:11:00 Pointers and Array Indexing 00:12:00 Using Const with Pointers 00:09:00 Pointers to String Literals 00:12:00 References 00:14:00 Smart Pointers 00:22:00 Arrays 00:15:00 Standard Library Strings 00:13:00 More Standard Library Strings 00:18:00 Functions 00:06:00 More Functions 00:16:00 Function Pointers 00:15:00 Control Statements 00:18:00 Python 3 Intermediate Module 04 Installing Python FREE 00:17:00 Documentation 00:30:00 Command Line 00:17:00 Variables 00:29:00 Simple Python Syntax 00:15:00 Keywords 00:18:00 Import Module 00:17:00 Additional Topics 00:23:00 Module 05 If Elif Else 00:31:00 Iterable 00:10:00 For 00:11:00 Loops 00:20:00 Execute 00:05:00 Exceptions 00:18:00 Data Types 00:24:00 Module 06 Number Types 00:28:00 More Number Types 00:13:00 Strings 00:20:00 More Strings 00:11:00 Files 00:08:00 Lists 00:15:00 Dictionaries 00:04:00 Tuples 00:07:00 Sets 00:09:00 Module 07 Comprehensions 00:10:00 Definitions 00:02:00 Functions 00:06:00 Default Arguments 00:06:00 Doc Strings 00:06:00 Variadic Functions 00:07:00 Factorial 00:07:00 Function Objects 00:07:00 Module 08 Lambda 00:11:00 Generators 00:06:00 Closures 00:10:00 Classes 00:09:00 Object Initialization 00:05:00 Class Static Members 00:07:00 Classic Inheritance 00:10:00 Data Hiding 00:07:00 Python 3 Advanced Iterators and Generators FREE 00:16:00 Regular Expressions 00:19:00 Introspection and Lambda Functions 00:27:00 Metaclasses and Decorators 00:24:00 Modules and Packages 00:25:00 Working with APIs 00:15:00 Metaprogramming Primer 00:19:00 Decorators and Monkey Patching 00:21:00 XML and JSON Structure 00:10:00 Generating XML and JSON 00:17:00 Parsing XML and JSON 00:19:00 Implementing Algorithms 00:19:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: The Computer Operating and Troubleshooting Diploma - Video Training Course provides the basics or fundamental elements of the computer so that you can able to use the computer confidently and efficiently. The course mainly focuses on the operating system and networking. Throughout the course, you will learn about hardware and peripherals, storage, connectivity devices, and network components. You will also be knowledgeable about the Operating System fundamentals such as the meaning of operating system, the procedures of configuring the operating system, application definition, and the ways of using control panel. Apart from these, the course will help you to know about the basic concepts of Software like how to use software, what is software licensing or what the different types of software tools are. Finally, the course provides basic lessons about troubleshooting and explains the ways of using software, hardware, devices, peripherals, backup, and restore. 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? Computer Operating and Troubleshooting Diploma - Video Training 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 Computer Operating and Troubleshooting Diploma - Video Training 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. Operating System Fundamentals What is an Operating System FREE 00:48:00 Configuring the Operating System 00:06:00 What is an Application 00:10:00 Using Control Panel 00:18:00 Computer and Network Terminology Hardware and Peripherals 00:07:00 Storage 00:12:00 Connectivity Devices 00:05:00 Network Components 00:09:00 Working with Software and the OS Software and Concepts 00:10:00 Licensing 00:06:00 Using Software 00:07:00 Software Tools 00:10:00 Troubleshooting Software 00:14:00 Hardware, Devices, and Peripherals 00:06:00 Backup and Restore 00:03:00 Mock Exam Mock Exam- Computer Operating 00:20:00 Final Exam Final Exam- Computer Operating 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Course Overview If you are a JavaScript developer who wants to master TypeScript fundamentals, jumpstart on the road to learning TypeScript with this TypeScript Tutorial For Beginners course.  TypeScript is an open-source programming language which builds on JavaScript. The advantage of Typescript over Javascript is that it adds optimal static typing to the JavaScript language. Many Javascript frameworks use typescript, such as Angular. This course covers a comprehensive set of modules to enhance your understanding of TypeScript fundamentals. It explains what typescript is and gives you a clear understanding of its significance. You will learn how to find the data type of a variable in TypeScript and understand how to define a function type variable typescript. You will also learn how to define objects using classes and use the different access modifiers. In time, you will get to grips with the specific skills to write more scalable applications. Whatever you learn in JavaScript adds value to your understanding of TypeScript. You're already halfway there if you're familiar with Javascript. Enrol right now! Learning Outcomes Understand the variables and data types Explore how to define variables using data types Gain in-depth knowledge of the operators Deepen your understanding of the object oriented principles Know how to create and use arrow functions Familiarise with the flow control statements Understand the variable prefixes Have an in-depth understanding of variable prefixes Who is this course for? The TypeScript Tutorial For Beginners course is incredibly beneficial for professionals interested in understanding the fundamentals of TypeScript. Upgrading skills in this course open doors to tremendous opportunities. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path The TypeScript Tutorial For Beginners course provides useful skills to possess and would be beneficial for any related profession or industry such as: TypeScript Developer Full Stack Developer Unit 01: Introduction Module 01: What and why TypeScript 00:02:00 Module 02: TypeScript Playground 00:04:00 Module 03: Install TypeScript 00:02:00 Module 04: Install Visual Studio Code 00:01:00 Unit 02: Variables and Data Types Module 01: Introduction 00:03:00 Module 02: First Program Using Visual Studio Code 00:04:00 Module 03: Use JS in a HTML 00:02:00 Module 04: Strings 00:02:00 Module 05: Boolean 00:01:00 Module 06: Any Type 00:01:00 Module 07: Homogenous Arrays 00:03:00 Module 08: Heterogenous Arrays 00:01:00 Module 09: Using alert confirm and prompt 00:03:00 Module 10: Comments 00:02:00 Module 11: Enum Type 00:05:00 Unit 03: Operators Module 01: Arithmetic 00:03:00 Module 02: Assignment 00:04:00 Module 03: Comparison 00:04:00 Module 04: Logical 00:04:00 Module 05: Ternary 00:03:00 Unit 04: Flow Control Statements Module 01: Introduction 00:01:00 Module 02: IF Else Ladder 00:06:00 Module 03: Switch 00:04:00 Module 04: Break and Case Flow 00:03:00 Module 05: While loop 00:03:00 Unit 05: Objects and Arrays Module 01: Introduction 00:02:00 Module 02: Object Literal 00:03:00 Module 03: For-In Loop 00:02:00 Module 04: Arrays 00:04:00 Module 05: De-Structuring Arrays 00:02:00 Module 06: De-Structuring Objects 00:02:00 Unit 06: Functions Module 01: Introduction 00:02:00 Module 02: First Function 00:03:00 Module 03: Passing a parameter 00:01:00 Module 04: Passing Multiple Parameters 00:02:00 Module 05: Optional Parameters 00:04:00 Module 06: Default Values 00:01:00 Module 07: Function as parameter 00:02:00 Module 08: Returning a function 00:03:00 Module 09: Anonymous Functions 00:02:00 Module 10: Overloading 00:05:00 Module 11: REST PARAMS 00:05:00 Module 12: Using a Type on REST PARAM 00:01:00 Unit 07: Arrow Functions Module 01: Introduction 00:02:00 Module 02: First arrow function 00:03:00 Module 03: Passing Parameters 00:03:00 Module 04: Array of Arrow Functions 00:03:00 Unit 08: Variable Prefixes Module 01: let 00:03:00 Module 02: const 00:02:00 Module 02: const functions 00:02:00 Module 04: declare 00:01:00 Unit 09: Interfaces Module 01: Introduction 00:02:00 Module 02: Define an Object Interface 00:03:00 Module 03: Create and object 00:03:00 Module 04: Defining optional properties 00:01:00 Module 05: Interfaces are only compile time 00:01:00 Module 06: Function Interfaces 00:04:00 Module 07: Return Types in Functional interfaces 00:02:00 Module 08: Adding methods to Object Interfaces 00:02:00 Module 09: Array Interfaces 00:03:00 Module 10: String indexed Array Interfaces 00:03:00 Module 11: Extending interfaces 00:06:00 Unit 10: Classes Module 01: Introduction 00:01:00 Module 02: Create a class 00:03:00 Module 03: Add a constructor 00:04:00 Module 04: Add Function properties 00:02:00 Module 05: Power of TypeScript 00:01:00 Module 06: Using for-in and instanceof 00:04:00 Module 07: Implementing an interface 00:06:00 Unit 11: Inheritance Module 01: Introduction 00:03:00 Module 02: Extending a class 00:05:00 Module 03: Create Child Objects 00:07:00 Module 04: Inheriting Functionality 00:04:00 Module 05: Overriding 00:03:00 Unit 12: Access modifiers, Encapsulation and Static Module 01: Public and readonly 00:02:00 Module 02: Encapsulation 00:01:00 Module 03: Private properties 00:04:00 Module 04: Accessor methods 00:02:00 Module 05: Using Static Properties 00:04:00 Module 06: More about static 00:01:00 Module 07: Static Methods 00:03:00 Unit 13: Type Casting Module 01: String to numeric 00:04:00 Module 02: Using the toString method 00:03:00 Module 03: Object Casting 00:02:00 Unit 14: Modules Module 01: Introduction 00:01:00 Module 02: Using Function Modules 00:04:00 Module 03: Import Aliasing and Alternate Export Syntax 00:02:00 Module 04: Default Exports 00:02:00 Module 05: Class Modules 00:01:00 Module 06: Aliasing class modules 00:02:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description This course is aimed at the excel user who already knows the basics of Excel 2007. This course will help you to go beyond the basics - to reach a higher-intermediate level. With shortcuts, tricks and tips - you will be able to work smarter and faster. If you want to be fairly competent on the software, then this course will be very handy. Its a lot quicker to be shown things, then to try and muddle through and work things out by yourself. Guaranteed, there'll be some items which we cover, that you have no idea that Excel was capable of doing! We don't want you to spend a day of your life in the classroom... learn 99 quick and very useful, practical things which you can apply on your job or on your projects. We'll cover: Working with Data - using series, symbols and special characters, hide rows and freeze panels Formulas and Functions - Calculate the duration between two dates/times, best loan terms, create conditional formula and conditional sums Copying Data - transposing rows into columns and paste specials Using Excel lists - sort and filter a list, remove duplicate records, count filtered records, look up information in a list Data Patterns - Pivot tables, pivot charts, what-if analysis Creating charts - histogram, trendlines, piecharts, error bars Presenting data - formatting columns and numbers Saving and printing worksheets - printing multiple worksheets, area, cell ranges, repeat headings of a row or column Extending excel - hyperlinks, embed a chart, importing a worksheet Customizing Excel - custom workspace, custom view, macros The target audience is those who have a basic level with Excel and want to learn other handy functions and features. We use Excel 2007 only in this course. If you have Excel 2003, this course will be difficult to follow as although the functions and features exist in 2003, the layout changed very dramatically between the two versions. Excel 2007 isn't too dissimilar from 2010. Where necessary, we provide a spreadsheet - but as long as you have Excel 2007, you'll be able to copy and do exactly what you see on the screen by pausing the video and following along. The course will take approx 7.5 hours to complete. Take this course if you want to take your basic understanding of Excel to a higher intermediate-level. What Will I Learn? Work with Formulas and Functions Copy data and formats Use excel lists Create charts Present worksheets nicely Save and print worksheets Who is the target audience? This is for those who are beginners in Excel and want to take it further to higher intermediate level - using Excel 2007 You should know the 'basics' in Excel and we take it from near-beginner, to higher intermediate Requirements Students will need to have Excel 2007 installed, as this is the system used in the teaching Introduction to the course and your tutor Data Enter numbers and fractions 00:05:00 Dates and Times 00:08:00 Name Cells and Ranges 00:04:00 Validate Data entry using a pick list FREE 00:07:00 Extend a series of dates with autofill 00:04:00 Add a symbol or special character 00:04:00 Compare multiple spreadsheets using freeze panels 00:06:00 Hide rows 00:04:00 Keyboard 00:10:00 Speak Cells 00:04:00 Find and replace data 00:10:00 Formulas and Functions Add values 00:03:00 Function wizard 00:06:00 Formulas with comments 00:04:00 OneNote 00:06:00 Define a constant 00:04:00 Apply names in functions 00:05:00 Figure out the best loan terms 00:04:00 Internal Rates of Return 00:04:00 Nth largest value 00:04:00 Large, Small, Max, Min 00:04:00 Conditional formula 00:03:00 Conditional formula with names 00:04:00 Conditional sum 00:03:00 Count If 00:02:00 Inner calculator 00:02:00 Square Roots 00:03:00 Calculate the duration between two times 00:04:00 Calculate days between two dates 00:04:00 Copying Data, Formats etc., Copy a range 00:03:00 Transpose a row into a column FREE 00:02:00 Chart formatting 00:07:00 Copy styles to another workbook 00:07:00 Paste special and copying worksheets 00:06:00 Track changes while Editing 00:06:00 Lists Enter list data using a form 00:05:00 Searching through a data list 00:04:00 Import a word list into excel 00:04:00 Sort a list 00:02:00 Filter a list 00:02:00 Sort by multiple criteria FREE 00:03:00 Find averages in a sorted group 00:05:00 Filter by multiple criteria 00:03:00 Remove duplicate records from a list 00:03:00 Count filtered records 00:07:00 Filter by multiple criteria in the same column 00:06:00 Chart a filtered list 00:02:00 Look up information in a List 00:05:00 Data Patterns Create a PivotTable 00:05:00 Modify a PivotTable and layout 00:03:00 Find the average of a field 00:04:00 Create a calculated field 00:03:00 Calculated fields and charts FREE 00:02:00 Hide rows and columns in a PivotTable 00:02:00 AutoFormat a PivotTable 00:01:00 Create a PivotChart 00:03:00 Turning on the Data Analysis function so that statistical information can be run 00:02:00 Describe Data with Statistics 00:03:00 Discover associations within your data 00:03:00 Product Numbers 00:02:00 What-if analysis 00:05:00 Goal seek 00:06:00 Creating Charts Create a Chart 00:06:00 Modify Chart details 00:04:00 Change the Chart Type 00:03:00 Add a Trendline to a Chart 00:06:00 Remove Chart Data 00:02:00 Add chart data 00:02:00 Missing chart data 00:04:00 Error bars 00:04:00 Pull a slice from a Pie Chart 00:03:00 Label slices of a Pie Chart 00:04:00 Histogram 00:06:00 Paste a chart into Word 00:03:00 Amending a chart in Word 00:02:00 Paste-link a Chart into Word 00:05:00 Worksheets Format Numbers as Percentages 00:04:00 Format Currencies in Currency and Accounting Formats 00:03:00 Format Column Headings 00:05:00 Format Quickly with Format painter FREE 00:02:00 Insert a background image into your worksheet 00:03:00 Create a Transparent image 00:03:00 Saving and Printing Worksheets Save a workbook as a Template 00:07:00 Save a workbook as an XML spreadsheet 00:05:00 Print multiple cell ranges on One Page 00:03:00 Print multiple worksheets of a workbook 00:01:00 Page set up, header, footer, margins - 1 page printing 00:04:00 Repeat Headings of a Row or Column 00:07:00 Print functions to show calculations & comments 00:07:00 Extending Excel Hyperlink a worksheet to another office document 00:03:00 Embed a chart within PowerPoint 00:05:00 Publish an Interactive Workbook 00:05:00 Import a Worksheet into Access 00:09:00 Use Excel Data to create labels in Word 00:10:00 Customizing Excel Launch a specific Workbook when Excel Opens 00:03:00 Save Time by Creating a Custom View 00:03:00 Create a Custom Number Format 00:06:00 Changing Text to Columns 00:05:00 Create a Macro to Format Numbers 00:06:00 Online Live Webinar Course-S3_W4_L1 - 42 - Excel Made simple 01:00:00

Microsoft Excel assists you to perform with different programs such as calculation, macro program language, pivot tablets, graphics tools, and various applications within time. Learn much more precise use of these functions with the easiest and effective method thorough Microsoft Office 2016 Excel Beginners course. The course teaches you the basic functions of Excel. It instructs you how to open Excel files, make a simple calculation, and save it. It also teaches you how to put data, extract data, analyze actionable information, and perform in different ways. The purpose of the course is to enhance your ability to kick-start your career in a sound bite. Who is this Course for? Microsoft Office 2016 Excel Beginners is 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. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Getting Started with Microsoft Office Excel 2016 Navigate the Excel User Interface 00:28:00 Use Excel Commands 00:10:00 Create and Save a Basic Workbook 00:19:00 Enter Cell Data 00:12:00 Use Excel Help 00:05:00 Performing Calculations Create Worksheet Formulas 00:15:00 Insert Functions 00:17:00 Reuse Formulas and Functions 00:17:00 Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Formatting a Worksheet Apply Text Formats 00:17:00 Apply Number Format 00:08:00 Align Cell Contents 00:09:00 Apply Styles and Themes 00:12:00 Apply Basic Conditional Formatting 00:11:00 Create and Use Templates 00:07:00 Printing Workbooks Preview and Print a Workbook 00:10:00 Set Up the Page Layout 00:08:00 Configure Headers and Footers 00:07:00 Managing Workbooks Manage Worksheets 00:05:00 Manage Workbook and Worksheet Views 00:07:00 Manage Workbook Properties 00:05:00 Mock Exam Mock Exam- Microsoft Office 2016 Excel Beginners 00:20:00 Final Exam Final Exam- Microsoft Office 2016 Excel Beginners 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Are you new to mac? Want to learn how to operate a mac? Want to learn the tips and tricks of having fun with mac? If yes then enrol now to benefit the most out of this course. Description: This course is designed for individuals who are willing to switch from PC to Mac. Mac is continuously bringing up more inventive thoughts to incorporate into the present elements available. In this course, you will have an overview of the Mac desktops and the features that makes it more convenient then other systems. In this course, you will learn how to operate mac using the simplest method. You will also learn about networking process for Mac and how can user network 2 or more macs without any underlying issues usually related to other networking practices. Through this course, you will learn about many other interesting things you can do easily. Our professional, as well as experienced tutors, will make this course more fun and informative. Who is the course for? This course is designed for individuals who are interested in exploring the benefits of using MAC. It is also beneficial for the graphic designers as Mac system is preferable for handling the graphic software. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: MAC Operating Course is a useful qualification to possess, and would be beneficial for the following careers: Mac operator. Production artist. Pre-press technician. Graphics designer. Creative art worker. Gamers. Video editors. Chapter-01 Introduction to Mac 01:00:00 Chapter-02 Features of Mac Desktops 01:00:00 Chapter-03 Networking System of Mac 01:00:00 Chapter-04 Types of Mac 01:00:00 Chapter-05 Mac your way to cyberspace 00:30:00 Chapter-06 Benefits of Using Mac 01:00:00 Chapter-07 How to print & fax using Mac 01:00:00 Chapter-08 Managing music with iTunes 01:00:00 Chapter-09 Having fun with photos 01:00:00 Chapter-10 Wrapping Up 00:15:00 Mock Exam Mock Exam- MAC Operating Course 00:20:00 Final Exam Final Exam- MAC Operating Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Microsoft OneNote 2016 has modernized the look of the tabs to match the rest of the Office 2016 suite of applications and has added some new features that make this the go-to application for note-taking. This Microsoft OneNote 2016 covers different features of the interface, shows users how to print, covers some simple scenarios, and examine the basics of formatting. When you will complete the course you will be comfortable creating a new OneNote notebook, customizing the interface, entering information into OneNote from the variety of sources, and using OneNote's collaboration tools. Joining this course will help you to improve your skills. Learning Outcomes: Getting used to the user interface, creating notebooks, using templates, and customizing the interface Add images, tables, audio, video, Quick Notes and links; modify notebook formatting, and utilize tags, symbols, drawing tools and pen options Save and export content while using alternate file types, managing notebook recycle bins and backups Integrating other Microsoft programs with OneNote such as Excel and Visio through working with spreadsheets, diagrams and other embedded files Sharing and collaborating on notebooks through sending them and Outlook integration Finalizing notebooks through proofing and print settings, configuring notebook settings, properties and security Conducting searches on notebooks 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 OneNote 2016 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 OneNote 2016 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. Exploring Notebook Structure Navigate the OneNote 2016 Environment 01:00:00 Create a Notebook 01:00:00 Use Predesigned Templates for OneNote Notebooks 00:30:00 Customize the User Interface 02:00:00 Adding Content and Formats to a OneNote Notebook Modify Formatting in a Notebook 01:00:00 Add Images to a Notebook 01:00:00 Add Tables to a Notebook 01:00:00 Add Audio and Video to a Notebook 00:30:00 Add Quick Notes and Links 01:30:00 Use Tags, Symbols, Drawing Tools, and Pen Options 01:00:00 Managing OneNote Notebooks, History, and Backups Save and Export Content and Use Alternate File Types 01:00:00 Manage Notebook Recycle Bins and Backups 01:00:00 Working with Embedded Files Work with Excel Spreadsheets and Visio Diagrams 00:30:00 Work with Embedded Files 00:45:00 Sharing and Collaborating with Notebooks Send a Notebook and Use Outlook Integration 01:00:00 Share and Collaborate on Notebooks 01:00:00 Finalizing a Notebook Finalize a Notebook Using Proofing and Print Settings 01:30:00 Configure Notebook Properties and Security 01:00:00 Search Notebooks 00:30:00 Activities Activities - Microsoft OneNote 2016 00:00:00 Mock Exam Mock Exam- Microsoft OneNote 2016 00:20:00 Final Exam Final Exam- Microsoft OneNote 2016 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Computer operation can be difficult if you have no idea how to do it. However, it only takes a complete beginner course on the computer to learn how. You need to learn the basics, operation systems and how healthy computing works which this course provides. If you think you are ready to start your journey in learning all about the computer, then you don't have to wait for. Start learning now and understand why the computer is considered as a necessity in this modern age. Who is the course for? Beginner to advanced level users can benefit from the lessons we provide People who have an interest in learning about computer and computer maintenance Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Beginners Guide to Computers is a very useful qualification to possess, and will be very helpful to have especially for these careers: Computer Maintenance Staff IT Department Manager Computer Engineer Computer Specialist Computer Technician. Computer Fundamentals Basic Terms 00:15:00 Types of Computers 00:15:00 Anatomy of a PC 00:30:00 How a PC Works 00:15:00 CPU and Memory 00:30:00 Input Devices 00:15:00 Output Devices 00:15:00 Secondary Storage Devices 00:30:00 The Basics 00:15:00 Operating Systems and Applications 00:30:00 How is Software Built 00:15:00 Types of Software 00:15:00 Legal Issues 00:15:00 Computer Essentials Introduction 00:15:00 Understanding The Components Of A PC 01:30:00 Do You Need To Upgrade Your PC? 01:00:00 Essential Softwares You Must Have On Your PC 01:00:00 Installing And Organizing Your PC 01:00:00 Troubleshooting Guidelines 01:00:00 How To Speak To A Technician 00:30:00 Summary 00:30:00 Operating Systems Introduction 00:15:00 What is an Operating System? 00:30:00 History of Operating System 00:30:00 What an Operating System Does 01:00:00 Microsoft Windows 00:15:00 MAC OS 01:00:00 UNIX 00:30:00 LINUX 00:30:00 GNU 00:30:00 Other Operating Systems999 01:00:00 Installing an Operating System 00:30:00 Defining The Processes 01:00:00 Conclusion 00:15:00 Healthy Computing Introduction 01:00:00 Body Position 01:00:00 Monitors 01:00:00 Keyboards 01:00:00 Mouse or Pointer 02:00:00 Document Holders and Desk 01:00:00 Chairs 02:00:00 Telephones 00:30:00 What Have We Learned 01:00:00 Work Process and Recognition 01:00:00 Lighting 01:00:00 Ventilation 00:30:00 Awkward Postures 02:00:00 Musculoskeletal Disorders (MSD) 02:00:00 4 Steps to Setting Up The Computer Workstation 01:00:00 Exercises and Breaks 01:00:00 Conclusion 00:15:00 Mock Exam Mock Exam-Beginners Guide to Computers 00:30:00 Final Exam Final Exam-Beginners Guide to Computers 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00