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.
DurationWho Is This Course For?
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.
Prerequisites
A working knowledge of Excel or our Excel Intermediate course.
Benefits
At the end of this advanced Excel course you will have a complete understanding of the higher functions of Excel.
You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and 'advanced' analysis, record macros and integrate with other office applications.
Course Syllabus
Using logical functions
The IF function (recap)
Creating nested IF functions
The IFS function
AND and OR functions
Combining logical functions
Working with Lookups
The VLOOKUP function
The HLOOKUP function
The XLOOKUP function (365)
INDEX & MATCH
Data Validation
Using data validation
Setting criteria for entry of text, values and dates
Creating a dropdown list
PivotTables and PivotCharts
Creating and rearranging PivotTables
Using the PivotTable toolbar
Creating PivotCharts
Using Slicers to manipulate PivotTables
Using analytical options
Using Goal Seek
Creating, saving and viewing scenarios
Creating single input data tables
Creating double input data tables
Projecting with data tables
Macros
Creating macros
Using the macro recorder
Viewing and editing macro VBA code
We seek to provide an unrivalled value and quality service, enabled by our unique business model. We are excited to announce that we have resumed face-to-face training both on our public schedule and onsite.
We're here to help - from Managing Teams Remotely, using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch, to leadership & development programmes.
The professionalism and performance of our people is fundamental to us. Our company culture brings together individuals that cooperate through trust. Bureaucracy and micro-management are kept to a minimum. No photocopiers exist and only essential paper documents are retained.
Our working relationships are typified by their openness and the common goal to achieve the best performance in our industry, both personally and organisationally. The team enjoys a high level of decision making authority, allowing flexibility and creativity.
By working with individuals that have the passion and integrity to deliver, the management team is freed from policing and able to focus on continuous improvement. Feedback to drive quality development is continuously applied from a 100% client satisfaction sampling system.
Course is intended for those familiar the basics of VBA who want to develop their knowledge and greater use of language capabilities. The course is designed for users of Excel for creating analyzes and reports.
On successful completion of the course, delegates will be able to quickly create high-impact, dynamic presentations, while integrating workflow.
Microsoft Office Editions, the easiest way to help more people use information to make a positive impact on business. The Office Editions offer great technologies and features while improving upon existing and familiar tools to facilitate effective and efficient collaboration and information sharin...
At this introductory level, participants will learn all the everyday tasks and features within Microsoft Outlook. It is a complicated and large application and delegates will finish the day with a clear understanding of all the E-Mail features and general navigation and uses.
In this Introduction to Microsoft Access training course delegates will then learn to design and create databases and tables, query those tables, and create forms and reports.
About Coursetakers.com
Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the UK, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy
Online
USA
UK
India
UAE
South Africa
Canada
New Zealand
Australia
Malaysia
Singapore
Saudi Arabia
Egypt
Jordan