374 Spreadsheet courses delivered Online

The Microsoft Excel course is designed to teach you everything you need to know about Excel from scratch. This comprehensive, instructor-guided training will help you gain a thorough understanding of Excel’s essential features and functions, enabling you to kickstart your career or enhance your current skills. Whether you are just starting out or looking to build on your knowledge, this course will equip you with the most in-demand skills required in today's competitive job market.

Creating a compelling social media hook for your OneNote online course can significantly boost your visibility and attract more learners. Start by crafting a message that highlights the unique benefits of your course, such as its convenience, comprehensive content, and interactive features. Use engaging visuals and testimonials to showcase the value of your course. Leverage the power of storytelling to connect with your audience on an emotional level, making the learning experience relatable and desirable. Tailor your message to fit the platform you're using; for instance, a short and catchy hook for Twitter, a visually appealing post for Instagram, or a detailed and informative article for LinkedIn. Remember to include a clear call-to-action, encouraging potential students to sign up or learn more. By combining these elements, you can create a social media hook that resonates with your target audience and sets your OneNote course apart from the competition.

Overview This comprehensive course on Microsoft Excel: Excel Sheet Comparison with VBA will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Excel Sheet Comparison with VBA comes with accredited certification which will enhance your CV and make you worthy in the job market.So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Microsoft Excel: Excel Sheet Comparison with VBA. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Excel Sheet Comparison with VBA is fully compatible with PC's, Mac's, Laptop,Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 6 sections • 23 lectures • 02:10:00 total length •Introduction to Compare Data Workbook: 00:06:00 •Download Resources: 00:00:00 •Key requirements for Comparing any Datasets or Worksheets: 00:03:00 •Tool to Compare Datasets or Worksheets: 00:06:00 •Overview of Compare Data Workbook: 00:09:00 •Most Important things to remember before you use compare data workbook: 00:03:00 •IMPORTANT - First Column as KEY Column with UNIQUE Values: 00:09:00 •Deep Dive into Compare Data Workbook's Environment: 00:10:00 •How to Change Header Rows for your data: 00:06:00 •Basics of Using macro enabled Excel files and Code Modules: 00:04:00 •Changing the Main two sheets name, variance tags in VBA Code: 00:05:00 •Changing various elements across VBA Code modules: 00:05:00 •Clear Sheet data button VBA Code: 00:04:00 •Convert Row data into Structured, clean and formatted data with Power Query 1: 00:07:00 •Convert Row data into Structured, clean and formatted data with Power Query 2: 00:07:00 •Mutual Funds Portfolio - Finding Variances at two different times: 00:07:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 1: 00:05:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 2: 00:07:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 3: 00:08:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 4: 00:07:00 •Comprehensive Payroll Analysis - Creating Powerful Dashboard 5: 00:08:00 •IMPORTANT Facts and Limitation of Compare Data Workbook: 00:03:00 •Conclusion: 00:01:00

This one-day workshop is designed to give you an awareness of the fundamentals of Microsoft Excel and, in particular, to give you the confidence needed to efficiently create, edit and manage spreadsheets. This course will help participants: Create tables Use functions Manage rows and columns Write formulas Manage sheets Use content formats Handle larger tables Create reports and charts 1 Creating a table Creating an Excel table from scratch Wrapping text in cells Speeding up data entry using AutoFill Sorting columns 2 Inserting function Inserting function calculators Using AutoSum to sum numbers Statistical calculations AVERAGE, MAX and MIN 3 Table rows and columns Inserting and deleting rows and columns Adjusting multiple column widths and row heights Hiding and unhiding rows and columns 4 Formula writing The basics of formula writing Understanding mathematical symbols Using multiple mathematical symbols in a formula When to use brackets Troubleshooting calculation errors 5 Managing sheets Inserting, renaming, moving and deleting sheets Copying a worksheet to another file Copying a table to another sheet 6 Managing content formats Applying data formats Managing number formats Controlling formats with the Format Painter 7 Managing larger tables Applying freeze panes to lock tables when scrolling Sorting on multiple columns Using filters to extract table information 8 Creating and modifying charts Creating a pie chart Creating a column chart Inserting chart titles and data labels Controlling chart formatting Changing chart types 9 Printing Previewing and printing tables and charts Modifying page orientation Adjusting print margins Printing a selection 10 Calculating with absolute reference The difference between a relative and absolute formula Changing a relative formula to an absolute Using $ signs to lock cells when copying formulas 11 Pivot tables Create a pivot table report Insert a pivot chart into a report

This Microsoft Office 2007 Excel Intermediate will provide you with experience at creating more elaborate worksheet and workbooks n Microsoft Office Excel 2007 to display data in more effective ways. In this series you will work with multiple worksheets and workbooks, you will learn how to switch between workbooks and even copy worksheets, you will also get 3D formulas: 3D formulas will allow you to link the worksheets, and also add something call the Watch-Window. You will learn to create and manage all these linked workbooks as well as creating workspaces which will allow you to manage the workbook as well. Before getting this course you must have the basic skills of Microsoft Excel 2007. This level will give you an advanced knowledge you need to know about Microsoft Excel. Who is this Course for? Microsoft Office 2007 Excel Intermediate 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. Course Curriculum Using Multiple Worksheets and Workbooks Using Multiple Workbooks 00:04:00 Linking Worksheets with 3-D Formulas 00:06:00 Linking Workbooks 00:11:00 Managing Workbooks 00:04:00 Advanced Formatting Using Special Number Formats 00:17:00 Using Functions to Format Text 00:13:00 Working with Styles 00:07:00 Working with Themes 00:11:00 Other Advanced Formatting 00:13:00 Outlining and Subtotals Outlining and Consolidating Data 00:11:00 Creating Subtotals 00:06:00 Cell and Range Names Creating and Using Names 00:12:00 Managing Names 00:04:00 Lists and Tables Examining Lists 00:03:00 Sorting and Filtering Lists 00:07:00 Advanced Filtering 00:12:00 Working with Tables 00:22:00 Web and Internet Features Saving Workbooks as Web Pages 00:11:00 Using Hyperlinks 00:04:00 Distributing Workbooks 00:03:00 Advanced Charting Chart Formatting Options 00:08:00 Combination Charts 00:05:00 Graphic Elements 00:09:00 Documenting and Auditing Auditing Features 00:05:00 Creating A Body Of Work 00:03:00 Protection 00:05:00 Workgroup Collaboration 00:13:00 Templates and Settings Application Settings 00:05:00 Built-in Templates 00:07:00 Creating and Managing Templates 00:10:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Duration 1 Days 6 CPD hours This course is intended for This course is intended for people in a variety of roles and fields who have a basic understanding of Microsoft Office and want to incorporate digital note-taking and note collaboration by using Microsoft OneNote. In addition to creating and modifying OneNote notebooks, this course will introduce you to inserting images and embedding files into notebooks, categorizing content, sharing content with OneDrive, and exporting content to other file formats. Overview In this course, you will develop digital note-taking skills by creating, modifying, and managing OneNote notebooks that work with other Microsoft Office programs. You will: Navigate and customize the OneNote interface and environment. Add and format text, images, audio, links, and drawing objects to a notebook. Embed Excel spreadsheets and attach other files to a notebook. Categorize, organize, and search notebook content. Check spelling in, print, and password-protect notebooks. Use Outlook and OneDrive to send and share notebook content. Export notebook content and manage notebook history and backups. In our fast-paced digital world, the need to capture ideas, meeting notes, and to-do items is ever present. Microsoft© Office OneNote© for the Desktop provides a way for you to efficiently create and collect your notes in an electronic notebook. This course will introduce you to using OneNote notebooks to store a wide variety of content in an organized structure, access the content from anywhere, and also share it with others. Additionally, learning how OneNote and the other applications in the suite are integrated increases your productivity with Microsoft Office. This courseware is applicable to all users of the current OneNote desktop software. The classroom environment setup is based on the Office 2016 desktop application. Getting Started with OneNote Topic A: Navigate the OneNote 2016 Environment Topic B: Use Templates Topic C: Customize the OneNote User Interface Adding and Formatting Notebook Content Topic A: Apply Formatting to Notebook Content Topic B: Insert Images and Audio into a Notebook Topic C: Add Quick Notes and Links Topic D: Use Drawing Tools Embedding and Attaching Files Topic A: Embed Excel Spreadsheets Topic B: Attach Other File Types Organizing and Searching Notebooks Topic A: Use Tags Topic B: Organize and Search Notebooks Finalizing a Notebook Topic A: Proof and Print a Notebook Topic B: Configure Password Protection and Notebook Properties Managing Notebook Files Topic A: Export Content from OneNote Notebooks Topic B: Back Up and Restore Notebook Content Sending and Sharing OneNote Content Topic A: Send OneNote Content in Other Formats Topic B: Share OneNote Content by Using OneDrive

Duration 1 Days 6 CPD hours This course is intended for This course is intended for people in a variety of roles and fields who have a basic understanding of Microsoft 365 and want to incorporate digital note taking and note collaboration by using Microsoft OneNote. Overview In this course, you will develop note-taking skills by creating, modifying, and managing OneNote notebooks that work with other Microsoft 365 applications. You will: Navigate and customize the OneNote environment and create your first notebook. Add and format various types of notes and note elements, including text, links, and drawing objects. Add images, video, audio, Excel spreadsheets, and other types of files to a notebook. Organize, categorize, and search notebook content. Finalize notebook content by checking spelling, printing copies, and password-protecting notebooks. Manage notebooks by exporting content and working with history and backups. Share notebooks using Outlook and collaborate with colleagues using OneDrive. In our fast-paced digital world, the need to capture ideas, meeting notes, and to-do items is ever present. Microsoft's OneNote app provides a way for you to efficiently create and collect your notes in an electronic notebook. This course will help you use OneNote notebooks to store a wide variety of content in an organized structure, access the content from anywhere, and also share it with others. Additionally, learning how OneNote and other applications in the Microsoft 365 suite are integrated will increase your productivity. Lesson 1: Getting Started with OneNote Topic A: Navigate the OneNote Environment Topic B: Create Notebook Pages from Page Templates Topic C: Customize the OneNote User Interface Lesson 2: Adding and Formatting Notebook Content Topic A: Format Notebook Content Topic B: Add Quick Notes and Linked Notes to a Notebook Topic C: Use Drawing Tools in a Notebook Topic D: Use Dictation in a Notebook Lesson 3: Adding Files to Notebooks Topic A: Insert Images, Video, and Audio into a Notebook Topic B: Embed Excel Spreadsheets in a Notebook Topic C: Attach Other File Types to a Notebook Lesson 4: Organizing Notebook Content Topic A: Use Tags to Categorize Notes Topic B: Organize and Search Notebooks Lesson 5: Finalizing Notebooks Topic A: Proof and Print a Notebook Topic B: Configure Password Protection and Notebook Properties Lesson 6: Managing Notebooks Topic A: Export Content from a Notebook Topic B: Manage Notebook History Lesson 7: Sharing OneNote Content Topic A: Send Notebook Pages to Others Topic B: Work with Integrated Outlook Features Topic C: Collaborate on Notebooks Additional course details: Nexus Humans Microsoft OneNote (Desktop App) 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 Microsoft OneNote (Desktop App) 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.

Duration 1 Days 6 CPD hours This course is intended for This basic course is for: Business Analyst Systems Engineer Software Engineer Requirements Engineer Requirements Manager Requirements Team Leader Overview Build projects in DOORS, including defining data structure, linking schema, attributes, and access permissions Use DOORS external linking facilities Share DOORS information with 3rd parties Control the flow of changes through your DOORS database Apply configuration management and backup strategies to your DOORS data This course builds on the content learned in the IBM Engineering Requirements Management DOORS V9.6 Foundation course. It is designed for those who will be in the role of team lead or project manager, or who want to learn more about advanced DOORS end-user functionality. It discusses creating and structuring DOORS projects, defining linking relationships and attributes, setting access permissions, and managing change. It also discusses external linking, working with spreadsheets, and applying configuration management strategies to DOORS data. Course Outline Build projects in DOORS, including defining data structure, linking schema, attributes, and access permissions Use DOORS external linking facilities Share DOORS information with 3rd parties Control the flow of changes through your DOORS database Apply configuration management and backup strategies to your DOORS data

Duration 3 Days 18 CPD hours This course is intended for Before taking this course delegates should already be familiar with basic analytics techniques, comfortable with basic data manipulation tools such as spreadsheets and databases and already familiar with at least one programming language Overview This course teaches delegates who are already familiar with analytics techniques and at least one programming language how to effectively use the programming language for three tasks: data manipulation and preparation, statistical analysis and advanced analytics (including predictive modelling and segmentation). Mastery of these techniques will allow delegates to immediately add value in their work place by extracting valuable insight from company data to allow better, data-driven decisions. Outcomes: After completing the course, delegates will be capable of writing production-ready R code to perform advanced analytics tasks enabling their organisations make better, data-driven decisions. Becoming a world class data analytics practitioner requires mastery of the most sophisticated data analytics tools. These programming languages are some of the most powerful and flexible tools in the data analytics toolkit. Topic 1 Intro to our chosen language Topic 2 Basic programming conventions Topic 3 Data structures Topic 4 Accessing data Topic 5 Descriptive statistics Topic 6 Data visualisation Topic 7 Statistical analysis Topic 8 Advanced data manipulation Topic 9 Advanced analytics ? predictive modelling Topic 10 Advanced analytics ? segmentation

Duration 1 Days 6 CPD hours This course is intended for This course is designed for business users, educators, students, and knowledge workers in a variety of roles and fields who want to be able to use the apps included in Google Workspace to create and manage various types of files and communicate and collaborate with colleagues. Overview In this course, you will use the various apps included in Google Workspace to work productively as part of a team. You will: Navigate the Google Workspace environment and use Gmail to send and manage email correspondence. Manage schedules using Google Calendar™. Communicate with colleagues over text, voice, and video using Google Chat and Google Meet. Store and share files using Google Drive. Collaborate on documents using Google Docs, Google Slides™, and Google Keep™. Collaborate on data using Google Sheets and Google Forms™. Collaborate on websites using Google Sites™. The core productivity apps that make up the Google Workspace? suite enable users to work together on a variety of projects and tasks across many different industries and job roles. This course will teach you how to work efficiently and effectively in apps like Gmail?, Google Drive?, Google Docs?, Google Sheets?, Google Meet?, Google Chat?, and more?all while participating in a collaborative team environment. Lesson 1:Getting Started with Google Workspace Topic A: Navigate Google Workspace Topic B: Send and Manage Email Using Gmail Lesson 2:Managing Schedules Using Google Calendar Topic A: Create and Manage Events Topic B: Customize Calendars Topic C: Create and Share Calendars Topic D: Create and Manage Tasks Lesson 3:Communicating Using Google Chat and Google Meet Topic A: Chat Using Google Chat Topic B: Participate in Meetings Using Google Meet Lesson 4:Storing and Sharing Files Using Google Drive Topic A: Add Files and Folders Topic B: Manage Files and Folders Lesson 5:Collaborating on Documents Using Docs, Slides, and Keep Topic A: Create and Edit Documents Using Google Docs Topic B: Design Presentations Using Google Slides Topic C: Take Notes Using Google Keep Lesson 6:Collaborating on Data Using Sheets and Forms Topic A: Create and Manage Spreadsheets Using Google Sheets Topic B: Design Surveys Using Google Forms Lesson 7:Collaborating on Websites Using Sites Topic A: Create and Edit Sites Topic B: Share and Publish Sites