38 Google Sheets courses

Course Overview Make your critical data easier to follow with dashboards displaying the main insights when you train to use Data Analytics with Google Data Studio. Sometimes analysts find that their collated information on Google Sheets is not viewed subjectively by clients or that they take unexpected conclusions from it. You can learn to eliminate this possibility by utilising the functions of Google Data Studio (GDS), the premier online tool for converting data into customisable informative reports and dashboards for easy perusal. This Data Analytics training provides a total learning curve for GDS and how to get the very best results from it. You will be taught the basic functions of Google Sheets, including queries and calculations. Following this, you will be given a masterclass on GDS itself, from its field calculation abilities to its layout design and accommodating a client's page requirements. With this expert tuition, you will be able to effortlessly format data and underline all of the key findings with a simple click or touch of the screen. Make your data speak volumes with this valuable course. This best selling Data Analytics with Google Data Studio has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Data Analytics with Google Data Studio is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Data Analytics with Google Data Studio 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 Data Analytics with Google Data Studio 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 Data Analytics with Google Data Studio, 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 Data Analytics with Google Data Studio 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 Data Analytics with Google Data Studio 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.

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 Additional course details: Nexus Humans Google WorkSpace 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 Google WorkSpace 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.

🚀 Unlock Your Productivity Potential with 'Maximizing Efficiency Through Google Applications' Online Course! 🚀   Are you tired of drowning in a sea of unorganized emails, scattered documents, and missed deadlines? Do you wish there was a magic wand to transform your work life into a seamless, efficient, and highly productive experience?   Look no further! Introducing our groundbreaking online course: 'Maximizing Efficiency Through Google Applications.' 🌐✨   🔥 What's Inside? 🔥   🚀 Master the Power of Gmail: Say goodbye to email overwhelm! Learn advanced techniques to streamline your inbox, automate responses, and effortlessly manage your communication flow.   🗂️ Google Drive Mastery: Discover the art of collaborative document creation and storage. Unleash the full potential of Google Drive to keep your files organized, accessible, and secure.   📅 Calendar Control: Never miss a deadline again! Maximize your scheduling efficiency with Google Calendar hacks, enabling you to manage your time like a pro.   📊 Data Dominance with Google Sheets: Turn raw data into actionable insights! Dive deep into Google Sheets and unlock the secrets of data analysis and visualization.   🤖 Automation Awesomeness with Google Apps Script: Become a Google Apps Script wizard! Automate repetitive tasks and customize your Google Apps to work seamlessly for you.   🎯 Optimize Your Workflows: Discover how to integrate various Google Applications to create personalized, efficient workflows tailored to your specific needs.   💼 Business Boost: Explore how Google Applications can supercharge your business operations, enhance collaboration, and drive success.   🎓 Expert-Led Learning: Benefit from the expertise of industry professionals who have mastered the art of productivity through Google Applications. Learn from real-world examples and practical scenarios.   🌐 Accessible Anytime, Anywhere: Our online course is designed to fit your busy schedule. Access the materials whenever and wherever it suits you, and progress at your own pace.   🏆 Transform Your Professional Life: By the end of this course, you'll not only be a Google Applications pro but also a productivity powerhouse. Transform your professional life and achieve more than you ever thought possible!   🚨 Don't Miss Out! Enroll Now and Take Control of Your Productivity Destiny! 🚨   Ready to revolutionize the way you work? Click the link below and embark on a journey to maximize efficiency through the unparalleled power of Google Applications!   🌟 Join the ranks of successful professionals who have harnessed the full potential of Google Applications. Your optimized, efficient, and productive future starts now! 🌟   Course Curriculum Basic Overview 00:00 Base Account Settings 00:00 G-Mail 00:00 G-Mail Productivity 00:00 Google Tasks 00:00 Desktop and Mobile Synchronization 00:00 Google Sites 00:00 Google Voice for Audio Contact and SMS 00:00 Google Voice for Business Tracking 00:00 Google Photos and Google Sites 00:00 Google Photos 00:00 Allo-Hangouts and Messenges 00:00 Google Duo for Video Calling 00:00 Chrome Remote Desktop 00:00 Google Keep 00:00 Google Drive 00:00 Google Calendar for Collaboration 00:00 Google Custom Search 00:00 Export Google Docs To WordPress 00:00 Conclusion 00:00 Advanced Overview 00:00 Create Text With Voice Typing 00:00 Record Audio in Google Chrome 00:00 Publish Audio On Google Podcasts 00:00 Publish Books on Google Play 00:00 Google Docs for Shared Word Processing 00:00 Google Sheets for Shared Calcualtion 00:00 Import and Export with Excel 00:00 Google Slides for Shared Presentations 00:00 Import and Export with PowerPoint 00:00 Recording A Voice Over with Google Slides 00:00 Presenting Live Using Google Slides 00:00 Google Hangouts for Real Time Video 00:00 Create Branded Video Content With YouTube 00:00 Create Branded Video Content For YouTube 00:00 Publishing Indexed (Google) Documents 00:00 Google Research Tools 00:00 Citation of Sources 00:00 Using Blogger 00:00 Conclusion 00:00

In this course, we will learn about the Google Apps Script to create custom functions within G Suite that will help you increase your productivity. This course contains 100+ coding examples. For this course, you need JavaScript and basic HTML and CSS knowledge, a Google account, and a basic web development understanding.

Duration 2 Days 12 CPD hours Overview Identify and configure basic functions of Tableau. Connect to data sources, import data into Tableau, and save Tableau files Create views and customize data in visualizations. Manage, sort, and group data. Save and share data sources and workbooks. Filter data in views. Customize visualizations with annotations, highlights, and advanced features. Create and enhance dashboards in Tableau. Create and enhance stories in Tableau As technology progresses and becomes more interwoven with our businesses and lives, more and more data is collected about business and personal activities. This era of "big data" has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage. The creation of data-backed visualizations is a key way data scientists, or any professional, can explore, analyze, and report insights and trends from data. Tableau© software is designed for this purpose. Tableau was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Tableau's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. Prerequisites To ensure your success in this course, you should have experience managing data with Microsoft© Excel© or Google Sheets?. Lesson 1: Tableau Fundamentals Topic A: Overview of Tableau Topic B: Navigate and Configure Tableau Lesson 2: Connecting to and Preparing Data Topic A: Connect to Data Topic B: Build a Data Model Topic C: Save Workbook Files Topic D: Prepare Data for Analysis Lesson 3: Exploring Data Topic A: Create Views Topic B: Customize Data in Visualizations Lesson 4: Managing, Sorting, and Grouping Data Topic A: Adjust Fields Topic B: Sort Data Topic C: Group Data Lesson 5: Saving, Publishing, and Sharing Data Topic A: Save Data Sources Topic B: Publish Data Sources and Visualizations Topic C: Share Workbooks for Collaboration Lesson 6: Filtering Data Topic A: Configure Worksheet Filters Topic B: Apply Advanced Filter Options Topic C: Create Interactive Filters Lesson 7: Customizing Visualizations Topic A: Format and Annotate Views Topic B: Emphasize Data in Visualizations Topic C: Create Animated Workbooks Topic D: Best Practices for Visual Design Lesson 8: Creating Dashboards in Tableau Topic A: Create Dashboards Topic B: Enhance Dashboards with Actions Topic C: Create Mobile Dashboards Lesson 9: Creating Stories in Tableau Topic A: Create Stories Topic B: Enhance Stories with Tooltips

Duration 1 Days 6 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who receive Tableau data visualizations from data analysts or from data visualization engineers. These data report recipients want to take advantage of the many Tableau features and capabilities that enable them to explore the data behind the initial analysis, perform additional analysis to ask next-level questions of the data, and to customize visualizations and dashboards to share new insights and create compelling reports. Overview Explore Tableau reports. Analyze data to get answers and insights. Sort and group data for analysis and reporting. Filter views. Prepare reports. Troubleshoot, collaborate, and share views and analysis As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and the computing power to analyze it has increased the use of data analysis and data visualization across a broad range of job roles. Decision makers of all types, including managers and executives, must interact with, interpret, and develop reports based on data and analysis provided to them. Tableau© software is designed for data analysis and the creation of visualizations. Data analysts prepare data, perform initial analysis, and create visualizations that are then passed on to business data-driven decision makers. These decision makers can use Tableau's tools to explore the data, perform further analysis to find new insights, make decisions, and create customized reports to share their findings. Prerequisites To ensure your success in this course, you should have experience managing data with Microsoft© Excel© or Google Sheets? Lesson 1: Exploring Tableau Reports Topic A: Data Analysis Workflow with Tableau Topic B: Explore Views Topic C: Edit Workbooks Lesson 2: Analyzing Data to Get Answers and Insights Topic A: Configure Marks with the Marks Card Topic B: Ask New Questions by Changing Aggregation Topic C: Find Answers with Calculations Topic D: Answer Questions with Table Calculations Lesson 3: Sorting and Grouping Data for Analysis and Reporting Topic A: Sort Data Topic B: Group Data Lesson 4: Filtering Views Topic A: Filter Data to Refine Analysis Topic B: Create Interactive Filters for Reports Lesson 5: Preparing Reports Topic A: Format and Annotate Views to Tell Your Story Topic B: Emphasize Data in Reports Topic C: Animate Visualizations for Clarity Lesson 6: Troubleshooting, Sharing, and Collaborating Topic A: Troubleshoot Data Issues Topic B: Collaborate in Tableau Online Topic C: Collaborate with Non-Tableau Users

Duration 1 Days 6 CPD hours This course is intended for This course is designed for professionals in a variety of job roles who receive Power BI data visualizations and reports from data analysts or from data visualization engineers. These data report recipients want to use the features and capabilities of Power BI to fully explore the visualizations and initial analyses provided to them in reports, perform additional analysis to ask next-level questions of the data, and to customize and create new visualizations and dashboards in order to share new insights and create compelling reports. Overview Explore Power BI reports. Analyze data to get answers and insights. Sort and group data for analysis and reporting. Filter visualizations. Prepare reports. Troubleshoot, collaborate, and share reports. As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and the computing power to analyze it has increased the use of data analysis and data visualization across a broad range of job roles. Decision makers of all types, including managers and executives, must interact with, interpret, and develop reports based on data and analysis provided to them. Microsoft Power BI software is designed for data analysis and the creation of visualizations. Data analysts prepare data, perform initial analysis, and create visualizations that are then passed to business data decision makers. These decision makers can use Power BI's tools to explore the data, perform further analysis to find new insights, make decisions, and create customized reports to share their findings. Prerequisites To ensure your success in this course, you have experience managing data with Microsoft Excel or Google Sheets 1. Exploring Power BI Reports Topic A: Data Analysis Workflow with Power BI Topic B: Explore Reports in the Power BI Service Topic C: Edit Reports 2. Analyzing Data to Get Answers and Insights Topic A: Configure Data Visualizations Topic B: Ask New Questions by Changing Aggregation Topic C: Find Answers with Calculations 3. Sorting and Grouping Data for Analysis and Reporting Topic A: Sort Data Topic B: Group Data 4. Filtering Visualizations Topic A: Filter Data to Refine Analysis Topic B: Create Slicers for Reports 5. Preparing Reports Topic A: Format and Annotate Reports Topic B: Emphasize Data in Reports 6. Troubleshooting, Sharing, and Collaborating Topic A: Troubleshoot Data Issues Topic B: Collaborate in Power BI Topic C: Collaborate with Non-Power BI Users

Register on the Google Data Studio: Data Analytics 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 Google Data Studio: Data Analytics 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 Google Data Studio: Data Analytics 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 Google Data Studio: Data Analytics, 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 Section 01: Introduction Course Overview 00:01:00 Section 02: Google Sheets Format Data in Google Sheets 00:08:00 Sheets Function 2: Vlookup & Defined Range 00:10:00 Sheets Function 3: Cross Table Calculations 00:09:00 Section 03: Google Data Studio Connect Data to Google Data Studio 00:04:00 GDS Calculated Fields 00:08:00 GDS Theme Customization 00:07:00 GDS Page Layout Design 00:17:00 GDS Charts: Scorecards 00:12:00 GDS Charts: Time Series Graphs 00:09:00 GDS Blending and Joining Data Tables 00:07:00 GDS Charts: Bar, Donut, and Treemap 00:17:00 GDS Charts: Interactive Filters 00:05:00 GDS Project Page Completion 00:17:00 GDS Client Page Completion 00:11: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.

Give a compliment to your career and take it to the next level. This Logistics bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop Logistics skills for your next job or elevate your skills for your next promotion, this Logistics bundle will help you stay ahead of the pack. Along with this Logistics course, you will get 19 premium courses, an original hardcopy, 20 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Logistics Bundle Consists of the following Premium courses: Course 01: Logistic Management Course 02: Transport Management Diploma Course 03: Purchasing & Procurement Course - Level 3 Course 04: Commercial Law Course 05: Supply Chain Management Course 06: Material Management Course 07: Inventory Controller Course 08: Warehouse Safety Course 09: Delivery Driver Training Course 10: Driver Safety Awareness Certificate Course 11: Spill Management Training Course 12: Logistics of Crude Oil and Petroleum Products Course 13: Certificate in Anti Money Laundering (AML) Course 14: Process Improvement: Reduce Waste Course 15: Operation Management and Retailing Course 16: Retail Management - Level 5 Course 17: People Management Skills Level 3 Course 18: Bookkeeping Tool : Google Sheets Course 19: Paralegal Course 20: Time Management Enrol now in Logistics to advance your career, and use the premium study materials from Apex Learning. The Logistics bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Logistics expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn Logistics from any place in your own time without travelling for classes. Logistics Course Curriculum Logistic Management Module 01: Introduction to Logistic Management Module 02: Planning Framework for Logistics Module 03: Supply Chain Management Module 04: Logistics Management and Organisation Module 05: Sourcing, Purchasing, and Procurement Module 06: Channels of Distribution Module 07: Supplier Relationship Management Module 08: Inventory Planning and Management Module 09: Principles of Warehousing Module 10: Transport Management Module 11: Negotiation Techniques Module 12: Customer Service and Logistics Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Logistic Management Course: Previously it was £10) CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Logistics bundle. Requirements This Logistics course has been designed to be fully compatible with tablets and smartphones. Career path Having Logistics expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course Logistic Management absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Overview This comprehensive course on Google Data Studio: Data Analytics will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Google Data Studio: Data Analytics comes with accredited certification from CPD, 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 Google Data Studio: Data Analytics. It is available to all students, of all academic backgrounds. Requirements Our Google Data Studio: Data Analytics is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 4 sections • 17 lectures • 02:32:00 total length •Course Overview: 00:01:00 •Format Data in Google Sheets: 00:08:00 •Sheet Functions 1: Query & Import Range: 00:07:00 •Sheets Function 2: Vlookup & Defined Range: 00:10:00 •Sheets Function 3: Cross Table Calculations: 00:09:00 •Connect Data to Google Data Studio: 00:04:00 •GDS Calculated Fields: 00:08:00 •GDS Theme Customization: 00:07:00 •GDS Page Layout Design: 00:17:00 •GDS Charts: Scorecards: 00:12:00 •GDS Charts: Time Series Graphs: 00:09:00 •GDS Blending and Joining Data Tables: 00:07:00 •GDS Charts: Bar, Donut, and Treemap: 00:17:00 •GDS Charts: Interactive Filters: 00:08:00 •GDS Project Page Completion: 00:17:00 •GDS Client Page Completion: 00:11:00 •Additional Resources - Google Data Studio: Data Analytics: 00:00:00