CAPP07018 2022 Business Computer Applications

This module is centred on using computers to capture and manage data efficiently and use that data to support effective decision-making in an organisation. The overall aim of the module is to give the learner the advanced skills required to utilise data effectively. The learner will therefore develop their analytical and digital literacy skills by building on their previous experience of computer applications to an advanced level.

The learner will gain the advanced skills required to organise and analyse data using a spreadsheet application and use this data to produce reports that are reflective of those required in modern organisations. In addition to using advanced formulas and functions, this module covers visualisation of data through creating and formatting graphs or charts. The learner will also advance their experience of using databases and will create a database that reflects the needs of an organisation and be able to capture and extract data from a database that supports business decisions.

This is learning made easy. Get more done quickly with Office 365. Jump in wherever you need answers - brisk lessons and colorful screenshots show you exactly what to do, step by step. Covers Word, Excel, PowerPoint, and Outlook Format Word documents for maximum visual impact Build powerful, reliable Excel workbooks for analysis and reporting Prepare highly effective PowerPoint presentations Use Outlook to organize your email, calendar, and contacts Includes downloadable practice files

Conquer Microsoft Excel -- from the inside out! Dive into Microsoft Excel -- and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds -- all you need to make the most of Excel's most powerful tools for analyzing data and making better decisions. Renowned Excel experts Bill Jelen and Paul McFedries offer a complete tour of Excel in Office 365, from efficient interface customizations to advanced analysis, visualizations, and dashboards. Discover how experts tackle today's key tasks -- and challenge yourself to new levels of mastery. Topics include: Customizing the Excel workspace Best practices for designing and managing worksheets Creating formulas and functions Performing statistical, what-if, and other data analysis Core to advanced charting techniques Using graphics and sparklines Managing databases and tables Automating Excel with macros and custom functions Collaborating in Excel online, in the cloud, and more Extending Excel

Master business modeling and analysis techniques with Microsoft Excel, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables--and how to effectively build a relational data source inside an Excel workbook.

Learn how to use Excel pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you've never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power--including valuable improvements in Excel and in Office 365. Drawing on more than 45 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical recipes for solving real business problems, help you avoid common mistakes, and present tips and tricks you'll find nowhere else.

The quick way to learn Microsoft Excel! This is learning made easy. Get more done quickly with Microsoft Excel. Jump in wherever you need answers-brisk lessons and detailed screenshots show you exactly what to do, step by step. Quickly set up workbooks, enter data, and format it for easier viewing Perform calculations and find and correct errors Create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines Visualize data with 3D maps, funnel charts, and other powerful tools Import, process, summarize, and analyze huge datasets with Excel's improved PowerPivot and Power Query Build powerful data models and use them in business intelligence Look up just the tasks and lessons you need

The Exploring Microsoft Office 365 series moves students beyond rote tasks to a deeper comprehension of how, when, and why to apply Office skills. A market leader for over 20 years, the collection helps students achieve high-level learning outcomes by engaging them in the way they learn best - through hands-on practice. A dozen exercises in each chapter range from multiple-choice questions to open-ended projects. Revised to reflect Microsoft Office 365, the 2019 edition adds new critical thinking assignments to help students build fundamental 21st-century skills -- Provided by the publisher.

https://www.linkedin.com/learning/