adams-academy-logo
Explore Courses
Get Certificate
Discover Careers
More

Microsoft Excel 2016 Part One

(12 students)

This course includes:

06:18:00 hours

CPD Accreditation

26 units

Full lifetime access

Access on mobile and TV

Certificate of completion

Share:
Training Express
Course Publisher

Training Express

Learning Outcomes

  • Identify and explain the elements of the Excel interface.
  • Create and manipulate worksheets and workbooks in Excel.
  • Apply formatting techniques such as cell styles, borders, and colours to cells.
  • Utilise functions and formulas to manipulate data and solve problems in Excel.
  • Customise Excel settings and options to improve functionality and efficiency.
  • Refine the page layout and apply print options to enhance the presentation.
  • Use the help system to troubleshoot issues and learn new features in Excel.

Course Overview

Our course covers the fundamentals of Excel, including creating basic worksheets, applying formatting techniques, using formulas and functions, and customising settings and options to improve functionality and efficiency. Individuals will also learn how to refine page layout, apply print options, and use the help system to troubleshoot issues and learn new features. Microsoft Excel is a vital tool for anyone who deals with data, whether for personal or professional purposes. With Microsoft Excel 2016 Part One, you will gain a solid foundation in this software, allowing you to create and manipulate worksheets and workbooks, apply formatting techniques, and use formulas and functions to solve problems. Additionally, you will learn how to customise Excel settings and options to improve efficiency and refine page layout to enhance the presentation.

Course Benefits

Microsoft Excel 2016 Part One offers numerous benefits to help individuals and organisations improve their wisdom in Excel. Individuals will learn how to create and manipulate worksheets and workbooks, apply formatting techniques, and use formulas and functions to solve problems. In addition, this course will equip participants with the wisdom, approaches and techniques necessary to customise Excel settings and options to improve efficiency and refine page layout to enhance the presentation. With Microsoft Excel 2016 Part One, participants will gain a competitive edge in the job market by acquiring high-demand industry insights. The knowledge learned in this course will enable individuals to work more efficiently and effectively with data, saving time and resources. Improve your career prospects and increase your earning potential with Microsoft Excel 2016 Part One.

Career Path

  • Financial Analyst - Analyze financial data using Excel to make informed business decisions.
  • Marketing Analyst - Analyze marketing data using Excel to measure performance and make data-driven decisions.
  • Project Manager - Use Excel to track project progress, monitor budgets, and analyse data to make informed decisions.
  • Business Intelligence Analyst - Use Excel to collect, analyse, and visualise data to inform business decisions.
  • Accountant - Use Excel to manage financial data and perform accounting tasks.
  • Sales Analyst - Analyze sales data using Excel to measure performance and identify growth opportunities.
  • Data Analyst - Use Excel to collect, analyse, and visualise data to inform business decisions.
Course content

Microsoft Excel 2016 Part One

01 Why Is Intrapreneurship Important

00:06:00

02 Use the Help System

00:11:00

03 Spell Check a Worksheet

00:08:00

04 Search for and Replace Data

00:23:00

05 Reuse Formulas

00:17:00

06 Refine the Page Layout and Apply Print Options

00:17:00

07 Modify Fonts

00:13:00

08 Manipulate Data

00:18:00

09 Manage Worksheets

00:20:00

10 Manage the View of Worksheets and Workbooks

00:21:00

11 Insert, Manipulate, and Delete Cells, Columns, and Rows

00:19:00

12 Insert Functions in a Worksheet

00:13:00

13 Identify the Elements of the Excel Interface

00:27:00

14 Define the Basic Page Layout for a Workbook

00:24:00

15 Customize the Ribbon and Quick Access Toolbar

00:05:00

16 Customize the Functionality of Excel by Enabling Add-Ins

00:10:00

17 Customize Proofing and Save Options

00:09:00

18 Customize General and Language Options

00:11:00

19 Customize Formula Options

00:04:00

20 Customize Advanced and Trust Center Options

00:06:00

21 Create Formulas in a Worksheet

00:11:00

22 Create a Basic Worksheet

00:35:00

23 Apply Number Formats

00:11:00

24 Apply Cell Styles

00:11:00

25 Align Cell Contents

00:15:00

26 Add Borders and Colors to Cells

00:13:00

Complete This CPD Accredited Course & Get Your Framed Certificate!

vector

Certify Your Skills

A CPD accredited Adams Diploma/Certificate certifies the skills you’ve learned.

Stand Out From The Crowd

Add your Adams Certification to your resume and stay ahead of the competition.

Advance in Your Career

Share your Adams Certification with potential employers to show off your skills and capabilities.

Certificate Promo

About Course Publisher

Training Express
Training Express

189 Courses

Training Express is a leading course provider, established by a dedicated team of experts working across the UK. We deliver accredited certification and training to UK businesses looking to improve organisational performance. Our comprehensive courses cover a broad range of sectors and industries, with a focus on promoting high standards of food hygiene, business wellbeing and safety in the workplace.

Adams Academy Logo

At Adams Academy, we're reinventing the online learning landscape by creating an immersive global platform with a wide range of engaging and top-notch courses. Our thriving learner and course provider community accommodates many interests and academic levels, building a culture where curiosity flourishes and potential is awakened.

Beaufort House, 15 St Botolph Street, London EC3A 7BB
Adams Learning facebook profile - /adamsacademylive
Twitter
Instagram
Linkedin
Google
Youtube
Youtube

© 2023 Adams Academy Inc. All rights reserved.