This course is for those who are interested in learning how to create spreadsheets. Whether you prefer Mac or PC is not important because this course will be equally suitable for both.
Course Overview
The perfect beginners course for those who are self taught or have little to no experience. You want to pick up Excel like a PRO, and you’re in the right place!
This course is for those who are interested in learning how to create spreadsheets. Whether you prefer Mac or PC is not important because this course will be equally suitable for both.
Course Details
Getting started with Microsoft Excel
Introduction to Excel
Navigating the Excel Screen and Ribbon
Tips and Tricks for Selection and Movement around the screen
File Management
Creating and Saving Workbooks
Opening Workbooks
Data Input and Selection
Typing and Formatting for Text, Dates and Numbers
Selecting Cells, Rows and Columns using the Mouse and Keyboard shortcuts
Using Functions
Using the Sum, Average, Min, Max, Count Functions
Understanding and working with the Function Wizard
Working with Dates
Date Calculations
Formatting Dates
Copying and Moving Data/Formulae
Using Cut, Copy and Paste
AutoFill
Drag and Drop
Copy and Drop
Editing Worksheets
Adding Rows and Columns
Sizing Rows and Columns
Hiding/Unhiding Rows and Columns
Formatting Worksheets
Working with Fonts, Sizes and Colours
Adding Borders and Fill Colour to Cells
Aligning the Content of a Cell
Applying Number Formatting
Using the Format Painter
Merge and Unmerge Cells
Working with Large Worksheets
Freezing Panes
Working with Split Pane View
AutoFilter
Printing
Using Print Preview
Setting the Print Range
Sizing Spreadsheets to Fit
Working with Margins, Headers and Footers and other useful print settings
Multiple Sheets
Creating new Sheets
Colouring Sheet Tabs
Navigating Sheets
Deleting Sheets
Charts and Graphs
Creating Charts and Graphs alongside data
Creating Charts and Graphs on a new sheet
Changing the Chart Types
Basic Formatting of Charts and Graphs
Known for our exceptional levels of guidance, whenever candidates require advice or encouragement, we are by their side. It makes no difference whether you are taking part in employer-funded training or you are undertaking tuition independently.
If you want to vastly improve career prospects, gain promotion, return to work or simply stand out from the crowd, Acudemy will help you in a way that no-one else can.
Our training programs are insightful, high quality, high value and innovative. Delivering measurable impact and outstanding results.
We skillfully blend proven teaching practices with a consultative, result-centric outlook that emphasises the practical application of knowledge in line with each student’s strategic needs and aims.
Microsoft Excel training can be delivered for which ever version is required from 2007, 2010, 2013, or 2016, at three basic levels, Introduction, Intermediate, and Advanced.
Our Microsoft Excel Advanced course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features.
Whether you are a new user or have been using PowerPoint for years, this course will vastly increase your understanding of PowerPoint. Existing users will learn how to get the most out of PowerPoint, break any bad habits, learn shortcuts and discover a massive range of hints and tips from our exper...
In this beginner’s course, you will learn the fundamentals and basic concepts of Microsoft Excel. This will allow you to
n site Microsoft Word courses tailored to your needs, designed for businesses and professionals. All Microsoft Office Word versions including 2003, 2007, 2010, 2013, 2016 and Office 365 covered.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy