1296 Courses delivered Online

Course Overview Set a high bar for yourself in terms of job prospects by learning the essentials of Microsoft Office with this highly-acclaimed Basic ICDL Course | MS Office Essential Training (Arabic) course. This exclusively designed Basic ICDL Course | MS Office Essential Training (Arabic) course will teach you Microsoft Office essentials in an easy-to-understand manner and familiarise you with its many capabilities. It helps expose you to the fundamental tools such as Microsoft Word basics, Advanced WordPress content, Excel program interface and tools and PowerPoint presentations and basics. You'll learn how to use Microsoft Word, Excel, and PowerPoint to their full potential. It is loaded with helpful information to help you confidently use Microsoft Office in the workplace.  Now is the time to enrol and master the Office skills that every employer desires to achieve progression at work. This best selling Basic ICDL Course | MS Office Essential Training (Arabic) has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Basic ICDL Course | MS Office Essential Training (Arabic) is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Basic ICDL Course | MS Office Essential Training (Arabic) is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Basic ICDL Course | MS Office Essential Training (Arabic) is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Basic ICDL Course | MS Office Essential Training (Arabic), you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Basic ICDL Course | MS Office Essential Training (Arabic) will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Basic ICDL Course | MS Office Essential Training (Arabic) to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Objectives This course aims to provide delegates with a foundation for Excel knowledge and skills. ' Customer Feedback Very professional and well mannered, fun and pleasant at the same time. I learnt a lot Carolina Foster - CNN Very helpful course. Would definitely take another one. Pedro was very patient and made it fun and engaged with us all. Laura Smith - James Grant Great course and excellent trainer. Thanks Tracy Preston - Western Power Distribution 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. What is Excel? The Excel Interface Ribbon, Tabs and Groups Microsoft Office Backstage view Working with Workbooks Create a blank Workbook Create a Workbook using a Template Opening and saving Files Working with worksheets Worksheet navigation Select one or multiple Worksheets Insert, Move, Copy or Delete a Worksheet Working with Cells, Rows & Columns Cell References How to select cells or ranges Different types of data Move, Copy and Delete cells Pasting Options Find and Replace Working with Rows and Columns Overview of formulas in Excel Autocalculation The parts of an Excel formula Using calculation operators in Excel formulas The difference between Absolute, Relative and Mixed references Using Excel functions; Sum, Average, Max and Min Cell Formatting Font Format options Number Format options Change the Fill and Borders Cell Alignment An Introduction to Charts Create a simple Chart Format your chart Page Layout and Print Page Layout and Page Break View Change the Page Orientation Set Page Margins Headers and Footers in a worksheet Print a worksheet or workbook Who is this course for? Who is this course for? All users who want to master the main features of Microsoft Excel Requirements Requirements General knowledge of the Windows OS Certificates Certificates Certificate of completion Digital certificate - Included

To explore the new features that have included in Microsoft Office 2016, enrolling in this Office 2016 New Features course will be perfect for you. Grab the opportunity to acquire knowledge of Microsoft Office 2016 which will allow you to take your skills to a higher level and become more confident and efficient in the workplace. Office 2016 includes multiple unique features and enhancements offered in Office 2013. Throughout the course, you'll gain invaluable insider tips and learn new techniques to work with office 2016. Additionally, you'll analyse the common changes across the suite of products, such as Tell Me, ink equations, new chart types, version history, and themes and review individual feature enhancements in Microsoft Word, Excel, PowerPoint, Outlook, and Access. What Will I Learn? Learn about the new features across Office 2016 Use Co-authoring in Word Explore the new features in Excel Create a screen recording in PowerPoint Be more productive with Outlook Explore the new features of Access Requirements Basic understanding of existing Microsoft Office features and functionality Introduction Introduction FREE 00:00:00 Overview of Common Changes Using the Tell Me Feature 00:04:00 Using Smart Lookup 00:04:00 Applying the New Colorful Theme 00:02:00 Working with Version History 00:03:00 Working with New Chart Types 00:04:00 Using Ink Equations 00:03:00 New Features in Word Using Co-Authoring 00:05:00 New Features in Excel Using the One-Click Forecast 00:03:00 Searching in the PivotTable Field List 00:01:00 Using Multi-Select with a PivotTable Slicer 00:01:00 Using Maps 00:01:00 Using Get and Transform Power Queries 00:03:00 Publishing and Sharing in Power BI 00:02:00 Using Power View 00:02:00 Working with PowerPivot Improvements 00:02:00 New Features in PowerPoint Using Preset Styles for Shapes 00:04:00 Creating a Screen Recording 00:05:00 New Features in Outlook Working with Groups 00:09:00 Working with Clutter 00:05:00 Searching with Keywords and People Suggestions 00:02:00 Working with Email Attachments 00:03:00 New Features in Access Exploring the New Environment 00:01:00 Exploring New Templates 00:02:00 Exporting Linked Information to Excel 00:01:00 Integrating with SharePoint 2016 00:01:00 Conclusion Course Recap 00:01:00 Course Certification

Duration 1 Days 6 CPD hours This course is intended for This course is intended for business users and knowledge workers in a variety of roles and fields who have competence in a desktop-based installation of the Microsoft Office 2010 or 2013 edition of the Microsoft Office productivity suite, and who are now extending Microsoft Office to a collaborative cloud-based Office 365 environment. Overview In this course, you will build upon your knowledge of the Microsoft Office desktop application suite to work productively in the cloud-based Microsoft Office 365 environment.You will:- Sign in, navigate, and identify components of the Office 365 environment.- Create, edit, and share documents with team members using Word Online, Excel Online, PowerPoint Online, and Microsoft SharePoint.- Collaborate and work with colleagues using the Team, Planner, and Yammer apps.- Use email and manage contacts with Outlook on the web.- Use instant messaging with Skype for Business.- Conduct online meetings with Skype for Business. This course is an introduction to Microsoft© Office 365© with Skype© for Business in a cloud-based environment. It can be used as an orientation to the full suite of Office 365 cloud-based tools, or the Skype for Business lessons can be presented separately in a seminar-length presentation with the remaining material available for later student reference. Getting Started Sign In to Office 365 Navigate the Office 365 Environment Collaborating with Shared Files Work with Shared Documents in SharePoint Edit Documents in Office Online Collaborate on the SharePoint Site Work with OneDrive for Business and Delve Using Productivity Apps Work with Productivity Apps in Combination Broadcast Messages with Yammer Collaborate with the Teams App Manage Tasks with the Planner App Using Outlook on the Web Send and Receive Email Manage Contacts Schedule Appointments Personalize Outlook on the Web Communicating with Skype for Business Overview of Skype for Business Use Instant Messaging Make Voice and Video Calls Using Skype for Business Meetings Initiate Meetings Use Meeting Controls and Options Customize Skype for Business Additional course details: Nexus Humans Office 365 Web Apps (with Skype for Business) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Office 365 Web Apps (with Skype for Business) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Level 7 QLS Endorsed Diploma | 180 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

Highlights of the Course Course Type: Online Learning Duration: 1 Hour 37 Minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Microsoft Office Excel Understand the core competencies and principles of Microsoft Office Excel Explore the various areas of Microsoft Office Excel Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert office admin Microsoft Excel 2016: Part 3 (Expert Level) Course Master the skills you need to propel your career forward in Microsoft Office Excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive excel expert level course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this excel expert level course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft Office Excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Office Excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Office Excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft Office Excel. Enrol in this excel expert level course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive excel expert level course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Office Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This excel expert level course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This excel expert level course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This excel expert level course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. Course Curriculum Working With Multiple Worksheets and Workbooks Use Links and External References - Introduction 00:01:00 Use Links and External References 00:05:00 Use 3-D References - Introduction 00:01:00 Use 3-D References 00:04:00 Consolidate Data - Introduction 00:01:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions - Introduction 00:01:00 Use Lookup Functions 00:08:00 Trace Precedent and Dependent Cells - Introduction 00:01:00 Trace Precedent and Dependent Cells 00:03:00 Watch and Evaluate Formulas - Introduction 00:01:00 Watch and Evaluate Formulas 00:04:00 Sharing and Protecting Workbooks Collaborate on a Workbook - Introduction 00:01:00 Collaborate on a Workbook 00:05:00 Compare and Merge Workbooks - Introduction 00:03:00 Protect Worksheets and Workbooks 00:01:00 Protect Worksheets and Workbooks 00:04:00 Automating Workbook Functionality Apply Data Validation 00:01:00 Apply Data Validation 00:04:00 Search for Invalid Data and Formulas with Errors - Introduction 00:01:00 Search for Invalid Data and Formulas with Errors 00:03:00 Work with Macros - Introduction 00:01:00 Work with Macros 00:05:00 Edit a Macro 00:02:00 Creating Sparklines and Mapping Data Create Sparklines - Introduction 00:01:00 Create Sparklines 00:03:00 Map Data - Introduction 00:01:00 Map Data 00:04:00 Forecasting Data Determine Potential Outcomes Using Data Tables - Introduction 00:01:00 Determine Potential Outcomes Using Data Tables 00:05:00 Determine Potential Outcomes Using Data Scenarios - Introduction 00:01:00 Determine Potential Outcomes Using Data Scenarios 00:05:00 Use the Goal Seek Feature - Introduction 00:01:00 Use the Goal Seek Feature 00:03:00 Forecast Data Trends - Introduction 00:05:00 Forecast Data Trends 00:03:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Duration 1 Days 6 CPD hours This course is intended for This course is intended for business users and knowledge workers in a variety of roles and fields who have competence in a desktop-based Microsoft Office productivity suite, and who are now extending Microsoft Office to a collaborative cloud-based Office 365 environment. Overview In this course, you will build upon your knowledge of the Microsoft Office desktop application suite to work productively in the cloud-based Microsoft Office 365 environment. You will: Sign in, navigate, and identify components of the Office 365 environment. Create, edit, and share documents with team members using the Office Online apps, SharePoint, OneDrive for Business, and Teams Collaborate using Teams. Configure Teams. This course introduces several productivity apps including SharePoint, OneDrive and Teams that can be used in combination by teams for communication and collaboration. Outline for Teams About What is Microsoft Teams? Overview How to Access Microsoft Teams Etiquette for using teams Integration Capabilities SharePoint OneDrive Interface Storage ? OneDrive & SharePoint Permissions & Access Owner, Member & Guest Communication and Collaboration Team Conversations Private conversations Mentions Inviting people Search Settings and Customization Use the search tool to find specific messages, files or people Working with Files Create new files Upload files Attaching or sharing Files Edit and Collaborate on files Open files in SharePoint OneDrive for personal files Administration (Champions) Add members to a Team Access administrator settings Meetings and calls Initiate a meeting on demand Schedule a meeting and invite attendees Meetings and Outlook Introduction to SharePoint What is SharePoint Understanding your permissions Logging into SharePoint Working with SharePoint sites Working with SharePoint sites Navigate, browse and search in a site Follow a site Working with documents Navigate a library Open and edit a document Upload or create a document in a library Share a file Set alerts for files Use checkout and check-in Team collaboration Versioning Getting Started (OneDrive Outline) Sign in, access and navigate Working with files and folders Upload files Organize files and folders Rename. Copy and download files Delete and recover files Search Use OneDrive with Office Save an office file online to OneDrive Use OneDrive with desktop office Versioning Share files Co-authoring

Course Objectives At the end of this course you will be able to: Modify the PowerPoint environment Using Master View in order to customise a design template Add and customize SmartArt graphics Add animations and change its effect options Add action buttons to control the flow of the presentation Use various options to customise slide shows Use different PowerPoint file types to distribute presentations ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Very clearly explained Good pace. Lucy Tailor - ACER ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Tailored in company training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Customising the PowerPoint Environment Customise the User Interface Set PowerPoint Options Customising Design Templates Modify Slide Masters and Slide Layouts Add Headers and Footers Modify the Notes Master and the Handout Master Adding SmartArt to a Presentation Create SmartArt Modify SmartArt Working with Media Add Audio to a Presentation Add Video to a Presentation Working with Animations Entrance, Emphasis and Exit Animations Animate Charts by Category and Series Customise Animations and Transitions Collaborating on a Presentation Review a Presentation Store and Share Presentations on the Web Customising a Slide Show Annotate a Presentation Set Up a Slide Show Create a Custom Slide Show Add Hyperlinks Add Action Buttons Record a Presentation Securing and Distributing a Presentation Secure a Presentation Create a Video or a CD Distribute the Presentation in different File Formats Who is this course for? Who is this course for? This course is designed for delegates who want to gain the skills necessary to work with design templates, various types of diagrams, special effects, custom slide shows, collaboration functionality, and advanced presentation delivery. Requirements Requirements Preferably, delegates should have attended the Powerpoint Introduction course. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Course Objectives At the end of this course you will be able to: Identify the components of the PowerPoint interface Create slides Format text on slides Add and modify graphical objects to a presentation Work with tables in a presentation Add charts to a presentation Prepare the SlideShow '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Very patient Trainer. Happy to adapt course + help with problems on existing presentations. Andrea Lethbridge - CNN ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Getting Started with PowerPoint Identify the Components of the PowerPoint Interface Create a PowerPoint Presentation Accessing Help Choose the right view for the task in PowerPoint Normal view Slide Sorter view Notes Page view Outline view Add, rearrange, and delete slides in PowerPoint Working with Themes Add colour and design to my slides with themes Remove the current slide design (theme) Slide Layout What is a slide layout? Apply or change a slide layout Working with text Add text to a slide Create a new text box Format text Tables Add a table to a slide Format a Table Copy and paste a table from Word Insert an Excel spreadsheet within PowerPoint Edit Cells, Rows and Columns Delete a table Graphics Working with Clipart, and Shapes Selecting objects, shapes, pictures or text boxes Arrange a picture, shape or other object Adding Charts to Your Presentation Create a Chart Format a Chart Insert a Chart from Microsoft Excel Inserting date and slide numbers Add slide numbers to your presentation Hide slide numbers on the title slide Change where the page numbers appear on your slides Start your slide numbering with a specific number Print slides, notes, or handouts Create the Slide Show Record your slide show Preview the recorded slide show Turn slide timings off Set the slide timings manually Add or remove transitions between slides Add Animations to Text and Objects Deliver the Presentation Speakers notes Add speaker notes to your slides View your speaker notes as you deliver your slide show Who is this course for? Who is this course for? This course is designed for end users who are interested in learning the fundamentals needed to create and modify engaging presentations. Requirements Requirements General knowledge of the Windows OS Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

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.