Name: Microsoft Excel Macros & VBA - In-company
Price: 750 GBP
Availability: InStock

London

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Record and edit a Macro</li><li>Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects.</li><li>Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures</li><li>Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope</li><li>Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks</li><li>Create an error handling routine in case things go wrong with VBA code</li></ul><p>' 1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Best Training Ever!</strong></li><li>Just finished a bespoke 1-1 training course in Excel Advanced, Macros &amp; VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability.</li></ul><ul><li>Amanda Morris - Treasury &amp; Systems Accountant at Reall - Real Equity for All</li></ul><ul><li><p><strong>The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience..</strong></p></li><li>Simon Harper - Lloyd's of London</li></ul><ul><li><p><strong>My learning experience was awesome.</strong></p></li><li>Perdinand Reagan - Subsea7</li></ul><ul><li><p><strong>Very nice and relaxed approach to teaching. Was definitely a good learning experience</strong><strong>.</strong></p></li><li>Jerome Pupe - S5 Agency World</li></ul><ul><li><strong>The Trainer – Very positive + patient + helpful + thorough</strong></li><li>Agnes Souza - Direct Wines</li></ul><p>'</p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> public, one to one, tailored and bespoke courses.</strong></p><ul><li><strong>Our competitive rates <strong>start from £550.00 per day of training</strong></strong></li></ul><p><strong><strong>Tailored training courses:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Introduction to Macros and VBA</strong></p><ul><li>Introducing Visual Basic for Applications</li><li>Recording a Macro</li><li>Naming conventions for Macro Procedures</li><li>Running a Macro</li><li>Absolute or Relative Cell Referencing</li><li>Saving and Opening Files with Macros</li><li>Making macros always available</li><li>Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes</li><li>Editing a Macro in the Visual Basic Editor</li><li>Understanding the Development Environment</li><li>Customising the Editor</li><li>Tips for General Typing in VBA</li><li>Using Visual Basic Help</li></ul><p><strong>Working with Procedures</strong></p><ul><li>Program Design</li><li>Understanding Modules</li><li>Naming Rules</li><li>Creating a Module</li><li>Understanding Procedures</li><li>Programming Macro Concepts</li><li>Creating a Subroutine</li><li>Creating a Function</li><li>Understanding Arguments</li><li>Exiting Procedures</li><li>Calling Procedures</li></ul><p><strong>Objects, Properties, Methods and Events</strong></p><ul><li>Understanding Objects Properties, Methods, and Events</li><li>Navigating the Object Hierarchy</li><li>Understanding Collections</li><li>Accessing a Member of a Collection</li><li>Understanding Hierarchy</li><li>Using the Object Browser</li><li>Using the With Statement</li><li>Working with Properties</li><li>Working with Methods</li><li>Creating an Event Procedure</li><li>Reserved Macro Names</li></ul><p><strong>Using Expressions, Variables and Intrinsic Functions</strong></p><ul><li>Understanding Expressions and Statements</li><li>Declaring Variables</li><li>Understanding Data Types</li><li>Determining the Value of Variables</li><li>Working with Variable Scope</li><li>Using Built-in VBA Functions</li><li>Understanding Constants</li><li>Using Message Boxes</li><li>Controlling the Answer to a Message Box</li><li>Using Input Boxes</li><li>Declaring and Using Object Variables</li></ul><p><strong>Controlling Program Execution</strong></p><ul><li>Understanding Control-of-Flow Structures</li><li>Using the If...End If Decision Structures</li><li>Nested If Statements</li><li>Using the Select Case ... End Select Structure</li><li>Using the Do ... Loop Structure</li><li>Using the For ... Next Structure</li><li>Using the For Each ... Next Structure</li><li>Guidelines for Use of Control-of-Flow Structures</li></ul><p><strong>Debugging and Handling Errors</strong></p><ul><li>Understanding Errors</li><li>Using Debugging Tools</li><li>Setting Breakpoints and Using Break Mode</li><li>Stepping Through Code</li><li>Trapping Errors with the On Error Statement</li><li>Understanding the Err Object</li><li>Working with Inline Error Handling</li><li>Writing an Error-Handling Routine</li></ul><p><strong>Working with Forms and Controls</strong></p><ul><li>Understanding UserForms</li><li>Creating a Form</li><li>Displaying and Removing a Form</li><li>Aligning and Sizing Controls</li><li>Using the Toolbox</li><li>Working with a Form's Properties, Methods, and Events</li><li>Working with Form and Control Properties, Methods and Event</li><li>Setting the Tab Order</li><li>Populating a Control</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates should have attended the Excel Advanced course.</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Office Training

Microsoft Excel Macros & VBA - In-company

General Admission

<h4>Excel Macros Certificate Course</h4>
<p><br />Finding out about Excel macros is vital for any individual who uses Excel at home or work. Regardless of whether you're hoping to build your overall Excel information or improve your abilities in the work environment, this course covers all you require. This course gives a thorough manual for Excel macros, including the references to utilize, and how to record and save macros. From proficient tips and counsel to top to bottom full scale classes and genuine equations you can quickly apply, this course covers all you require to think about each component of Excel macros.</p>
<p> </p>
<h4>You Will Learn:</h4>
<ul>
<li>A comprehensive definition of Excel macros and how they work</li>
<li>How to reference and record macros</li>
<li>How to run, name and save macros</li>
<li>Professional tips and expert advice</li>
<li>Macro categories and practical coding</li>
</ul>
<p> </p>
<h4>Benefits of Taking This Course:</h4>
<ul>
<li>You will save time and increase productivity</li>
<li>You will be able to interpret data faster and more effectively</li>
<li>You will learn basic VBA coding and how to make it work for you</li>
<li>You will be able to automate and optimise essential data</li>
<li>You will understand the security risks associated with macros</li>
</ul>
<ul></ul>

OnlineCoursesLearning.com

Excel Macros Certificate

<p><strong>Course Objectives</strong></p><p>At the end of this course you will be able to:</p><ul><li>Record and edit a Macro</li><li>Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects.</li><li>Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures</li><li>Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope</li><li>Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks</li><li>Create an error handling routine in case things go wrong with VBA code</li></ul><p>' 1 year email support service</p><p>Take a closer look at the <strong>consistent excellent feedback from our growing corporate clients</strong> visiting our site <em><strong>ms-officetraining co uk</strong></em></p><p><em><strong>Customer Feedback</strong></em></p><ul><li><strong>Best Training Ever!</strong></li><li>Just finished a bespoke 1-1 training course in Excel Advanced, Macros &amp; VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability.</li></ul><ul><li>Amanda Morris - Treasury &amp; Systems Accountant at Reall - Real Equity for All</li></ul><ul><li><p><strong>The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience..</strong></p></li><li>Simon Harper - Lloyd's of London</li></ul><ul><li><p><strong>My learning experience was awesome.</strong></p></li><li>Perdinand Reagan - Subsea7</li></ul><ul><li><p><strong>Very nice and relaxed approach to teaching. Was definitely a good learning experience</strong><strong>.</strong></p></li><li>Jerome Pupe - S5 Agency World</li></ul><ul><li><strong>The Trainer – Very positive + patient + helpful + thorough</strong></li><li>Agnes Souza - Direct Wines</li></ul><p>'</p><p>With more than 20 years experience, we deliver courses on all levels of the Desktop version of <strong>Microsoft Office and Office 365</strong>; ranging from Beginner, Intermediate, Advanced to the VBA level.</p><p>Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering<strong> classroom, one to one, tailored and bespoke courses.</strong></p><p><strong><strong>Tailored In Company training:</strong></strong></p><p>You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.</p><p><strong>Introduction to Macros and VBA</strong></p><ul><li>Introducing Visual Basic for Applications</li><li>Recording a Macro</li><li>Naming conventions for Macro Procedures</li><li>Running a Macro</li><li>Absolute or Relative Cell Referencing</li><li>Saving and Opening Files with Macros</li><li>Making macros always available</li><li>Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes</li><li>Editing a Macro in the Visual Basic Editor</li><li>Understanding the Development Environment</li><li>Customising the Editor</li><li>Tips for General Typing in VBA</li><li>Using Visual Basic Help</li></ul><p><strong>Working with Procedures</strong></p><ul><li>Program Design</li><li>Understanding Modules</li><li>Naming Rules</li><li>Creating a Module</li><li>Understanding Procedures</li><li>Programming Macro Concepts</li><li>Creating a Subroutine</li><li>Creating a Function</li><li>Understanding Arguments</li><li>Exiting Procedures</li><li>Calling Procedures</li></ul><p><strong>Objects, Properties, Methods and Events</strong></p><ul><li>Understanding Objects Properties, Methods, and Events</li><li>Navigating the Object Hierarchy</li><li>Understanding Collections</li><li>Accessing a Member of a Collection</li><li>Understanding Hierarchy</li><li>Using the Object Browser</li><li>Using the With Statement</li><li>Working with Properties</li><li>Working with Methods</li><li>Creating an Event Procedure</li><li>Reserved Macro Names</li></ul><p><strong>Using Expressions, Variables and Intrinsic Functions</strong></p><ul><li>Understanding Expressions and Statements</li><li>Declaring Variables</li><li>Understanding Data Types</li><li>Determining the Value of Variables</li><li>Working with Variable Scope</li><li>Using Built-in VBA Functions</li><li>Understanding Constants</li><li>Using Message Boxes</li><li>Controlling the Answer to a Message Box</li><li>Using Input Boxes</li><li>Declaring and Using Object Variables</li></ul><p><strong>Controlling Program Execution</strong></p><ul><li>Understanding Control-of-Flow Structures</li><li>Using the If...End If Decision Structures</li><li>Nested If Statements</li><li>Using the Select Case ... End Select Structure</li><li>Using the Do ... Loop Structure</li><li>Using the For ... Next Structure</li><li>Using the For Each ... Next Structure</li><li>Guidelines for Use of Control-of-Flow Structures</li></ul><p><strong>Debugging and Handling Errors</strong></p><ul><li>Understanding Errors</li><li>Using Debugging Tools</li><li>Setting Breakpoints and Using Break Mode</li><li>Stepping Through Code</li><li>Trapping Errors with the On Error Statement</li><li>Understanding the Err Object</li><li>Working with Inline Error Handling</li><li>Writing an Error-Handling Routine</li></ul><p><strong>Working with Forms and Controls</strong></p><ul><li>Understanding UserForms</li><li>Creating a Form</li><li>Displaying and Removing a Form</li><li>Aligning and Sizing Controls</li><li>Using the Toolbox</li><li>Working with a Form's Properties, Methods, and Events</li><li>Working with Form and Control Properties, Methods and Event</li><li>Setting the Tab Order</li><li>Populating a Control</li></ul><h2>
        
            Who is this course for?
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools.</p>
                        </div><h2>
        
            Requirements
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Preferably, delegates should have attended the Excel Advanced course.</p>
                        </div><h2>
        
            Career path
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Excel know-how can instantly increase your job prospects as well as your salary.</p><p>80 percent of job openings require spreadsheet and word-processing software skills</p>
                        </div><h2>
        
            Certificates
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

Microsoft Excel Macros & VBA - Online  classroom

<main tabindex="-1" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><section fr-original-style="" style="box-sizing: border-box;"><section data-section="template--18705858167105__main" fr-original-style="" style="box-sizing: border-box;"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">Microsoft Excel Macros are a tool you can use to automate a task (an action or a set of actions) by recording your mouse clicks and keystrokes.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span data-mce-fragment="1" fr-original-style="" style="box-sizing: border-box;">In this class, you will learn about macro security, preparing to record a macro, absolute and relative macro recording. You will record various macros in class including a macro that formats and sums data, one that sorts, subtotals and collapses an outline, a macro that moves data to rows, another that filters for the top ten sales, copies the filtered data to a new sheet and adds a heading.&nbsp;</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Other concepts include viewing VBA code and editing the code, running macros with keyboard shortcuts, Quick Access toolbar buttons and macro buttons drawn on the worksheet. &nbsp;Lastly, we learn about the Personal Macro Workbook and save a macro that formats heading to the Personal Macro workbook and record a macro that runs automatically when you open the workbook.&nbsp;</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This class is:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Live, instructor-led, virtual class</li><li fr-original-style="" style="box-sizing: border-box;">90 minutes</li><li fr-original-style="" style="box-sizing: border-box;">Completion digital badge and certificate provided</li></ul></section></section></main>

AXIOM Learning Solutions

Microsoft Excel

Microsoft Excel - Automating Tasks with Macros

<div>
						<div>
				<div>
									<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
								<div>
				<p>Is it possible to imagine an office without Microsoft Office software? Surely your answer would be a big <b>NO!</b> It's a core computer skill that every employer wants from every employee and every employee wants to mention in the resume. The <b>Microsoft Office </b>course is a <b>Bundle of everything you need to know</b> for using the most essential software by Microsoft. From creating a file to analysing data, this course will make you familiar with all the important and amazing aspects.</p><p>You will learn how to create a file and how to use various advanced tools in Microsoft Office from this Microsoft Office training. The course also includes the basic and advanced features of Microsoft Word, Excel, PowerPoint, Outlook and Access. This course will open a new dimension about your knowledge of Microsoft office.</p><p>This comprehensive course is designed for those who are dreaming of establishing their career in an office job. On successful completion of the course, you will get accredited certification as proof of your in-demand skills in Microsoft Office, which will give a competitive advantage in the job market.  </p><p><b>Enrol Now to start boosting your Supply Chain Management skills!</b></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div>
							
					<div></div>
											<div></div>
														
							
					<div></div>
											<div></div>
														
							
					<div></div>
											<div></div>
														
							
					<div></div>
											<div></div>
														
					</div>
			</div>
				</div>
				<div>
				<div>
			<h2>Key topics to be covered
</h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Microsoft Word (Documentation, Formatting, Referencing)</span>
									</li>
								<li>
											<span>
													</span>
										<span>Microsoft Excel (Macros, Formulas, What-If Analysis, Integration)</span>
									</li>
								<li>
											<span>
													</span>
										<span>Microsoft PowerPoint (Preparation, Animations and Transitions, Slide management)</span>
									</li>
								<li>
											<span>
													</span>
										<span>Microsoft Outlook (Sort, Filter, Organise messages, Contact and calendar management)</span>
									</li>
								<li>
											<span>
													</span>
										<span>Microsoft Access (Navigation with Forms, Formatting, Validation)</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Learning Outcomes</h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Know the basic to advanced Microsoft Word skills, with this Microsoft Word course, including document management, comments, compare, review, captions, cross-references, bookmarks, hyperlinks, footnotes and endnotes, citations, table of contents, digital signature, data conversion and much more of Microsoft Word 2016.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Learn      about macros, conditional formatting, troubleshooting invalid data and formula errors, activity-troubleshooting invalid data and formula errors, sparklines, scenarios, what-if analysis, statistical analysis, importing and exporting XML data, and other advanced features in Microsoft Excel 2016.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Master slide layouts, headers and footers, SmartArt, audio and video  to create a presentation, use animation and transitions, annotate a presentation, set up a slideshow, record a presentation, secure a presentation, and other advanced features in Microsoft PowerPoint 2016.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Learn the basic to advanced features of Microsoft Outlook and Microsoft Access.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Get all the tips and tricks for the MS office package.</span>
									</li>
						</ul>
				</div>
				</div>
				<div>
				<div>
			<h2>Who is this course for?</h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Anyone who wants to gain extensive knowledge, potential experience and professional skills in MS Office.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Those who have interest in Microsoft Office courses are a perfect match.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Students from any academic backgrounds</span>
									</li>
						</ul>
				</div>
				</div>
				<div>
				<div>
			<h2>Why Choose this Course</h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Earn a digital Certificate upon successful completion.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Accessible, informative modules taught by expert instructors</span>
									</li>
								<li>
											<span>
													</span>
										<span>Study in your own time, at your own pace, through your computer tablet or mobile device</span>
									</li>
								<li>
											<span>
													</span>
										<span>Benefit from instant feedback through mock exams and multiple-choice assessments</span>
									</li>
								<li>
											<span>
													</span>
										<span>Get 24/7 help or advice from our email and live chat teams</span>
									</li>
								<li>
											<span>
													</span>
										<span>Full Tutor Support on Weekdays</span>
									</li>
						</ul>
				</div>
				</div>
				<div>
				<div>
			<h2>Course Design</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<p>The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.</p><p>You are taught through a combination of-</p>					</div>
						</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Video lessons</span>
									</li>
								<li>
											<span>
													</span>
										<span>Online study supplies</span>
									</li>
								<li>
											<span>
													</span>
										<span>Mock tests</span>
									</li>
								<li>
											<span>
													</span>
										<span>Multiple-choice evaluation</span>
									</li>
						</ul>
				</div>
				</div>
				<div>
				<div>
			<h2>Career path
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<div id="course-home"><div><p>You can add this Microsoft office Course certification to your resume to get closer to securing your dream job. With the skills of MS Office, you will be prepared for any professional office environment setup. The Microsoft Office Course will equip you with skills that can be applied to a range of roles, especially in the corporate sector. Enrol in this <b>Microsoft office Course certification today and increase your productivity in the office in no time!</b></p></div></div>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Certification</h2>		</div>
				</div>
				<div>
				<div>
								<div>
				<div id="course-home"><div><p>Upon successful completion of the course, you will be able to obtain your course completion e-certificate. A print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99.</p><p><b>What are you waiting for? Enrol </b><b>in the </b><b>Professional Childcare and Nannying Courses now! </b></p></div></div>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
									</div>
			</div>
					</div>

Janets

Office Skills & Productivity

Microsoft Certification

Microsoft 365

Office Skills

Office Productivity

Microsoft Office

Microsoft Office Bundle

<div> <div> <div>  </div> <div> <b>Quality Guarantee:</b> <p>Promising training excellence, satisfaction gurantee</p> </div> </div> <div> <div>  </div> <div> <p>Accredited by </p> <p>CPD UK &amp; Quality License Scheme</p> </div> </div> <div> <div>  </div> <div> <p>Tutor Support </p> <p>Unlimited support via email, till you complete the course</p> </div> </div> <div> <div>  </div> <div> <b>Recognised Certification:</b> <p>Accepted by thousands of professional bodies </p> </div> </div> <div> <div>  </div> <div> <p>Start Anytime </p> <p>With 1 year access to the course materials</p> </div> </div> <div> <div>  </div> <div> <p>Online Learning </p> <p>Learn from anywhere, whenever you want </p> </div> </div> </div> <div> <p>Excel is an essential tool for data management and analysis and in this course, you will master everything from the fundamentals to advanced functionalities. You will learn to navigate the interface, create and format spreadsheets and perform calculations with ease and you will unlock the true potential of Excel for business and personal use.</p> <h2>This course at a glance</h2> <ul> <li>Accredited by CPD UK</li> <li>Endorsed by Quality Licence Scheme</li> <li>Understand the basics of Excel</li> <li>Know how to use Excel at an intermediate level</li> <li>Be aware of sum and numerical functions</li> <li>Understand how to manipulate text</li> <li>Know about logical functions</li> <li>Create effective spreadsheets</li> <li>Be confident with lookup functionality and date and time functions</li> <li>Easily use financial functions and sort and filter</li> <li>Progress to using Microsoft Excel at an advanced level</li> <li>Know how to create accurate and clear visual presentations</li> <li>Consolidate and validate data</li> <li>Use pivot table and what-if analysis</li> <li>Understand automation and macros</li> </ul> </div> <h2>Why Microsoft Excel Training Course right for you?</h2> <p>Develop advanced skills in Microsoft Excel training course basic to advanced course, with this course.  Learn from scratch or build on prior knowledge, to gain a good understanding of Excel functions.   You will learn to accelerate your tasks efficiently using Excel techniques and formulae.  The course covers how to create professional reports in no time, with Excel tools for data analysis and creating charts. This course will demystify the functions and tools in easy steps. It will teach you to work smart and save time. It is an excellent addition to your CV and is a valued skill in all businesses.</p> <p></p> <h2>Microsoft Excel Training Course Details</h2> <div> <h3 id="small-panelsStayOpen-heading65384eb2e3d1c">  Accredited by  </h3> <div id="panelsStayOpen-collapse65384eb2e3d1c"> <div> <p> CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.</p> <p> </p> <p> The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. </p></div> </div> </div> <div> <h3 id="small-panelsStayOpen-heading65384eb2e3d3c">  Course Curriculum  </h3> <div id="panelsStayOpen-collapse65384eb2e3d3c"> <div> <p></p> <h4>Microsoft Excel: Basic Level</h4> <ul> <li>Introduction to Microsoft Excel</li> <li>0101 Touring the Interface</li> <li>0102 Enter Data &amp; Saving Workbook</li> <li>0103 Applying Formulas</li> <li>0104 Changing a Worksheet's Structure</li> <li>0105 Find, Replace &amp; Spell Check</li> <li>0106 Applying Fonts, Background Colors, and Borders</li> <li>0107 Formatting Numbers and Dates</li> <li>0108 Making the Fieces fit</li> <li>0109 Inserting Headers &amp; Footers and Repeating Rows</li> <li>0110 Managing Large Workbooks</li> </ul> <h4>Microsoft Excel: Intermediate Level</h4> <ul> <li>Excel Essentials</li> <li>0201 Formula Writing (Don't Miss This)</li> <li>Ex 0201 Formula Writing (Don't Miss this)</li> </ul> <h4>Sum Count Average Functionality - With Conditions</h4> <ul> <li>0301 SumIf &amp; SumIfs</li> <li>Ex 0301 SumIf &amp; SumIfs</li> <li>0302 Count Functions</li> <li>Ex 0302 Count Functions</li> <li>0303 AverageIf &amp; AverageIfs</li> <li>Ex 0303 AverageIf &amp; AverageIfs</li> </ul> <h4>Text Functions - Manipulating Text</h4> <ul> <li>0401 Change Case (Upper, Lower,Proper)</li> <li>Ex 0401 Change Case (Upper, Lower, Proper)</li> <li>0402 Separating Text on Symmetrical Data</li> <li>Ex 0402 Separating Text on Symmetrical Data</li> <li>0403 Separating Text on Non-Symmetrical Data</li> <li>Ex 0403 Separating Text on Non-Symmetrical Data</li> </ul> <h4>Logical Functions - Working With Conditions</h4> <ul> <li>0501 If Functionality</li> <li>Ex 0501 IF Functionality</li> <li>0502 If with AND</li> <li>Ex 0502 If with AND</li> <li>0503 If with OR</li> <li>Ex 0503 If with OR</li> <li>0504 If with 'AND' &amp; 'OR' / IF with Countif</li> <li>Ex 0504 If with 'AND' &amp; 'OR' / IF with Countif</li> <li>0505 Nested IF (A Genie with 3 wishes)</li> <li>Ex 0505 Nested IF (A Genie with 3 wishes)</li> </ul> <h4>Lookup Functionality - Burn Simple Find Technique</h4> <ul> <li>0601 Vlookup (Exact Match) # 1</li> <li>Ex 0601 Vlookup (Exact Match) # 1</li> <li>0602 Type of References (Use of $ sign)</li> <li>0603 Vlookup (Exact Match) # 2</li> <li>Ex 0603 Vlookup (Exact Match) # 2</li> <li>0604 Double Vlookup</li> <li>Ex 0604 Double Vlookup</li> <li>0605 Vlookup on Duplicate Values</li> <li>Ex 0605 Vlookup on Duplicate Values</li> <li>0606 Vlookup (Approximate Match)</li> <li>Ex 0606 Vlookup (Approximate Match)</li> <li>0607 Vlookup with If (Conditional Vlookup)</li> <li>Ex 0607 Vlookup with If (Conditional Vlookup)</li> <li>0608 Hlookup (Exact Match)</li> <li>Ex 0608 Hlookup (Exact Match)</li> <li>0609 Hlookup (Approximate Match)</li> <li>Ex 0609 Hlookup (Approximate Match)</li> <li>0610 Lookup (Don't use this !)</li> <li>Ex 0610 Lookup (Don't use this !)</li> <li>0611 Vlookup with Match (Create Magical Vlookup)</li> <li>Ex 0611 Vlookup with Match (Create Magical Vlookup)</li> <li>0612 Match (Gives us Column/Row Index #)</li> <li>Ex 0612 Match (Gives us Column/Row Index #)</li> <li>0613 Index &amp; Match (Made for Each Other)</li> <li>Ex 0613 (1) Index &amp; Match (Made for Each Other)</li> <li>Ex 0613 (2) Index &amp; Match (Made for Each Other)</li> </ul> <h4>Date &amp; Time Function - A Tricky Game</h4> <ul> <li>0701 How Excel Records Date &amp; Time</li> <li>0702 Now, Today &amp; Autofill</li> <li>0703 DateValue &amp; TimeValue</li> <li>0704 Calculate WorkingDays</li> <li>0705 DatedIf</li> </ul> <h4>Financial Functions</h4> <ul> <li>0801 Loan Calculation (PMT, PPMT, IPMT etc.)</li> <li>Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.)</li> <li>0802 Creating a Loan Table</li> <li>Ex 0802 Creating a Loan Table</li> <li>0803 Calculate Depriciation</li> <li>Ex 0803 Calculate Depriciation</li> </ul> <h4>Sort &amp; Filter</h4> <ul> <li>0901 Basic Sorting &amp; Shortcut keys</li> <li>Ex 0901 Basic Sorting &amp; Shortcut keys</li> <li>0902 Sorting Using Custom List</li> <li>Ex 0902 Sorting Using Custom List</li> <li>0903 Horizontal Sorting</li> <li>Ex 0903 Horizontal Sorting</li> <li>0904 Basic Filter &amp; Shortcut Keys</li> <li>Ex 0904 Basic Filter &amp; Shortcut Keys</li> <li>0905 Filter Problem # 1 (Copy Filtered Data without hidden rows)</li> <li>Ex 0905 Filter Problem # 1 (Copy Filtered Data without hidden rows)</li> <li>0906 Filter Problem # 2 (Pasting Values on Filtered Data)</li> <li>Ex 0906 Filter Problem # 2 (Pasting Values on Filtered Data)</li> <li>0907 Filter Problem # 3 (Performing Calculation on Filtered Data)</li> <li>Ex 0907 Filter Problem # 3 (Performing Calculation on Filtered Data)</li> <li>0908 Advanced Filter (Applying Complex Criteria's)</li> <li>Ex 0908 Advanced Filter (Applying Complex Criteria's)</li> </ul> <h4>Microsoft Excel: Advanced Level</h4> <ul> <li>Excel Charts - Visual Presentation</li> <li>1001 How to create a chart</li> <li>1002 Format Axis</li> <li>1003 Plot Values on Secondary Axis</li> <li>1004 Life of Pie (Charts)</li> <li>1005 How to Show Axis Title</li> <li>1006 How to Show Data Label</li> <li>1007 Show data with chart in Data Table</li> <li>1008 Column Chart</li> <li>1009 Bar Chart</li> <li>1010 Line Chart 1</li> <li>1011 Line Chart 2</li> <li>1012 Area Chart</li> <li>1013 Pie Chart</li> <li>1014 Pie of Pie or Bar of Pie</li> <li>1015 Line Chart with Log Scale</li> <li>1016 Bubble Chart</li> <li>1017 Selecting Chart Elements</li> <li>1018 Use of Format Dialog box</li> <li>1019 Modifying Chart &amp; Plot Area</li> <li>1020 Modifying Data Series</li> <li>1021 How to handle Missing Data</li> <li>1022 Modifying 3-D Charts</li> <li>1023 Creating Combination of upto 5 Different Charts</li> <li>1025 Creating Picture Charts</li> </ul> <h4>Data Consolidation - Multiple WorkBooks WorkSheets</h4> <ul> <li>Consolidate Data using Excel Inbuilt Function</li> <li>Ex Consolidate Data using Excel Inbuilt Function</li> </ul> <h4>Data Validation</h4> <ul> <li>1201 Applying Data Validation</li> <li>Ex 1201 Applying Data Validation</li> <li>1202 Dependent Dropdown List</li> <li>Ex1202 Dependent Dropdown List</li> <li>Using Data Validation with Vlookup &amp; Match</li> <li>Other Data Validation Examples</li> </ul> <h4>Protection of Worksheet Workbook</h4> <ul> <li>1301 Worksheet Level Protection</li> <li>Ex 1301 Worksheet Level Protection</li> <li>1302 Cell Level Protection</li> <li>Ex 1302 Cell Level Protection</li> <li>1303 Hiding Formulas from Formula Bar</li> <li>Ex 1303 Hiding Formulas from Formula Bar</li> <li>1304 Protecting Workbook Structure</li> <li>Ex 1304 Protecting Workbook Structure</li> <li>1305 Workbook Level Protection</li> <li>Ex 1305 Workbook Level Protection</li> </ul> <h4>Pivot Table &amp; Techniques</h4> <ul> <li>1401 Understanding pivot Table</li> <li>1402 Using Pivot Table in Real Scenario</li> <li>Ex 1402 Using Pivot Table in Real Scenario</li> <li>1403 Grouping in Pivot Table</li> <li>Ex 1403 Grouping in Pivot Table</li> <li>1404 Using Slicers (A Visually attractive Filter)</li> <li>Ex 1404 Using Slicers (A Visually attractive Filter)</li> </ul> <h4>What-If Analysis &amp; Solver Add-In</h4> <ul> <li>1501 Goal Seek (A Reverse Approach)</li> <li>Ex 1501 Goal Seek (A Reverse Approach)</li> <li>1502 One Way Data Table</li> <li>1503 Two Way Data Table</li> <li>1504 Scenario Manager</li> <li>1505 Solver Add-In</li> </ul> <h4>Automation in Excel - Macros</h4> <ul> <li>1601 Record your first Macro</li> <li>1602 Record Another Macro</li> <li>1603 Assigning macro to a Shape, Button, Picture etc</li> <li>1604 Editing or Deleting a Macro</li> <li>1605 Security Settings of a Macro</li> </ul> <p> </p></div> </div> </div> <div> <h3 id="small-panelsStayOpen-heading65384eb2e3d52">  Who should take this course?  </h3> <div id="panelsStayOpen-collapse65384eb2e3d52"> <div> <p></p> <ul> <li>Absolute beginners to Microsoft Excel</li> <li>People who wish to use Microsoft Excel more confidently</li> <li>People who wish to refresh their existing skills in Microsoft Excel</li> </ul> <p> </p></div> </div> </div> <div> <h3 id="small-panelsStayOpen-heading65384eb2e3d5c">  Entry Requirements  </h3> <div id="panelsStayOpen-collapse65384eb2e3d5c"> <div> <p></p> <ul> <li>There are no academic entry requirements for this Microsoft Excel training course basic to advanced course, and it is open to students of all academic backgrounds.</li> <li>However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection.</li> </ul> <p> </p></div> </div> </div> <div> <h3 id="small-panelsStayOpen-heading65384eb2e3d66">  Assessment Method  </h3> <div id="panelsStayOpen-collapse65384eb2e3d66"> <div> <p></p> <p>This Microsoft Excel training course basic to advanced course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%.</p> <p> </p></div> </div> </div> <div> <h3 id="small-panelsStayOpen-heading65384eb2e3d71">  Certification  </h3> <div id="panelsStayOpen-collapse65384eb2e3d71"> <div> <p></p> <h4>Endorsed Certificate from Quality Licence Scheme</h4> <p> After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is Â£65.</p> <h4>Certificate of Achievement from Lead Academy</h4> <p> After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of Â£12, and there is an additional fee to obtain a printed copy certificate which is Â£35. </p></div> </div> </div> <p></p><h2><b>FAQs</b></h2> <div id="accordionPanelsStayOpenExample"> <div> <h3 id="panelsStayOpen-heading21">  Is CPD a recognised qualification in the UK?  </h3> <div id="panelsStayOpen-collapse21"> <div> <p>CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading23">  Are QLS courses recognised?  </h3> <div id="panelsStayOpen-collapse23"> <div> <p>Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading25">  When will I receive my certificate?  </h3> <div id="panelsStayOpen-collapse25"> <div> <p>For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading27">  Can I pay by invoice?  </h3> <div id="panelsStayOpen-collapse27"> <div> <p>Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading29">  Can I pay via instalment?  </h3> <div id="panelsStayOpen-collapse29"> <div> <p>Yes, you can pay via instalments at checkout. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading31">  How to take online classes from home?  </h3> <div id="panelsStayOpen-collapse31"> <div> <p>Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading33">  Does age matter in online learning?  </h3> <div id="panelsStayOpen-collapse33"> <div> <p>No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading35">  When I will get the login details for my course?  </h3> <div id="panelsStayOpen-collapse35"> <div> <p>After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org </p> </div> </div> </div> </div>

1 Courses in Leicester

Microsoft Excel Macros & VBA - In-company

By Microsoft Office Training

Online Options

Excel Macros Certificate

By OnlineCoursesLearning.com

Microsoft Excel Macros & VBA - Online classroom

By Microsoft Office Training

Microsoft Excel - Automating Tasks with Macros

By AXIOM Learning Solutions

Microsoft Office Bundle

By Janets

Microsoft Excel Training Course Basic to Advanced

By Lead Academy

Microsoft Excel Diploma

By Study Plex

Microsoft Excel Online Training

By Study Plex

Search By Location