This Excel introductory course will enable delegates to gain a good general understanding of the main features of Microsoft Excel, giving them the ability to produce standard spreadsheets, create formulae and format and print spreadsheets.
Courses > IT > Most Popular > Excel
Excel Courses
- Filter activated Remove filter
- Showing favourite courses only Remove filterGo to favourites
-
-
Overview: Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data.
This Excel introductory course will enable delegates to gain a good general understanding of the main features of Microsoft Excel, giving them the ability to produce standard spreadsheets, create formulae and format and print spreadsheets.Public Scheduled Dates: Public scheduled prices per delegate. All prices +VAT<>Private Courses: Private courses start from£645 for up to8 delegates -
Overview: In Microsoft Office Excel Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target students for this course are students who desire to gain the skills necessary to create spreadsheets from scratch using more advanced functions and formulas, sort and filter data, analyse data and present data in visual and vibrant ways.Public Scheduled Dates: Public scheduled prices per delegate. All prices +VAT<>Private Courses: Private courses start from£645 for up to8 delegates -
Overview: This course will benefit those who are already up to speed with Microsoft Excel but would now like to automate some common tasks and apply advanced analysis techniques to more complex data sets. This Excel course is aimed at anyone desiring to gain the skills necessary to create macros, audit and analyse worksheet data, create Excel PivotTables and Excel PivotCharts, use lookup tables and import and export data.Public Scheduled Dates: Public scheduled prices per delegate. All prices +VAT<>Private Courses: Private courses start from£645 for up to8 delegates -
Overview: This course is designed to introduce you to the Macro environment of Excel, it will provide you with the confidence to record macros in Excel and then be able to gain a better understanding of the code and make changes to it.
We even teach you some commands that cannot be recorded, such as how to show a message to the person who runs the macro.
It will not turn you into a fully-fledged programmer, but you will feel more confident in the Visual Basic Editor, and thus be able to explore more aspects of programming in Excel.
For example, if you record a macro before the course and you make a mistake in the recording, you invariably have to start the recording again. After this course you will be able to step through the code, decide what you wish to keep and what you wish to get rid of, then record an extra part and add it to the code you kept thus running all the code at once.
Important Note : An Excel Macro is created from lines of code of Visual Basic for Applications. These lines of code are stored in a collection called a 'Macro' or a 'Procedure'. It all depends on which angle you are coming from. If you're a programmer, you call these lines of code a Procedure; if you are an advanced user of Excel you call these lines of code a Macro.
Public Scheduled Dates: Public scheduled prices per delegate. All prices +VAT<>Private Courses: Private courses start from£745 for up to8 delegates -
Overview: This outline below contains an overview of a wide range of features within Excel that when used together can be used to create interactive visual reports and dashboards. The course will show delegates how these features can be used individually to present data but can also be used in combination to make powerful and insightful reports.
The course content has been pulled from a mix of our Excel courses, some content will be recapped to ensure all delegates are at the same level as they are used in conjunction with each other to effectively present data and build reports.Public Scheduled Dates: Public scheduled prices per delegate. All prices +VAT<>Private Courses: Private courses start from£645 for up to8 delegates -
Overview: This course is split into 3 main areas:
1. Get and Transform (Power Query)
2. Power Pivot - Data Models and DAX calculations
3. Dashboard Creation with Pivot Tables, Charts and Slicers
It is aimed at users who want to analyse data from multiple sources and want to create effective data dashboards.
This course will be delivered on Excel 2016 or above and using generic data files that aim to appeal to a wide audience.
Public Scheduled Dates: Public scheduled prices per delegate. All prices +VAT<>Private Courses: Private courses start from£745 for up to8 delegates -
Overview: This course is designed to help users get the most from the advanced functions in Excel. Advanced Lookup and Reference functions to help you gather data, Text functions to organise and validate the data, Logical functions to analyse the data. You will use the advanced features of Microsoft Excel to attain a high degree of proficiency as an Excel power user within the area of writing functions.Private Courses: Private courses start from£745 for up to8 delegates -
Overview: This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to modify Excel to be better suited to their environment, by creating their own functions and procedures.Public Scheduled Dates: Public scheduled prices per delegate. All prices +VAT<>Private Courses: Private courses start from£1790 for up to8 delegates -
You don't seem to have any favourites stored yet.
To add a favourite, please click on the heart next to any course in the course lists or in the right menu on a course page.
Please note if you delete your cookies, your favourites will disappear.
We are here to help you find the right training for you, please click here to contact us online or give us a call on 0191 377 8377
-
R.S. ENGIE Fabricom, Excel Level 1 Essentials
L.B. NEPO, Microsoft Power BI Desktop
B.J. Greencore Group, Train the Trainer Training Skills for the Workplace
L.F. Durham County Council, Google Ads
A.M. Riverford, Excel Essentials
L.H. Esh Group, Excel Level 3
C. V4 Services Ltd, Microsoft Teams in Office 365 Essentials
R.H. Welwyn Components Ltd, Train the Trainer Training Skills for the Workplace
D.K. Egger, Excel Level 2
M. , Project Management Essentials
M.C. Taylormade Timber, Microsoft Project Essentials
J.C. Lincolnshire Housing Partnership, Document Storage in Microsoft Office 365
V.H. Labour Party, Excel Level 2
M.B. MGL Group, Telephone Skills
J.F. Welwyn Components Ltd, Stress Management and Powering up Your Mental Resilience