Our Microsoft Excel Introductory course is designed to give the new spreadsheet user the skills to start using Excel in the workplace. From using simple formulas such as the SUM function to formatting data and the basics of spreadsheets.
Understanding Excel from the basics. Our Microsoft Excel Introductory course is designed to give the new spreadsheet user the skills to start using Excel in the workplace. From using simple formulas such as the SUM function to formatting data and the basics of spreadsheets.
The course covers topics such as creating a workbook, functions, filtering data, charting and more.
Learning Outcomes:
This is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.
At the completion of this course you should be able to:
navigate your way around Microsoft Excel 365
create and work with a new workbook
open and navigate within workbooks and worksheets
make changes to data in a workbook
understand and work with ranges in a worksheet
copy and paste data in Excel
use the fill operations available to fill a data series
move the contents of cells and ranges within and between workbooks
understand, create and work with formulas and functions
understand and use formula cell referencing
use font formatting techniques
align the contents of cells in a number of ways
understand and use the number formatting features in Excel
format rows and columns in a worksheet
work with elements that make up the structure of a worksheet
sort data in a list in a worksheet
filter data in a table
print your workbook data
create effective charts in Microsoft Excel
obtain help for Excel whenever you need it
This course assumes little or no knowledge of spreadsheets or Microsoft Excel. However, it would be beneficial to have a general understanding of personal computers and the operating system environment, especially in regard to working with files and folders.
As well as being subject matter experts, the people behind Applied Education are training professionals. That’s why each and every course we conduct has an intensely practical “learning by doing” emphasis, with no more than 12 participants per class. This gives you the maximum opportunity to develop and reinforce new skills, as well as ask questions.
Comprehensive training manuals and sample data files make it easy for you to apply your new skills in the workplace
As a matter of policy, all of our trainers are highly qualified professionals with a keen understanding of the real-life challenges you face every day. But as important as training techniques are, they are only part of the skills equation in today’s rapidly changing environment.
All courses offered by the Applied Education are updated regularly to reflect the latest in both software and professional techniques – and our course list reflects the dynamic requirements of our clients in many business sectors.
Our content is constantly updated and delivered by some of Australia’s finest specialist trainers. Applied Education is now one of Australia’s leading providers of training services.
Applied Education believes in:
With most businesses using Word, Excel and PowerPoint for various work requirements, employees must have the foundational skills needed to use Microsoft Office
Microsoft PowerPoint makes it easy to develop, and collaborate on, visually compelling presentations virtually anywhere. Find out more on how you can create impactful presentations using custom shapes, animations, and Smart Guide with our PowerPoint Training Courses.
We Will Customize To Your Learning Requirements And Timeframe
Learn the latest Excel features that are used by Excel Experts to get more done in less time. Discover how Dynamic Array Excel has REVOLUTIONISED how you can write formulas XLOOKUP has killed off VLOOKUP – learn why Power Query is the greatest improvement to Excel productivity ever… if you�...
Become an expert in using Microsoft Outlook 2016 on this training course! Learn how to create customised Outlook templates and forms. Because we come to you, we can cover any Microsoft Outlook topics on which you feel you need to know more
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy