Redhill

<h3><b>HTML5 development training course description</b></h3>
      <p> This three-day MTA Training course helps you prepare
for Microsoft Technology Associate Exam 98-375, and
build an understanding of these topics: Manage the
Application Life Cycle, Build the User Interface by
Using HTML5, Format the User Interface by Using
CSS, Code by Using JavaScript. This course leverages
the same content as found in the Microsoft Official
Academic Course (MOAC) for this exam.</p>
        
				<h5><b>What will you learn</b></h5>
				<ul>
				 
	  
                      <li>Manage the Application Life Cycle.</li>
				  	                <li>Build the User Interface by Using HTML5.</li>
                       <li>Format the User Interface by Using CSS.</li>
                      	<li>Code by Using JavaScript.</li>
                  </ul>
        <h5>
        <b>HTML5 development training course details</b> </h5>
				<div>
					<div>
						<ul>
							<li><b> Who will benefit:</b> </li>
							
              <p>Anyone working with HTML5.</p>
              
							<li><b>Prerequisites:</b></li>
							
              <p>None.
							</p>
              
							<li><b>Duration</b></li>
							
              <p>3 days
						</p>
              
							
              
              
						</ul>
					</div>
				</div>
      <h3><b>HTML5 development training course contents</b></h3>
      <ul>
				<li><span>Managing the Application Life Cycle</span></li><p>
</p><li>Platform fundamentals </li><p>
Packaging and the runtime environment: app package, app container, credentials/permission sets, host process, leverage existing HTML5 skills and content for slate/tablet applications.

</p><li>Manage the state of an application </li><p>
Manage session state, app state and persist state information; understand states of an application; understand the differences between local and session storage.

</p><li>Debug and test a HTML5 touch-enabled application </li><p>
Touch gestures; gestures you test on a device.


</p><li>HTML5 UI: Text, Graphics, and Media </li><p>
</p><li><span>HTML5 tags for text content and graphics.</span> </li><p>
When, why and how to use Canvas; when, why and how to use scalable vector graphics (SVG).

</p><li>HTML5 tags to play media. </li><p>	
Video and audio tags.


</p><li>HTML5 UI: Organization, Input, and Validation </li><p>
</p><li><span>HTML5 tags to organise content and forms</span> </li><p>
Tables, lists, sections; semantic HTML.

</p><li>HTML5 tags for input and validation </li><p>

</p><li>CSS Essentials: Content Flow, Positioning, styling </li><p>
</p><li><span>Core CSS concepts</span> </li><p>
Separate presentation from content (create content with HTML and style content with CSS); manage content flow (inline versus block flow); manage positioning of individual elements( float versus absolute positioning); manage content overflow (scrolling, visible and hidden); basic CSS styling.


	</p><li>CSS Essentials: Layouts </li><p>
</p><li><span>Arrange UI content by using CSS </span></li><p>
Use flexible box and grid layouts to establish content alignment, direction and orientation; proportional scaling and use of "free scale" for elements within a flexible box or grid; order and arrange content; concepts for using flex box for simple layouts and grid for complex layouts; grid content properties for rows and columns; use application templates.


</p><li>Managing Text Flow by Using CSS </li><p>
Regions and using regions to flow text content between multiple sections (content source, content container, dynamic flow, flow-into, flow-from, msRegionUpdate, msRegionOverflow, msGetRegionContent); columns and hyphenation and using these CSS settings to optimise the readability of text; use "positioned floats" to create text flow around a floating object


</p><li>Managing the Graphical Interface by Using CSS </li><p>
Graphics effects (rounded edges, shadows, transparency, background gradients, typography and Web Open Font Format); 2-D 3-D transformations (translate, scale, rotate, skew and 3-D perspective transitions and animations); SVG filter effects; Canvas.


</p><li>JavaScript and coding essentials </li><p>
Manage and maintain JavaScript, Create and use functions; jQuery and other third-party libraries. Update the UI by using JavaScript Locate/access elements; listen and respond to events; show and hide elements; update the content of elements.


</p><li>Animations, Graphics, and Accessing Data </li><p>
</p><li><span>Code animations with JavaScript</span> </li><p>
animation; manipulate the canvas; work with images, shapes and other graphics.

</p><li>Access data access by using JavaScript </li><p>
Send and receive data; transmit complex objects and parsing; load and save files; App Cache; datatypes; forms; cookies; localStorage


 </p><li>JavaScript coding for Touch Interface, Device and Operating System Resources, and More </li><p>
Respond to the touch interface, Gestures, how to capture and respond to gestures, Code additional HTML5 APIs, GeoLocation, Web Workers, WebSocket; File API, Access device and operating system resources, In- memory resources, such as contact lists and calendar; hardware capabilities, such as GPS, accelerometer and camera.</p>
			
      </ul>

Systems & Network Training

Network & Security

Network Engineer

HTML5 development fundamentals

General Admission

Chesterfield

<ul id="isPasted" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><li data-css="tve-u-16f8a5891e5" style="color: rgb(135, 145, 152); box-sizing: border-box;" fr-original-style=" color: rgb(135, 145, 152);"><span data-css="tve-u-1728a43748b" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;">A&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">series&nbsp;</strong>of hourly small group sessions where we look at different aspects of Excel</span></li><li data-css="tve-u-16f8a5891e5" style="color: rgb(135, 145, 152); box-sizing: border-box;" fr-original-style=" color: rgb(135, 145, 152);"><div data-css="tve-u-1728a4374ac" fr-original-style="" style="box-sizing: border-box;"></div><span data-css="tve-u-1728a43748b" style="color: rgb(0, 0, 0) !important; box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0) !important;">Duration: 1 hr sessions&nbsp;</span></li></ul><div id="isPasted" fr-original-style="" style="box-sizing: border-box;">Alternatively, we can do you one-to-one sessions, either via virtual classroom or in person at our training course. These are &pound;25 per hour, or &pound;100 for 5-hour blocks.</div>

Pochat Training

Microsoft Excel

Using Excel

General admission

Harpenden

<p>This one-day workshop is designed to build upon skills already acquired using Microsoft Word, whether participants are self-taught or have previously attended a course. It gives participants a good understanding of managing different types of paragraph indents, and managing automated numbered paragraph lists.</p>This course will help participants:<ul><li>Create and manage the layout of paragraphs</li><li>Create and manage multi-level numbered paragraphs</li><li>Effectively insert, use and manage section breaks</li><li>Create and manage columns</li><li>Find, create and apply styles</li><li>Create and update a table of contents from styles</li><li>Work with styles to manage formatting</li><li>Work with sums in tables and use table headings</li><li>Input and edit text using AutoText</li><li>Work with SmartArt graphics</li><li>Link to other files using paste special</li></ul><section>
                    <h3>1 Managing paragraph layout</h3><ul><li>Controlling paragraph layouts with indents</li><li>Creating and managing paragraph hanging indents</li></ul> <h3>2 Numbering paragraphs</h3><ul><li>Creating a new multi-level numbered paragraph</li><li>Managing existing multi-level numbered paragraphs</li></ul> <h3>3 Inserting columns</h3><ul><li>Creating columns from existing paragraphs</li><li>Setting up columns</li><li>Managing columns</li></ul> <h3>4 Document section breaks</h3><ul><li>Controlling document layout using section breaks</li><li>Managing page orientation using section breaks</li><li>Managing page numbering using section breaks</li></ul> <h3>5 Using styles</h3><ul><li>Applying quick styles</li><li>Finding existing styles</li><li>Creating and saving styles</li><li>Modifying styles</li><li>Creating a table of contents from styles</li><li>Updating a table of contents</li></ul> <h3>6 Using quick parts</h3><ul><li>Saving content to quick parts</li><li>Modifying saved quick parts</li><li>Inserting content using AutoText</li><li>Editing AutoText entries</li><li>Inputting text using AutoCorrect</li></ul> <h3>7 Advanced table features</h3><ul><li>Sorting table columns</li><li>Running sums in tables</li><li>Repeating table headings at top of page</li><li>Importing Excel content in tables</li><li>Using table properties</li></ul> <h3>8 Creating a mail merge</h3><ul><li>Creating letters, labels and emails</li><li>Merging addresses from external files</li><li>Using Outlook's address book to merge</li><li>Merging to email</li></ul> <h3>9 SmartArt graphic</h3><ul><li>Visually communicate content with SmartArt</li><li>Choosing a SmartArt graphic</li><li>Inputting into SmartArt</li><li>Modifying and formatting SmartArt graphics</li></ul> <h3>10 Linking to other files</h3><ul><li>Linking to files using paste special</li><li>Linking an Excel chart to a document</li><li>Managing linked content from Word</li></ul> 


                </section>

The In House Training Company

Office Skills & Productivity

Office Skills

Office Productivity

Computer Skills

Microsoft Office

Microsoft Word

Word - intermediate (In-House)

<p>This one-day workshop is designed to give participants an understanding of the fundamentals of Microsoft Word and its commands, with quick ways to enter text, control formatting and edit paragraphs.</p>This course will help participants:<ul><li>Create, manage and save documents, files and folders</li><li>Create paragraph lists, bulleted and numbered paragraphs</li><li>Edit, modify and format paragraphs</li><li>Create and format tables</li><li>Use shortcuts to navigate documents</li><li>Format the layout of documents</li><li>Manage page headers and footers</li><li>Insert and managing pictures and diagrams within a document</li><li>Learn time saving tips and tricks to obtain a professional finish to documents</li><li>Use printing options</li></ul><section>
                    <h3>1 Creating documents</h3><ul><li>Getting help</li><li>Creating and saving documents</li><li>Accessing recently used documents</li><li>Managing files and folders</li></ul> <h3>2 Entering and editing text</h3><ul><li>Inserting and editing paragraph text</li><li>Cutting, copying and pasting text</li><li>Using tool tips to manage content</li><li>Applying and removing text formatting</li><li>Correcting spelling and grammar</li></ul> <h3>3 Creating paragraph lists</h3><ul><li>Creating bulleted paragraphs</li><li>Creating numbered paragraphs</li><li>Managing bulleted and numbered lists</li></ul> <h3>4 Modifying paragraphs</h3><ul><li>Changing paragraph alignment</li><li>Indenting a paragraph</li><li>Adding borders and shading to paragraphs</li><li>Formatting paragraphs using styles</li></ul> <h3>5 Navigating documents</h3><ul><li>Using shortcuts for navigating documents</li><li>Using 'Go To' to navigate documents</li><li>Finding and replacing text</li><li>Changing to read view</li></ul> <h3>6 Document layout</h3><ul><li>Inserting page breaks</li><li>Changing page orientation</li><li>Adjusting page margins</li><li>Adding borders to pages</li></ul> <h3>7 Page headers and footers</h3><ul><li>Inserting page headers and footers</li><li>Using header and footer commands</li><li>Inserting page numbers</li><li>Using different first page</li></ul> <h3>8 Inserting pictures and diagrams</h3><ul><li>Inserting pictures from your computer</li><li>Inserting online pictures</li><li>Flowing text around a picture</li><li>Changing a picture</li><li>Inserting SmartArt diagrams</li><li>Entering text into SmartArt</li></ul> <h3>9 Inserting tables</h3><ul><li>Using tabs to create tables</li><li>Resizing and repositioning tables</li><li>Inserting and deleting rows and columns</li><li>Using a table's commands</li><li>Changing a tables text direction</li><li>Formatting tables</li></ul> <h3>10 Printing documents</h3><ul><li>Previewing and printing documents</li><li>Using the printing tools</li><li>Printing parts of a document</li></ul> 


                </section>

Microsoft Publisher

Word - introduction (In-House)

<p>This one-day introduction workshop is intended for users who need to get to grips with the essentials of Microsoft Outlook.  It will provide you with the basic skills you need to effectively start using Outlook to manage your emails, calendar, contacts, tasks and notes.</p>This course will help participants:<ul><li>Send messages with added email options applied</li><li>Quickly file messages away for safe keeping</li><li>Manage messages and attachments</li><li>Organise calendar meetings and check other people's schedules</li><li>Respond to a meeting request</li><li>Create a contacts list</li><li>Manage daily tasks</li><li>Use reading and folder panes</li><li>Create and manage folders</li><li>Use auto reply</li><li>Use notes</li><li>Utilise Outlook's printing functionality</li></ul><section>
                    <h3>1 Getting started</h3><ul><li>Using the reading pane</li><li>Using the folder pane</li><li>Changing inbox views</li><li>Managing the to-do bar</li></ul> <h3>2 Emailing messages</h3><ul><li>Replying to and forwarding messages</li><li>Adding message options</li><li>Attaching files to an email message</li><li>Opening and saving attachments</li></ul> <h3>3 Outlook folders</h3><ul><li>Creating and managing folders</li><li>Moving messages into folders</li><li>Adding folders to favourites</li><li>Using search folder</li><li>Always moving messages in conversation</li><li>Automatically move messages with rules</li></ul> <h3>4 Managing messages</h3><ul><li>Using instant search</li><li>Finding messages by criteria</li><li>Grouping and sorting messages</li><li>Categorising messages</li><li>Adding message follow up flags</li><li>Filtering messages with the people pane</li></ul> <h3>5 Using auto reply</h3><ul><li>Replying to messages whilst you are away</li><li>Managing auto reply settings</li><li>Applying rules to auto reply</li></ul> <h3>6 Outlook calendars</h3><ul><li>Adding and editing appointments</li><li>Adding calendar reminders</li><li>Moving and copying appointments</li><li>Creating all day events</li><li>Recurring appointments</li><li>Sharing your calendar</li><li>Opening another user's calendar</li></ul> <h3>7 Planning a meeting</h3><ul><li>Arranging meetings</li><li>Inviting attendees to meetings</li><li>Responding to meeting invites</li></ul> <h3>8 Outlook contacts</h3><ul><li>Creating and editing a contact</li><li>Saving emails as contacts</li><li>Finding contacts</li><li>Sending messages to contacts</li><li>Creating contact groups</li></ul> <h3>9 Adding tasks</h3><ul><li>Creating and editing tasks</li><li>Completing tasks</li><li>Assigning a task to another user</li><li>Responding to a task request</li></ul> <h3>10 Notes</h3><ul><li>Creating and editing tasks</li><li>Emailing notes</li><li>Sticking notes on your desktop</li></ul> <h3>11 Printing</h3><ul><li>Printing messages</li><li>Printing calendars</li><li>Printing contacts</li></ul> 


                </section>

Office Management

Outlook

Microsoft Outlook

Outlook - introduction (In-House)

<p>This one-day workshop is intended for participants who have a basic understanding of Outlook but who want to know how to use its advanced features to manage their email communications, calendar events, contact information and other communication tasks.</p>This course will help participants:<ul><li>Gain confidence using Outlook and its advanced features</li><li>Organise and prioritise email messages</li><li>Archive messages for safe-keeping</li><li>Use rules to process received or sent messages automatically</li><li>Manage scheduled meetings with others</li><li>Give others permission to view and manage their folders and items</li><li>Use contacts and commands to find out more about a person or company</li><li>Prioritise work-flow using tasks and assigning tasks to others</li></ul><section>
                    <h3>1 Email messages</h3><ul><li>Combining multiple clicks with quick steps</li><li>Following up flag options</li><li>Saving multiple attachments</li><li>Attaching a folder of files</li><li>Recalling and replacing a message</li><li>Categorising messages with conditional formatting</li></ul> <h3>2 Message options</h3><ul><li>Adding options to messages</li><li>Marking a message as private</li><li>Receiving quick responses with voting buttons</li><li>Directing replies to specific users</li><li>Delaying sent messages</li><li>Inserting links in messages</li></ul> <h3>3 Stay organised with rules</h3><ul><li>Using rules to automate message flow</li><li>Moving messages with rules</li><li>Using the rules wizard</li><li>Setting up rules with conditions</li><li>Using rules that work whilst you are away</li></ul> <h3>4 Message clean-up</h3><ul><li>Using conversation clean-up</li><li>Using mailbox clean-up</li><li>Moving messages to the archive folder</li><li>Archiving folder properties</li><li>Auto-archiving properties</li></ul> <h3>5 Managing calendars</h3><ul><li>Creating calendar groups</li><li>Sharing calendars with permissions</li><li>Setting up working days and times</li><li>Managing time zones</li><li>Categorise appointments with conditional formatting</li><li>Publishing a calendar</li></ul> <h3>6 Schedule meetings</h3><ul><li>Scheduling a meeting</li><li>Managing meeting responses</li><li>Proposing new meeting times</li><li>Adding attendees to a meeting</li><li>Viewing multiple appointments</li></ul> <h3>7 Using contacts</h3><ul><li>Merging contacts to letters</li><li>Merging contacts to labels</li><li>Mail merging contacts in Word</li><li>Exporting contacts to Excel</li></ul> <h3>8 Managing tasks</h3><ul><li>Organising your workload with tasks</li><li>Categorising tasks</li><li>Assigning tasks to others</li><li>Sending a task status report</li><li>Allocating time for tasks</li><li>Regenerating a new task</li><li>Viewing your tasks in the calendar</li></ul> <h3>9 Adding message items</h3><ul><li>Adding calendars to messages</li><li>Adding business cards to messages</li></ul> <h3>10 Email accounts</h3><ul><li>Adding multiple user accounts</li><li>Adding account permissions</li></ul> 


                </section>

Gmail Productivity

Outlook - advanced (In-House)

Harlow

Hoddesdon

Standard or Custom Excel courses at Introduction, Intermediate, Advanced and Super User level.   Click on the link below for full details:

Excel 365 courses

Enliten IT

Microsoft Power Apps

Microsoft 365

Microsoft Power BI

Microsoft Excel 365

<p>This one-day workshop will give you a better understanding of the components and operations of an Access database. It is designed to build on a user's existing skills and includes useful action queries to allow greater manipulation of a database.</p>This workshop will help participants:<ul><li>Ensure the integrity of their databases</li><li>Manage field properties</li><li>Use the query functions effectively</li><li>Save time with the query expression builder</li><li>Create different types of query more quickly</li><li>Design better forms</li><li>Link expressions in forms</li><li>Create better and more useful reports</li><li>Import and export tables more easily</li></ul><section>
                    <h3>1 Table relationship integrity</h3><ul><li>Identifying relationships</li><li>Identifying criteria for data integrity</li><li>Applying referential integrity</li><li>Managing relationship join types</li></ul> <h3>2 Table field properties</h3><ul><li>Field properties overview</li><li>Using input mask field</li><li>Using default value fields</li><li>Using field validation rules</li></ul> <h3>3 Query functions</h3><ul><li>Running aggregate function calculations</li><li>Running sum, average, count, max and min functions</li><li>Grouping calculated data</li></ul> <h3>4 Query calculations</h3><ul><li>Using query operators and expressions</li><li>Adding calculated fields to a query</li><li>Using the query expression builder</li></ul> <h3>5 Action queries</h3><ul><li>Creating make table queries</li><li>Creating append queries</li><li>Creating update queries</li><li>Creating delete queries</li></ul> <h3>6 Designing forms</h3><ul><li>Adding form controls</li><li>Aligning and arranging form controls</li><li>Adding pictures and labels to forms</li><li>Adding new fields to a form</li><li>Controlling tab order</li><li>Adding command buttons</li><li>Adding a combo box control</li><li>Formatting data using conditional formatting</li></ul> <h3>7 Form expressions (calculations)</h3><ul><li>Using the form expression builder</li><li>Working with a property sheet within a form</li><li>Linking expressions within a form</li></ul> <h3>8 Working with reports</h3><ul><li>Creating reports with the report wizard</li><li>Inserting report fields</li><li>Formatting fields</li><li>Inserting report headers and footers</li><li>Working with a property sheet within a report</li></ul> <h3>9 Grouped reports</h3><ul><li>Creating groups with the report wizard</li><li>Sorting grouped data</li><li>Grouping alphabetically</li><li>Grouping on date intervals</li><li>Creating sub reports</li><li>Adding calculations to groups</li></ul> <h3>10 Importing and exporting tables</h3><ul><li>Importing tables into Access</li><li>Exporting tables from Access</li><li>Importing and linking data in Access</li></ul> 


                </section>

Microsoft Forms

Excel Analytics

Access VBA

Microsoft Access

Access - intermediate (In-House)

<p>This one-day workshop is ideal for those looking to work with existing databases as well as creating a new Access database. You will learn effective ways to enter and extract data and convert data into a well-presented format for reports.</p>This course will help participants:<ul><li>Plan and create a database</li><li>Sort and filter records</li><li>Use field data types</li><li>Work with tables</li><li>Create and manage a query</li><li>Create and work with forms, and use the form wizard</li><li>View, create and print reports</li></ul><section>
                    <h3>1 Access introduced</h3><ul><li>Planning a database</li><li>Creating a blank database</li><li>Opening an existing database</li><li>Security warnings</li><li>The navigation pane</li><li>Previewing database components</li><li>Closing an Access database</li></ul> <h3>2 Tables introduced</h3><ul><li>Viewing and navigating table data</li><li>Navigating using keyboard shortcuts</li><li>Editing table data</li><li>Adding records to tables</li><li>Selecting and deleting records</li><li>Finding and replacing data</li><li>Filtering tables</li><li>Summing table data</li></ul> <h3>3 Queries introduced</h3><ul><li>Opening a query in datasheet view</li><li>Opening a query in design view</li><li>Adding fields to a query</li><li>Sorting query results</li><li>Modifying datasheet view</li><li>Saving and closing queries</li></ul> <h3>4 Forms introduced</h3><ul><li>Working with form data</li><li>Sorting records</li><li>Filtering records</li><li>Working in design and layout views</li><li>Changing object attributes</li></ul> <h3>5 Reports introduced</h3><ul><li>Opening and viewing reports</li><li>Viewing a report in design view</li><li>Previewing and printing report data</li><li>Creating reports with auto report</li><li>Creating reports with the report wizard</li><li>Changing field attributes</li></ul> <h3>6 Creating a new database</h3><ul><li>Creating database tables</li><li>Creating table fields</li><li>Selecting field data types</li></ul> <h3>7 Table relationships</h3><ul><li>Introducing relationships</li><li>Establishing table relationships</li><li>The one-to-many relationship type</li><li>Establishing referential integrity</li></ul> <h3>8 Creating queries</h3><ul><li>Streamline query criteria using wildcards</li><li>Creating summary queries</li><li>Creating queries based on criteria</li><li>Running date queries</li><li>Formatting field properties</li><li>Building queries from multiple tables</li><li>Summing in queries</li></ul> <h3>9 Creating forms</h3><ul><li>Creating a new form</li><li>Inserting form fields</li><li>Working with the property sheet</li><li>The command button wizard</li><li>The command button wizard</li><li>Programming without typing</li><li>Creating forms with embedded sub forms</li><li>Creating forms with the sub form wizard</li><li>Creating forms with the form wizard</li></ul> <h3>10 Creating reports</h3><ul><li>What are report bands?</li><li>Managing report controls</li><li>Basing reports on multiple tables</li><li>Basing reports on queries</li><li>Sorting and grouping records</li></ul> 


                </section>

Data Entry Skills

Trainers Course

Access - introduction (In-House)

<p>This one-day workshop is designed to enhance your PowerPoint skills to achieve dynamic presentations that work with you, making it easier to deliver a polished, professional presentation. You will learn advanced PowerPoint skills that will save you time and elevate your presentations.</p>This course will help participants:<ul><li>Create custom shows to personalise presentations for individual clients</li><li>Make the Slide Master work collectively with slide layouts and themes</li><li>Seamlessly interact with external content using links</li><li>Work with advanced animations and transitions, and video/audio tools</li></ul><section>
                    <h3>1 Themes and Masters</h3><ul><li>Add a Design theme to a presentation</li><li>Make changes to the Slide Master</li><li>Delete layouts from the slide master</li><li>Saving a slide master with themes as a template</li></ul> <h3>2 Advanced graphics and diagrams</h3><ul><li>Drawing, duplicating and resizing shapes</li><li>Grouping, aligning and stacking shapes and graphics</li><li>Using SmartArt for diagrams and organisation charts</li></ul> <h3>3 Graphs and charts</h3><ul><li>Inserting and formatting a chart</li><li>Linking an Excel chart to a slide</li><li>Linking Excel tables to a slide</li><li>Animating charts</li></ul> <h3>4 Video, Custom animation and Hyperlinks</h3><ul><li>Adding and editing video</li><li>Animating pictures and drawings</li><li>Hyperlink to another Slide or Website</li><li>Compressing and optimising media</li></ul> <h3>5 Presenting </h3><ul><li>Reuse slides</li><li>Hide slides</li><li>Rehearsing timings</li><li>Enabling a presentation to run continuously</li></ul> 


                </section>

Executive Presentation

Meeting Skills

Motion Graphics

Professional Skills Course (PSC)

Microsoft Powerpoint

Presentation Skills

PowerPoint - intermediate (In-House)

<p>Tired of browsing and searching for a <strong>Microsoft Office Course </strong> course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed.</p><p>After surveying thousands of learners just like you and considering their valuable feedback, this all-in<strong>-</strong>one Microsoft Office Course bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Microsoft Office Coursecourse that will enhance your skills and prepare you for the competitive job market.</p><p>Also, ourexperts are available for answering your queries on Microsoft Office Courseand help you along your learning journey. Advanced audio-visual learning modules of these Microsoft Office Coursecourses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once.</p><p>Furthermore, to help you showcase your expertise in Microsoft Office Course, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest.</p><p><strong>This Microsoft Office Course Bundle Consists of the following Premium courses: </strong></p><ul><li> Course 01: Level 2 Microsoft Office Essentials</li><li> Course 02: 50 Tips to Upgrade your Excel Skill</li><li> Course 03: New Functions in Microsoft Excel 2021</li><li> Course 04: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</li><li> Course 05: Microsoft Excel: Excel Sheet Comparison with VBA</li><li> Course 06: Microsoft Excel: Master Power Query in 120 Minutes!</li><li> Course 07: Data Analysis in Microsoft Excel Complete Training</li><li> Course 08: PowerPoint Diploma</li><li> Course 09: The Complete Microsoft Outlook Masterclass</li><li> Course 10: Complete Microsoft Power BI 2021</li><li> Course 11: Outlook Tips and tricks</li><li> Course 12: Microsoft Teams</li><li> Course 13: Windows 10 Pro Complete Training</li><li> Course 14: Functional Skills IT</li></ul><p>The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Microsoft Office Courseexpertise and essential knowledge, which will assist you in reaching your goal.</p><p>Enrol now in Microsoft Office Course to advance your career, and use the premium study materials from Apex Learning.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        150 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>Anyone from any background can enrol in this SEN Teaching Assistant Bundle.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Our Microsoft Office is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones, so you can access your course on Wi-Fi, 3G or 4G.</p><p>There is no time limit for completing this course; it can be studied in your own time at your own pace.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Having this Microsoft Office expertise will increase the value of your CV and open you up to multiple job sectors.</p>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div> <p>P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99.</p> </div>

                        </div>

Overview:
Tired of browsing and searching for a Microsoft Office course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed.
After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Microsoft Office Course bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Microsoft Office Course that will enhance your skills and prepare you for the competitive job market.
Also, our experts are available to answer your queries on Microsoft Office Courses and help you along your learning journey. Advanced audio-visual learning modules of these Microsoft Office courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once.
Furthermore, to help you showcase your expertise in the Microsoft Office Course, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest.
This Microsoft Office Course Bundle Consists of the following Premium courses: 
Course 01: MS Word Diploma
Course 02: Proofreading & Copyediting
Course 03: PowerPoint Diploma
Course 04: Microsoft Excel Level 3
Course 05: New Functions in Microsoft Excel 2021
Course 06: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query
Course 07: Microsoft Excel: Excel Sheet Comparison with VBA
Course 08: Microsoft Excel: Master Power Query in 120 Minutes!
Course 09: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!
Course 10: Excel Pivot Tables
Course 11: Data Analysis in Microsoft Excel Complete Training
Course 12: Excel Must know Formulas and Functions
Course 13: Excel spreadsheet for Beginner
Course 14: Excel Data Analysis for Beginner
Course 15: Diploma in Excel Vlookup Xlookup Match and Index
Course 16: Excel Pivot Tables, Pivot Charts, Slicers, and Timelines
Course 17: PowerBI Formulas
Course 18: Outlook Tips and Tricks
Course 19: Excel PowerQuery and PowerPivot
Course 20: Complete Microsoft Power BI 2021



Key Features of the Microsoft Office Course:
FREE Microsoft Office CPD-accredited certificate
Get a free student ID card with Microsoft Office training (£10 applicable for international delivery)
Lifetime access to the Microsoft Office course materials
The Microsoft Office program comes with 24/7 tutor support
Get instant access to this Microsoft Office course
Learn Microsoft Office training from anywhere in the world
The Microsoft Office training is affordable and simple to understand
The Microsoft Office training is an entirely online
Enrol now in the Microsoft Office Course to advance your career, and use the premium study materials from Apex Learning.



Description
The Microsoft Office bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Microsoft Office Course expertise and essential knowledge, which will assist you in reaching your goal.
Course 01: Microsoft Office Word Diploma
Module 01: Getting Started with Word
Module 02: Formatting Text and Paragraphs
Module 03: Working More Efficiently
Module 04: Managing Lists
Module 05: Adding Tables
Module 06: Inserting Graphic Objects
Module 07: Controlling Page Appearance
Module 08: Preparing to Publish a Document
=========>>>>> And 19 More Courses <<<<<=========
How will I get my Microsoft Office Certificate?
After successfully completing the Microsoft Office course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.
PDF Certificate: Free (Previously it was £9.99*20 = £199.7)
Hard Copy Certificate: Free (For The Title Course: Previously it was £14.99)
So, enrol now in this Microsoft Office Bundle to kickstart your career!



Who is this course for? 
Anyone from any background can enrol in this Microsoft Office Bundle.



Requirements 
Our Microsoft Office is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones, so you can access your course on Wi-Fi, 3G or 4G.



Career Path
Having this Microsoft Office expertise will increase the value of your CV and open you up to multiple job sectors.

Apex Learning

Microsoft Certified Trainer (MCT)

Microsoft Office Collection for Microsoft Office Specialist (MOS)

This Offer is vaild for first 10 Learners Only!!

Limited Time Offer!

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong></strong></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Real Estate Analyst</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course, you will&hellip;</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Learn how to structure an investment cash flow from first principles and how to value and appraise property investments</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Build annual and quarterly discounted cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Build OPEX and CAPEX into your cash flow</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analyse risk using sensitivity tables and charts</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Employ best practice and find solutions to common modelling problems</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Surveyors</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Portfolio Analysts</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Investment Managers</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Asset Managers</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals at any level with exposure to real estate financial models on a frequent basis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members</li><li value="9" fr-original-style="" style="box-sizing: border-box;">APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day One</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Term &amp; Reversion and Layer Method Valuation (Intro to Excel)</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Equivalent Yield (Solver, Scenario and Goal Seek functions)</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Single-Let Discounted Cash Flow</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Analysis and use of date series</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Internal Rate of Return (IRR) and Net Present Value (NPV)</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Comparing Value, Price and Worth</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Adding borrowing and analysing geared returns</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Introducing Rent Reviews and other &lsquo;events&rsquo; into cash flows</li><li value="10" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; concept and Logic functions (IF,OR,AND)</li><li value="11" fr-original-style="" style="box-sizing: border-box;">Sensitivity analysis</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Day Two</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">The &lsquo;Rent Function&rsquo; and Multi-let cash flows</li><li value="2" fr-original-style="" style="box-sizing: border-box;">The &lsquo;date problem&rsquo; and assumptions in property asset cash flows</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Reducing the rent function, intermediate calculations and modelling theory</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Modelling lease expiries, break clauses, voids, and upward only covenants</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Incorporating time-varying rental growth rates</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Analysing multi-let cash flows to see if the leases are sufficiently diversified</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Further IRR analysis (XIRR, MIRR)</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Analyst such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



Real Estate Analyst
The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.
Create flexible real estate investment focused financial models in Excel. Case studies focus on core, core plus and value add property investments. This course shows you how to model income producing property with both annual and quarterly discounted cash flows, build rent functions, model costs and calculate returns. It also shows you how to interpret and analyse the results.


On this course, you will…
Learn how to structure an investment cash flow from first principles and how to value and appraise property investments
Build annual and quarterly discounted cash flows
Look in depth at modelling tenancy schedules: rent reviews, upward-only, break options, lease expiry
Build OPEX and CAPEX into your cash flow
Analyse risk using sensitivity tables and charts
Employ best practice and find solutions to common modelling problems


Who will benefit from this course?
Real Estate Investors
Surveyors
Portfolio Analysts
Investment Managers
Asset Managers
Real Estate professionals at any level with exposure to real estate financial models on a frequent basis
Mid-level to senior Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
Junior or new Real Estate Analysts who would like to start building their own real estate models quickly, rather than relying solely on coaching from existing team members
APC candidates who would like the opportunity to consolidate their competencies by understanding how theory and variables interact within the precision context of a financial model.


Day One
Know how to build a property asset cash flow, analyse geared, and un-geared IRRs.
Term & Reversion and Layer Method Valuation (Intro to Excel)
Equivalent Yield (Solver, Scenario and Goal Seek functions)
Single-Let Discounted Cash Flow
Cash Flow inputs (Rents, Yields, Growth Rates, Target Returns)
Analysis and use of date series
Internal Rate of Return (IRR) and Net Present Value (NPV)
Comparing Value, Price and Worth
Adding borrowing and analysing geared returns
Introducing Rent Reviews and other ‘events’ into cash flows
The ‘Rent Function’ concept and Logic functions (IF,OR,AND)
Sensitivity analysis


Day Two
Know how to build a multi-let property cash flow and apply the concepts on a hypothetical case study.
The ‘Rent Function’ and Multi-let cash flows
The ‘date problem’ and assumptions in property asset cash flows
Reducing the rent function, intermediate calculations and modelling theory
Modelling lease expiries, break clauses, voids, and upward only covenants
Incorporating time-varying rental growth rates
Analysing multi-let cash flows to see if the leases are sufficiently diversified
Further IRR analysis (XIRR, MIRR)


Included in the Course
CPD Accredited Certificate & LinkedIn Proficiency Badge
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Analyst such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Bayfield Training

Financial Modelling & Analysis

Financial Modelling

Professional Development

Property & Real Estate Photography

Continuous Professional Development (CPD)

The Real Estate Analyst course has been taught non-stop to global real estate firms over the last 25 years, and is without doubt the core financial modelling training in your career portfolio. Whether you have an upcoming financial modelling test for a new job or an APC exam, the Real Estate Analyst course is the choice for you.

Real Estate Analyst (Investment Cash Flow Modelling in Excel)

In-Person 

Virtual

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Whether you&#39;re a novice or an experienced user wishing to advance your Microsoft Office Skills (Excel, Word, PowerPoint), IT Functional Skills with Admin, Secretarial &amp; PA, this course offers many things for you. This Microsoft Office Skills with Admin, Secretarial &amp; PA course is designed to provide individuals with a comprehensive introduction to the features and functionality.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">This Microsoft Office Skills (Excel, Word, PowerPoint) &amp; IT Skills with Admin, Secretarial &amp; PA Bundle Consists of the following Premium courses:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 01: </strong>Microsoft Office Word Diploma</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 02: </strong>Microsoft Office PowerPoint Diploma</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 03:</strong> Microsoft Office Excel</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 04: </strong>Microsoft Access</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 05: </strong>Functional Skills IT</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 06: </strong>Admin, Secretarial &amp; PA</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 07: </strong>Legal Secretary and Office Skills Diploma</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 08: </strong>Document Control</em></li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">3 Free Gift Courses with this Microsoft Office &amp; Admin, Secretarial &amp; PA Package:</strong></p><ol fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 01:</strong> Touch Typing</em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 02:</strong> Business Writing </em></li><li fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"> Course 03: </strong>Leadership &amp; Management</em></li></ol><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Enrol with Microsoft Office with Admin, Secretarial &amp; PA Bundle Today!!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">The curriculum of the Microsoft Office with Admin, Secretarial &amp; PA Bundle:</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course 01: Microsoft Office Word Diploma</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Module 01: Getting Started with Word</li><li fr-original-style="" style="box-sizing: border-box;">Module 02: Formatting Text and Paragraphs</li><li fr-original-style="" style="box-sizing: border-box;">Module 03: Working More Efficiently</li><li fr-original-style="" style="box-sizing: border-box;">Module 04: Managing Lists</li><li fr-original-style="" style="box-sizing: border-box;">Module 05: Adding Tables</li><li fr-original-style="" style="box-sizing: border-box;">Module 06: Inserting Graphic Objects</li><li fr-original-style="" style="box-sizing: border-box;">Module 07: Controlling Page Appearance</li><li fr-original-style="" style="box-sizing: border-box;">Module08: Preparing to Publish a Document</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">-------------- And 10 more courses --------------</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">How will I get my Microsoft Office with Admin, Secretarial &amp; PA Certificate?</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">After successfully completing the Microsoft Office with Admin, Secretarial &amp; PA bundle, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">PDF Certificate: Free (Previously, it was &pound;6*11 = &pound;66)</strong></li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Hard Copy Certificate: Free (For The Title Course: Previously it was &pound;10)<br fr-original-style="" style="box-sizing: border-box;"></strong></li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Please Note:</strong> The delivery charge inside the UK is &pound;6.99, and the international students must pay a &pound;9.99 shipping cost.</p><h2 fr-original-style="" style="box-sizing: border-box;">
        
        <div fr-original-style="" style="box-sizing: border-box;">CPD</div>
    </h2><div id="cpd" fr-original-style="" style="box-sizing: border-box;">
                            <div fr-original-style="" style="box-sizing: border-box;">
                                <div fr-original-style="" style="box-sizing: border-box;">
                                    <div fr-original-style="" style="box-sizing: border-box;">
                                        220 CPD hours/points
                                    </div>
                                        <div fr-original-style="" style="box-sizing: border-box;">
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2 fr-original-style="" style="box-sizing: border-box;">
        
        <div fr-original-style="" style="box-sizing: border-box;">Who is this course for?</div>
    </h2><div id="who_is_this_course_for" 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;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">This Microsoft Office with Admin, Secretarial &amp; PA course is suitable for the following:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Individuals who are new to Microsoft Office with Admin, Secretarial &amp; PA and want to learn the basics of the program</li><li fr-original-style="" style="box-sizing: border-box;">Professionals who want to improve their skills and knowledge of Microsoft Office</li><li fr-original-style="" style="box-sizing: border-box;">Admin, Secretarial &amp; PA and other office workers who use Microsoft Office in their day-to-day work</li><li fr-original-style="" style="box-sizing: border-box;">Professionals who are looking to improve their Microsoft Office skills for career advancement or to increase their employability</li><li fr-original-style="" style="box-sizing: border-box;">Students who want to improve their productivity and efficiency by learning to use Microsoft Office more effectively</li></ul>
                        </div><h2 fr-original-style="" style="box-sizing: border-box;">
        
        </h2><div id="requirements" fr-original-style="" style="box-sizing: border-box;">
                        </div><h2 fr-original-style="" style="box-sizing: border-box;">
        
        <div fr-original-style="" style="box-sizing: border-box;">Career path</div>
    </h2><div id="career_path" 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;">Having this Microsoft Office with Admin, Secretarial &amp; PA expertise will increase the value of your CV and open you up to multiple job sectors:</p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Administrative Assistant</strong>: &pound;20,000 - &pound;30,000</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Secretary</strong>: &pound;25,000 - &pound;35,000</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Personal Assistant</strong>: &pound;30,000 - &pound;40,000</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Legal Secretary</strong>: &pound;35,000 - &pound;45,000</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Office Manager</strong>: &pound;40,000 - &pound;50,000</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Document Controller</strong>: &pound;35,000 - &pound;45,000</li></ul>
                        </div><h2 fr-original-style="" style="box-sizing: border-box;">
        
        <div fr-original-style="" style="box-sizing: border-box;">Certificates</div>
    </h2><div id="optional_extras" fr-original-style="" style="box-sizing: border-box;">
                                    <h4 fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Certificate of Completion (Hard Copy)</span></h4>
      <ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Hard copy certificate -
Included
 &nbsp; &nbsp; &nbsp; 
 &nbsp; &nbsp; &nbsp; &nbsp;</li></ul><h4 fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Certificate of Completion (PDF)</span></h4>
        <ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">
            Digital certificate -
            Included
        </li></ul>

                        </div>

Course Overview:
Whether you're a novice or an experienced user wishing to advance your Microsoft Office Skills (Excel, Word, PowerPoint), IT Functional Skills with Admin, Secretarial & PA, this Microsoft Office course offers many things for you. This Microsoft Office Skills with Admin, Secretarial & PA course is designed to provide individuals with a comprehensive introduction to the features and functionality.
This Microsoft Office Skills (Excel, Word, PowerPoint) & IT Skills with Admin, Secretarial & PA Bundle Consists of the following Premium courses:
Course 01: Microsoft Office Word Diploma
Course 02: Microsoft Office PowerPoint Diploma
Course 03: Microsoft Office Excel
Course 04: Microsoft Access
Course 05: Functional Skills IT
Course 06: Admin, Secretarial & PA
Course 07: Legal Secretary and Office Skills Diploma
Course 08: Document Control
Course 01: Touch Typing
Course 02: Business Writing
Course 03: Leadership & Management

Enrol with Microsoft Office with Admin, Secretarial & PA Bundle Today!!



Key Features of the Course:
FREE Microsoft Office CPD-accredited certificate
Get a free student ID card with Microsoft Office training (£10 applicable for international delivery)
Lifetime access to the Microsoft Office course materials
The Microsoft Office program comes with 24/7 tutor support
Get instant access to this Microsoft Office course
Learn Microsoft Office training from anywhere in the world
The Microsoft Office training is affordable and simple to understand
The Microsoft Office training is an entirely online



Description
The curriculum of the Microsoft Office with Admin, Secretarial & PA Bundle:
Course 01: Microsoft Office Word Diploma
Module 01: Getting Started with Word
Module 02: Formatting Text and Paragraphs
Module 03: Working More Efficiently
Module 04: Managing Lists
Module 05: Adding Tables
Module 06: Inserting Graphic Objects
Module 07: Controlling Page Appearance
Module 08: Preparing to Publish a Document
-------------- And 10 more courses --------------
How will I get my Microsoft Office with Admin, Secretarial & PA Certificate?
After successfully completing the Microsoft Office with Admin, Secretarial & PA bundle, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.
PDF Certificate: Free (Previously, it was £9.99*11 = £109)
Hard Copy Certificate: Free (For The Title Course: Previously it was £14.99)
Please Note: The delivery charge inside the UK is £6.99, and the international students must pay a £9.99 shipping cost.
So, enrol right away in this Microsoft Office bundle!



Who is this course for? 
This Microsoft Office with Admin, Secretarial & PA course is suitable for the following:
Individuals who are new to Microsoft Office with Admin, Secretarial & PA and want to learn the basics of the program
Professionals who want to improve their skills and knowledge of Microsoft Office
Admin, Secretarial & PA and other office workers who use Microsoft Office in their day-to-day work
Professionals who are looking to improve their Microsoft Office skills for career advancement or to increase their employability
Students who want to improve their productivity and efficiency by learning to use Microsoft Office more effectively



Career Path 
Having this Microsoft Office with Admin, Secretarial & PA expertise will increase the value of your CV and open you up to multiple job sectors:
Administrative Assistant: £20,000 - £30,000
Secretary: £25,000 - £35,000
Personal Assistant: £30,000 - £40,000
Legal Secretary: £35,000 - £45,000
Office Manager: £40,000 - £50,000
Document Controller: £35,000 - £45,000



Certificates
Certificate of Completion (Hard Copy)
Hard copy certificate -
Included
Certificate of Completion (PDF)
Digital certificate - Included

Secretarial & PA

Office Administration

Microsoft

Whether you're a novice or an experienced user wishing to advance your Microsoft Office Skills (Excel, Word, PowerPoint), IT Functional Skills with Admin, Secretarial & PA, this course offers many things for you. 

Microsoft Office Skills (Microsoft Excel, Word, PowerPoint) with Admin, Secretarial & PA

Limited Time Offer

<h2><strong>Course Overview:</strong></h2>
<p> 
<strong>Discover the power of Microsoft Office Essentials with our Level 2 Microsoft Office Essentials Course.</strong> In today's digital age, proficiency in Microsoft Office is no longer a mere advantage; it has become an essential skill for success in nearly every industry. <strong>According to recent surveys, over 80% of job listings require proficiency in Microsoft Office, with Excel, Word, PowerPoint, and Access being the most sought-after applications.</strong> As the workplace evolves, the demand for individuals with advanced knowledge of these tools rapidly increases. 
</p> 
<p> 
<strong>Our comprehensive Level 2 Counselling Course allows you to navigate the complexities of Microsoft Office with ease and confidence. Designed to cater to beginners and intermediate users, this course offers a step-by-step approach to mastering Excel, Word, PowerPoint, and Access.</strong> You will delve into various topics, including creating and saving workbooks, formatting text and data, managing worksheets, creating impactful presentations, and building robust databases.
</p> 
<p> 
Enrol today in our Level 2 Microsoft Office Essentials course and unlock a world of opportunities, increased productivity, and career growth!
 </p> 
<hr />

<h2><strong>Key Features of the Course:</strong></h2>
<ul>
 	<li>CPD certificate upon successful completion</li>
 	<li>24/7 Learning Assistance for continuous support and guidance</li>
</ul>

<hr />

<h2><strong>Who is This Course For?</strong></h2>
<p> 
This course is ideal for individuals at various stages of their careers, including professionals seeking to enhance their Microsoft Office skills, students aiming to improve their employability, and anyone who wants to boost their productivity and efficiency in the workplace.
</p> 
<hr />

<h2><strong>What You Will Learn:</strong></h2>
<p> 
Throughout this Level 2 Microsoft Office Essentials course, you will <strong>develop a solid foundation in Microsoft Office essentials. Starting with Excel, you will learn to navigate the user interface, create and format spreadsheets, apply formulas and functions, and customise the appearance of your data. In Word, you will master document creation, formatting, and editing, as well as utilising advanced features like tables, symbols, and images. PowerPoint will enable you to create captivating presentations, while Access will equip you with the skills to build and manage databases effectively.</strong>
</p> 

<hr />

<h2><strong>Why Enrol in This Course:</strong></h2>
<p> 
The course has good reviewed content and a recently updated curriculum that ensures you gain the most relevant knowledge aligned with industry trends. Develop in-demand skills employers seek, boosting your career advancement and employability. Experience time-efficient learning with our structured approach, allowing you to achieve proficiency in Microsoft Office essentials quickly.
 </p> 
<hr />

<h2><strong>Requirements:</strong></h2>
<p> 
No prior experience or expertise is necessary to enrol in this course. Basic computer literacy and access to Microsoft Office applications will be beneficial.
 </p> 
<hr />

<h2><strong>Career Path:</strong></h2>
<p> 
Upon completion of this course, you can pursue various professions, including:
 </p> 
<ul>
 	<li>Administrative Assistant (£20,000 - £25,000 per annum)</li>
 	<li>Data Entry Operator (£18,000 - £22,000 per annum)</li>
 	<li>Office Manager (£25,000 - £35,000 per annum)</li>
 	<li>Project Coordinator (£25,000 - £35,000 per annum)</li>
 	<li>Database Administrator (£30,000 - £45,000 per annum)</li>
 	<li>Executive Assistant (£25,000 - £40,000 per annum)</li>
 	<li>Business Analyst (£35,000 - £50,000 per annum)</li>
</ul>

<hr />

<h2><strong>Certification:</strong></h2>
<p> 
Upon completing the course, you <strong>will receive a CPD certificate,</strong> demonstrating your proficiency in Microsoft Office essentials and enhancing your professional credibility.
 </p> 
<hr /> <h3>Course Curriculum</h3><div><p>32 sections • 96 lectures • 16:31:00 total length</p></div><div><div><div><div><div></div></div></div></div><div><div><div><div><div><div><p>•Navigate the Excel User Interfact: 00:28:00</p></div><div><div><p>•Use Excel Commands: 00:10:00</p></div><div><div><p>•Create and Save a Basic Workbook: 00:19:00</p></div><div><div><p>•Enter Cell Data: 00:12:00</p></div><div><div><p>•Use Excel Help: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create Worksheet Formulas: 00:15:00</p></div><div><div><p>•Insert Functions: 00:17:00</p></div><div><div><p>•Reuse Formulas and Functions: 00:17:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00</p></div><div><div><p>•Search for and Replace Data: 00:09:00</p></div><div><div><p>•Use Proofing and Research Tools: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Apply Text Formats: 00:16:00</p></div><div><div><p>•Apply Number Format: 00:08:00</p></div><div><div><p>•Align Cell Contents: 00:09:00</p></div><div><div><p>•Apply Styles and Themes: 00:12:00</p></div><div><div><p>•Apply Basic Conditional Formatting: 00:11:00</p></div><div><div><p>•Create and Use Templates: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Preview and Print a Workbook: 00:11:00</p></div><div><div><p>•Set Up the Page Layout: 00:09:00</p></div><div><div><p>•Configure Headers and Footers: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Manage Worksheets: 00:05:00</p></div><div><div><p>•Manage Workbook and Worksheet Views: 00:07:00</p></div><div><div><p>•Manage Workbook Properties: 00:06:00</p></div></div></div></div></div><div><div><div><div></div></div></div></div><div><div><div><div><div><div><p>•Navigate in Microsoft Word: 00:12:00</p></div><div><div><p>•Create and Save Word Documents: 00:24:00</p></div><div><div><p>•Manage Your Workspace: 00:06:00</p></div><div><div><p>•Edit Documents: 00:16:00</p></div><div><div><p>•Preview and Print Documents: 00:04:00</p></div><div><div><p>•Customize the Word Environment: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Apply Character Formatting: 00:17:00</p></div><div><div><p>•Control Paragraph Layout: 00:19:00</p></div><div><div><p>•Align Text Using Tabs: 00:07:00</p></div><div><div><p>•Display Text in Bulleted or Numbered Lists: 00:03:00</p></div><div><div><p>•Apply Borders and Shading: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Make Repetitive Edits: 00:06:00</p></div><div><div><p>•Apply Repetitive Formatting: 00:10:00</p></div><div><div><p>•Use Styles to Streamline Repetitive Formatting Tasks: 00:14:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Sort a List: 00:05:00</p></div><div><div><p>•Format a List: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Insert a Table: 00:07:00</p></div><div><div><p>•Modify a Table: 00:06:00</p></div><div><div><p>•Format a Table: 00:03:00</p></div><div><div><p>•Convert Text to a Table: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Insert Symbols and Special Characters: 00:04:00</p></div><div><div><p>•Add Images to a Document: 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Apply a Page Border and Color: 00:03:00</p></div><div><div><p>•Add Headers and Footers: 00:06:00</p></div><div><div><p>•Control Page Layout: 00:05:00</p></div><div><div><p>•Add a Watermark: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Check Spelling Grammar and Readability: 00:07:00</p></div><div><div><p>•Use Research Tools: 00:06:00</p></div><div><div><p>•Check Accessibility: 00:03:00</p></div><div><div><p>•Save a Document to Other Formats: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Workbooks - Microsoft Word 2016 (Beginner): 00:00:00</p></div></div></div></div></div><div><div><div><div></div></div></div></div><div><div><div><div><div><div><p>•Navigate the PowerPoint Environment: 00:28:00</p></div><div><div><p>•View and Navigate a Presentation: 00:15:00</p></div><div><div><p>•Create and Save a PowerPoint Presentation: 00:13:00</p></div><div><div><p>•Use PowerPoint Help: 00:10:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Select a Presentation Type: 00:08:00</p></div><div><div><p>•Edit Text: 00:13:00</p></div><div><div><p>•Build a Presentation: 00:27:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Format Characters: 00:11:00</p></div><div><div><p>•Format Paragraphs: 00:16:00</p></div><div><div><p>•Format Text Boxes: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Insert Images: 00:10:00</p></div><div><div><p>•Insert Shapes: 00:15:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Edit Objects: 00:16:00</p></div><div><div><p>•Format Objects: 00:06:00</p></div><div><div><p>•Group Objects: 00:04:00</p></div><div><div><p>•Arrange Objects: 00:07:00</p></div><div><div><p>•Animate Objects: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create a Table: 00:09:00</p></div><div><div><p>•Insert a Table from Other Microsoft Office Applications: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create a Chart: 00:10:00</p></div><div><div><p>•Format a Chart: 00:10:00</p></div><div><div><p>•Insert a Chart from Microsoft Excel: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Review Your Presentation: 00:11:00</p></div><div><div><p>•Apply Transitions: 00:05:00</p></div><div><div><p>•Print Your Presentation: 00:05:00</p></div><div><div><p>•Deliver Your Presentation: 00:08:00</p></div></div></div></div></div><div><div><div><div></div></div></div></div><div><div><div><div><div><div><p>•Orientation to Microsoft Access1: 00:39:00</p></div><div><div><p>•Create a Simple Access Database: 00:10:00</p></div><div><div><p>•Get Help and Configure Options in Microsoft Access: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Modify Table Data: 00:17:00</p></div><div><div><p>•Sort and Filter Records: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create Basic Queries: 00:15:00</p></div><div><div><p>•Sort and Filter Data in a Query: 00:14:00</p></div><div><div><p>•Perform Calculations in a Query: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create Basic Access Forms: 00:07:00</p></div><div><div><p>•Work with Data on Access Forms: 00:23:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Create a Report: 00:23:00</p></div><div><div><p>•Add Controls to a Report: 00:12:00</p></div><div><div><p>•Enhance the Appearance of a Report: 00:05:00</p></div><div><div><p>•Prepare a Report for Print: 00:03:00</p></div><div><div><p>•Organize Report Information: 00:15:00</p></div><div><div><p>•Format Reports: 00:12:00</p></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></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></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></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Course Overview:
Discover the power of Microsoft Office with our Level 2 Microsoft Office Essentials Course. In today's digital age, proficiency in Microsoft Office is no longer a mere advantage; it has become an essential skill for success in nearly every industry. According to recent surveys, over 80% of job listings require proficiency in Microsoft Office, with Excel, Word, PowerPoint, and Access being the most sought-after applications. As the workplace evolves, the demand for individuals with advanced knowledge of Microsoft Office tools rapidly increases. 
Our comprehensive Level 2 Microsoft Office Course allows you to navigate the complexities of Microsoft Office with ease and confidence. Designed to cater to beginners and intermediate users, this course offers a step-by-step approach to mastering Excel, Word, PowerPoint, and Access. You will get into various topics, including creating and saving workbooks, formatting text and data, managing worksheets, creating impactful presentations, and building robust databases all with the help of Microsoft Office.
Enrol today in our Level 2 Microsoft Office Essentials course and unlock a world of opportunities, increased productivity, and career growth! 



Key Features of the Course:
FREE Microsoft Office CPD-accredited certificate
Get a free student ID card with Microsoft Office training (£10 applicable for international delivery)
Lifetime access to the Microsoft Office course materials
The Microsoft Office program comes with 24/7 tutor support
Get instant access to this Microsoft Office course
Learn Microsoft Office training from anywhere in the world
The Microsoft Office training is affordable and simple to understand
The Microsoft Office training is an entirely online



Who is This Course For?
This Microsoft Office course is ideal for individuals at various stages of their careers, including professionals seeking to enhance their Microsoft Office skills, students aiming to improve their employability, and anyone who wants to boost their productivity and efficiency in the workplace.




What You Will Learn:
Throughout this Level 2 Microsoft Office Essentials course, you will develop a solid foundation in Microsoft Office Essentials. Starting with Excel, you will learn to navigate the user interface, create and format spreadsheets, apply formulas and functions, and customise the appearance of your data. In Word, you will master document creation, formatting, and editing, as well as utilising advanced features like tables, symbols, and images. PowerPoint will enable you to create captivating presentations, while Access will equip you with the skills to build and manage databases effectively.




Why Enrol in This Course:
The Microsoft Office course has well-reviewed content and a recently updated curriculum that ensures you gain the most relevant knowledge aligned with industry trends. Acquire essential knowledge and get a chance to develop in-demand skills employers seek, boosting your career advancement and employability.



Requirements:
No prior experience or expertise is necessary to enrol in this Microsoft Office course. Basic computer literacy and access to Microsoft Office applications will be beneficial. 



Career Path:
 Upon completion of this course, you can pursue various professions, including: 
Administrative Assistant (£20,000 - £25,000 per annum)
Microsoft Office Specialist [MOS] (£18,000 - £22,000 per annum)
Office Manager (£25,000 - £35,000 per annum)
Project Coordinator (£25,000 - £35,000 per annum)
Data Entry Operator (£20,000 - £28,000 per annum)
Executive Assistant (£25,000 - £40,000 per annum)
Business Analyst (£35,000 - £50,000 per annum)



Certification:
Upon completing the course, you will receive a CPD certificate, demonstrating your proficiency in Microsoft Office essentials and enhancing your professional credibility. 



Course Curriculum
32 sections • 96 lectures • 16:31:00 total length
•Navigate the Excel User Interface: 00:28:00
•Use Excel Commands: 00:10:00
•Create and Save a Basic Workbook: 00:19:00
•Enter Cell Data: 00:12:00
•Use Excel Help: 00:05:00
•Create Worksheet Formulas: 00:15:00
•Insert Functions: 00:17:00
•Reuse Formulas and Functions: 00:17:00
•Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00
•Search for and Replace Data: 00:09:00
•Use Proofing and Research Tools: 00:07:00
•Apply Text Formats: 00:16:00
•Apply Number Format: 00:08:00
•Align Cell Contents: 00:09:00
•Apply Styles and Themes: 00:12:00
•Apply Basic Conditional Formatting: 00:11:00
•Create and Use Templates: 00:08:00
•Preview and Print a Workbook: 00:11:00
•Set Up the Page Layout: 00:09:00
•Configure Headers and Footers: 00:07:00
•Manage Worksheets: 00:05:00
•Manage Workbook and Worksheet Views: 00:07:00
•Manage Workbook Properties: 00:06:00
•Navigate in Microsoft Word: 00:12:00
•Create and Save Word Documents: 00:24:00
•Manage Your Workspace: 00:06:00
•Edit Documents: 00:16:00
•Preview and Print Documents: 00:04:00
•Customize the Word Environment: 00:08:00
•Apply Character Formatting: 00:17:00
•Control Paragraph Layout: 00:19:00
•Align Text Using Tabs: 00:07:00
•Display Text in Bulleted or Numbered Lists: 00:03:00
•Apply Borders and Shading: 00:05:00
•Make Repetitive Edits: 00:06:00
•Apply Repetitive Formatting: 00:10:00
•Use Styles to Streamline Repetitive Formatting Tasks: 00:14:00
•Sort a List: 00:05:00
•Format a List: 00:06:00
•Insert a Table: 00:07:00
•Modify a Table: 00:06:00
•Format a Table: 00:03:00
•Convert Text to a Table: 00:04:00
•Insert Symbols and Special Characters: 00:04:00
•Add Images to a Document: 00:11:00
•Apply a Page Border and Color: 00:03:00
•Add Headers and Footers: 00:06:00
•Control Page Layout: 00:05:00
•Add a Watermark: 00:04:00
•Check Spelling Grammar and Readability: 00:07:00
•Use Research Tools: 00:06:00
•Check Accessibility: 00:03:00
•Save a Document to Other Formats: 00:04:00
•Workbooks - Microsoft Word 2016 (Beginner): 00:00:00
•Navigate the PowerPoint Environment: 00:28:00
•View and Navigate a Presentation: 00:15:00
•Create and Save a PowerPoint Presentation: 00:13:00
•Use PowerPoint Help: 00:10:00
•Select a Presentation Type: 00:08:00
•Edit Text: 00:13:00
•Build a Presentation: 00:27:00
•Format Characters: 00:11:00
•Format Paragraphs: 00:16:00
•Format Text Boxes: 00:09:00
•Insert Images: 00:10:00
•Insert Shapes: 00:15:00
•Edit Objects: 00:16:00
•Format Objects: 00:06:00
•Group Objects: 00:04:00
•Arrange Objects: 00:07:00
•Animate Objects: 00:07:00
•Create a Table: 00:09:00
•Insert a Table from Other Microsoft Office Applications: 00:06:00
•Create a Chart: 00:10:00
•Format a Chart: 00:10:00
•Insert a Chart from Microsoft Excel: 00:05:00
•Review Your Presentation: 00:11:00
•Apply Transitions: 00:05:00
•Print Your Presentation: 00:05:00
•Deliver Your Presentation: 00:08:00
•Orientation to Microsoft Access1: 00:39:00
•Create a Simple Access Database: 00:10:00
•Get Help and Configure Options in Microsoft Access: 00:06:00
•Modify Table Data: 00:17:00
•Sort and Filter Records: 00:05:00
•Create Basic Queries: 00:15:00
•Sort and Filter Data in a Query: 00:14:00
•Perform Calculations in a Query: 00:08:00
•Create Basic Access Forms: 00:07:00
•Work with Data on Access Forms: 00:23:00
•Create a Report: 00:23:00
•Add Controls to a Report: 00:12:00
•Enhance the Appearance of a Report: 00:05:00
•Prepare a Report for Print: 00:03:00
•Organize Report Information: 00:15:00
•Format Reports: 00:12:00

Microsoft Certification

Level 2 Microsoft Office Essentials

<p><strong>Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now</strong></p> <p>With a single payment, you will gain access to <strong>Level 2 Microsoft Office Essentials</strong> including an original hardcopy certificate, a transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc.</p> <p><strong>Courses are included with this Level 2 Microsoft Office Essentials:</strong></p> <ul> <li><strong>Course 01: </strong>Level 2 Microsoft Office Essentials</li><li><strong>Course 02: </strong>Data Analysis in Excel Level 3 Course</li><li><strong>Course 03: </strong>Personal Assistant &amp; Skill Development Training</li><li><strong>Course 04: </strong>Legal Secretaries Advanced Diploma</li><li><strong>Course 05: </strong>Financial Modeling Using Excel</li><li><strong>Course 06: </strong>Data Protection and Data Security Level 2</li><li><strong>Course 07:</strong> Team Management</li><li><strong>Course 08: </strong>Microsoft Teams</li><li><strong>Course 09: </strong>Negotiation Essential Skills - Level 3</li><li><strong>Course 10: </strong>Minute Taking Essentials Level 2</li><li><strong>Course 11: </strong>Time Management - 2 CPD Points</li></ul> <p>Become a valuable and skilled member of any organisation's administration team by learning to master the most popular Microsoft Office tools.</p> <p>This course provides full and comprehensive tutorials for each one of Microsoft's essential products and will boost your capabilities with them all.</p> <p>The course provides up-to-date training for Excel, PowerPoint, and Word. You will be given expert tuition and interactive exercises in the online modules, enabling you to attain the abilities to boost your administrative career prospects for employers. On completion of the final assessment, you will be able to present, write, or calculate efficiently for any critical assignment.</p> <p>Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential.</p> <p>This bundle will provide you with the <strong>CPD certificate </strong>that you'll need to succeed.</p> <p>Gain experience online and interact with experts. This can prove to be the perfect way to get noticed by a prospective employer and stand out from the crowd.</p> <p>This bundle has been rated and reviewed highly by our learners and professionals alike. We have a passion for teaching, and it shows.</p> <p>All of our courses have interactive online modules that allow studying to take place where and when you want it to.</p> <p>The only thing you need to take <strong>Level 2 Microsoft Office Essentials </strong> is Wi-Fi and a screen. You'll never be late for class again.</p> <p>Experienced tutors and mentors will be there for you whenever you need them, and solve all your queries through email and chat boxes.</p> <p><strong>Benefits you'll get choosing Apex Learning for this Level 2 Microsoft Office Essentials:</strong></p> <ul> <li>One payment, but lifetime access to 11 CPD courses</li><li>Certificates, student ID for the title course included in a one-time fee</li><li>Full tutor support available from Monday to Friday</li><li>Free up your time - don't waste time and money travelling for classes</li><li>Accessible, informative modules taught by expert instructors</li><li>Learn at your ease - anytime, from anywhere</li><li>Study the course from your computer, tablet or mobile device</li><li>CPD accredited course - improve the chance of gaining professional skills</li><li>Gain valuable knowledge without leaving your home</li></ul><p><strong>Course Curriculum</strong></p> <p><strong>Level 2 Microsoft Office Essentials</strong></p> <p><strong>**Excel 2016**</strong></p> <p><strong>Getting Started with Microsoft Office Excel 2016</strong></p> <ul> <li>Navigate the Excel User Interface</li><li>Use Excel Commands</li><li>Create and Save a Basic Workbook</li><li>Enter Cell Data</li><li>Use Excel Help</li></ul> <p><strong>Performing Calculations</strong></p> <ul> <li>Create Worksheet Formulas</li><li>Insert Functions</li><li>Reuse Formulas and Functions</li></ul> <p><strong>Modifying a Worksheet</strong></p> <ul> <li>Insert, Delete, and Adjust Cells, Columns, and Rows</li><li>Search for and Replace Data</li><li>Use Proofing and Research Tools</li></ul> <p><strong>Formatting a Worksheet</strong></p> <ul> <li>Apply Text Formats</li><li>Apply Number Format</li><li>Align Cell Contents</li><li>Apply Styles and Themes</li><li>Apply Basic Conditional Formatting</li><li>Create and Use Templates</li></ul> <p><strong>Printing Workbooks</strong></p> <ul> <li>Preview and Print a Workbook</li><li>Set Up the Page Layout</li><li>Configure Headers and Footers</li></ul> <p><strong>Managing Workbooks</strong></p> <ul> <li>Manage Worksheets</li><li>Manage Workbook and Worksheet Views</li><li>Manage Workbook Properties</li></ul> <p><strong>**Word 2016**</strong></p> <ul> <li>Getting Started with Word</li><li>Create and Save Word Documents</li><li>Manage Your Workspace</li><li>Edit Documents</li><li>Preview and Print Documents</li><li>Customize the Word Environment</li></ul> <p>And Much More...</p> <p><strong>Formatting Text and Paragraphs</strong></p> <ul> <li>Apply Character Formatting</li><li>Control Paragraph Layout</li><li>Align Text Using Tabs</li><li>Display Text in Bulleted or Numbered Lists</li><li>Apply Borders and Shading</li></ul> <p><strong>Working More Efficiently</strong></p> <ul> <li>Make Repetitive Edits</li><li>Apply Repetitive Formatting</li><li>Use Styles to Streamline Repetitive Formatting Tasks</li></ul> <p><strong>Managing Lists</strong></p> <ul> <li>Sort a List</li><li>Format a List</li></ul> <p><strong>Adding Tables</strong></p> <ul> <li>Insert a Table</li><li>Modify a Table</li><li>Format a Table</li><li>Convert Text to a Table</li></ul> <p><strong>Inserting Graphic Objects</strong></p> <ul> <li>Insert Symbols and Special Characters</li><li>Add Images to a Document</li></ul> <p><strong>Controlling Page Appearance</strong></p> <ul> <li>Apply a Page Border and Color</li><li>Add Headers and Footers</li><li>Control Page Layout</li><li>Add a Watermark</li></ul> <p><strong>Preparing to Publish a Document</strong></p> <ul> <li>Check Spelling Grammar and Readability</li><li>Use Research Tools</li><li>Check Accessibility</li><li>Save a Document to Other Formats</li></ul> <p><strong>Workbooks - Microsoft Word 2016 (Beginner)</strong></p> <ul> <li>Workbooks - Microsoft Word 2016 (Beginner)</li></ul> <p><strong>**PowerPoint 2016**</strong></p> <p><strong>PowerPoint Interface</strong></p> <ul> <li>Navigate the PowerPoint Environment</li><li>View and Navigate a Presentation</li><li>Create and Save a PowerPoint Presentation</li><li>Use PowerPoint Help</li></ul> <p><strong>Presentation Basics</strong></p> <ul> <li>Select a Presentation Type</li><li>Edit Text</li><li>Build a Presentation</li></ul> <p><strong>Formatting</strong></p> <ul> <li>Format Characters</li><li>Format Paragraphs</li><li>Format Text Boxes</li></ul> <p><strong>Inserting Options</strong></p> <ul> <li>Insert Images</li><li>Insert Shapes</li></ul> <p><strong>Working with Objects</strong></p> <ul> <li>Edit Objects</li><li>Format Objects</li><li>Group Objects</li><li>Arrange Objects</li><li>Animate Objects</li></ul> <p><strong>Table</strong></p> <ul> <li>Create a Table</li><li>Create a Table</li></ul> <p>And Much More...</p> <p><strong>Charts</strong></p> <ul> <li>Create a Chart</li><li>Format a Chart</li></ul> <p>And Much More...</p> <p><strong>Review and Presentatin</strong></p> <ul> <li>Review Your Presentation</li><li>Apply Transitions</li><li>Print Your Presentation</li><li>Deliver Your Presentation</li></ul> <p><strong>**Access 2016**</strong></p> <p><strong>Introduction to Access</strong></p> <ul> <li>Create a Simple Access Database</li></ul> <p>And Much More...</p> <p><strong>Modify Data</strong></p> <ul> <li>Modify Table Data</li><li>Sort and Filter Records</li></ul> <p><strong>Working with Queries</strong></p> <ul> <li>Create Basic Queries</li><li>Sort and Filter Data in a Query</li><li>Perform Calculations in a Query</li></ul> <p><strong>Access Forms</strong></p> <ul> <li>Create Basic Access Forms</li><li>Work with Data on Access Forms</li></ul> <p><strong>Working with Reports</strong></p> <ul> <li>Create a Report</li><li>Add Controls to a Report</li><li>Enhance the Appearance of a Report</li><li>Prepare a Report for Print</li><li>Organize Report Information</li><li>Format Reports</li></ul> <p><strong>How will I get my Certificate?</strong></p> <p>After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.</p> <ul> <li><strong>PDF Certificate: Free (Previously it was £10 * 11 = £110)</strong></li><li><strong>Hard Copy Certificate: Free (For The Title Course)</strong></li></ul> <p><strong>P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. </strong></p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        125 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                             <p>There is no experience or previous qualifications required for enrolment on this bundle. It is available to all students, of all academic backgrounds.</p> 
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>Our bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.</p> <p>There is no time limit for completing this course, it can be studied in your own time at your own pace.</p> 
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>Having these various CPD certificate will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management, Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc.</p> 
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

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

                        </div>

Overview
Boost Your Career with Apex Learning and Get Noticed By Recruiters in this Hiring Season! Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £180 as a Gift - Enrol Now!
Become a valuable and skilled member of any organisation's administration team by learning to master the most popular Microsoft Office tools.
This Microsoft Office course provides full and comprehensive tutorials for each one of Microsoft Office's essential products and will boost your capabilities with them all.
The Microsoft Office course provides up-to-date training in Excel, PowerPoint, and Word. You will be given expert tuition and engaging exercises in the online modules, enabling you to attain the abilities to boost your administrative career prospects for employers. On completion of the final assessment of Microsoft Office course, you will be able to present, write, or calculate efficiently for any critical assignment.
With a single payment, you will gain access to the Microsoft Office course including an original hardcopy certificate, a transcript and a student ID card.
Courses are included with this Microsoft Office Essentials:
Course 01: Level 2 Microsoft Office Essentials
Course 02: Data Analysis in Excel Level 3 Course
Course 03: Personal Assistant & Skill Development Training
Course 04: Legal Secretaries Advanced Diploma
Course 05: Financial Modeling Using Excel
Course 06: Data Protection and Data Security Level 2
Course 07: Team Management
Course 08: Microsoft Teams
Course 09: IT Support Technician
Course 10: Minute Taking Essentials Level 2
Course 11: Time Management



Key Features of the Microsoft Office Course:
FREE Microsoft Office CPD-accredited certificate
Get a free student ID card with Microsoft Office training (£10 applicable for international delivery)
Lifetime access to the Microsoft Office course materials
The Microsoft Office program comes with 24/7 tutor support
Get instant access to this Microsoft Office course
Learn Microsoft Office training from anywhere in the world
The Microsoft Office training is affordable and simple to understand
The Microsoft Office training is an entirely online



Description
★★★ Course Curriculum of the Microsoft Office Bundle ★★★
Level 2 Microsoft Office Essentials
**Excel 2016**
Getting Started with Microsoft Office Excel 2016
Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter Cell Data
Use Excel Help
Performing Calculations
Create Worksheet Formulas
Insert Functions
Reuse Formulas and Functions
Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows
Search for and Replace Data
Use Proofing and Research Tools
and much more…
=========>>>>> And 10 More Courses <<<<<=========
How will I get my Microsoft Office Certificate?
After successfully completing the Microsoft Office course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement.
PDF Certificate: Free (Previously it was £9.99 * 11 = £109)
Hard Copy Certificate: Free (For The Title Course: Previously it was £14.99)
P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99.
So, enrol in this Microsoft Office bundle and start working towards a successful career!



Who is this course for? 
There is no experience or previous qualifications required for enrolment on this Microsoft Office bundle. It is available to all students, of all academic backgrounds.



Requirements 
Our Microsoft Office bundle is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This Microsoft Office course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.
There is no time limit for completing this Microsoft Office course, it can be studied in your own time at your own pace.



Career path 
Having this Microsoft Office certificate will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc.

Professional Skills

IT Certifications

Microsoft Office Skills (Microsoft Excel, Word, PowerPoint), Administration & IT Training

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Our <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Mastering Microsoft Office: Word, Excel, PowerPoint, and 365</strong> course provides an in-depth exploration of Excel 2021, starting with the basics of creating spreadsheets, entering data, and understanding relative references. Progress to more advanced topics like data handling, page setup, sorting, filtering, and writing sophisticated formulas, including VLOOKUP, HLOOKUP, and the 2021 exclusive XLOOKUP. Learn to create compelling charts and pivot tables that bring your data to life.</p><p style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: var(--text);">In PowerPoint 2021, start with presentation basics and advance to incorporating graphic assets, multimedia, and SmartArt graphics. Master text formatting, bullet options, and table and chart integration to create professional and engaging presentations. Explore the full suite of PowerPoint features, including transitions, animations, and slideshow effects, to captivate your audience.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The Word 2021 modules guide you through document creation, formatting, and layout management. Learn to work with tables, styles, and mail merges. Additionally, discover the collaboration and productivity features of Office 365, which enable seamless sharing and editing across platforms.</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Learning Outcomes of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Master the fundamentals of Excel 2021, including entering data and working with ranges.</li><li fr-original-style="" style="box-sizing: border-box;">Create and modify Excel charts and pivot tables for data analysis.</li><li fr-original-style="" style="box-sizing: border-box;">Develop PowerPoint presentations with advanced animations and multimedia elements.</li><li fr-original-style="" style="box-sizing: border-box;">Format documents in Word 2021, including creating tables and managing styles.</li><li fr-original-style="" style="box-sizing: border-box;">Execute mail merges and manage page layouts effectively in Word 2021.</li><li fr-original-style="" style="box-sizing: border-box;">Utilise Office 365 features for enhanced productivity and collaboration.</li><li fr-original-style="" style="box-sizing: border-box;">Understand and apply advanced Excel formulas like VLOOKUP, HLOOKUP, and XLOOKUP.</li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">The Course Curriculum of&nbsp;Mastering Microsoft Office: Word, Excel, PowerPoint, and 365:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Section 01: Getting Started</li><li fr-original-style="" style="box-sizing: border-box;">Section 02: Excel 2021: Basics</li><li fr-original-style="" style="box-sizing: border-box;">Section 03: Excel 2021: Rows, Columns, And Cells</li><li fr-original-style="" style="box-sizing: border-box;">Section 04: Excel 2021: Data Handling</li><li fr-original-style="" style="box-sizing: border-box;">Section 05: Excel 2021: Page Setting Up And Print</li><li fr-original-style="" style="box-sizing: border-box;">Section 06: Excel 2021: Sorting And Filtering</li><li fr-original-style="" style="box-sizing: border-box;">Section 07: Excel 2021: Writing Formulas</li><li fr-original-style="" style="box-sizing: border-box;">Section 08: Excel 2021: Advanced Formulas</li><li fr-original-style="" style="box-sizing: border-box;">Section 09: Excel 2021: XLOOKUP Only For 2021 And Office 365</li><li fr-original-style="" style="box-sizing: border-box;">Section 10: Excel 2021: Data And Tools</li><li fr-original-style="" style="box-sizing: border-box;">Section 11: Excel 2021: Formatting Data And Tables</li><li fr-original-style="" style="box-sizing: border-box;">Section 12: Excel 2021: Pivot Tables</li><li fr-original-style="" style="box-sizing: border-box;">Section 13: Excel 2021: Charts</li><li fr-original-style="" style="box-sizing: border-box;">Section 14: PowerPoint 2021: Course Introduction</li><li fr-original-style="" style="box-sizing: border-box;">Section 15: PowerPoint 2021: Basics</li><li fr-original-style="" style="box-sizing: border-box;">Section 16: PowerPoint 2021: Text And Bullet Options</li><li fr-original-style="" style="box-sizing: border-box;">Section 17: PowerPoint 2021: Adding Graphic Assets</li><li fr-original-style="" style="box-sizing: border-box;">Section 18: PowerPoint 2021: Picture Formatting</li><li fr-original-style="" style="box-sizing: border-box;">Section 19: PowerPoint 2021: SmartArt Graphics</li><li fr-original-style="" style="box-sizing: border-box;">Section 20: PowerPoint 2021: Working With Tables</li><li fr-original-style="" style="box-sizing: border-box;">Section 21: PowerPoint 2021: Working With Charts</li><li fr-original-style="" style="box-sizing: border-box;">Section 22: PowerPoint 2021: Adding Multimedia</li><li fr-original-style="" style="box-sizing: border-box;">Section 23: PowerPoint 2021: Working With Transition</li><li fr-original-style="" style="box-sizing: border-box;">Section 24: PowerPoint 2021: Animation</li><li fr-original-style="" style="box-sizing: border-box;">Section 25: PowerPoint 2021: Slideshow Effects</li><li fr-original-style="" style="box-sizing: border-box;">Section 26: Word 2021: Introduction</li><li fr-original-style="" style="box-sizing: border-box;">Section 27: Word 2021: Basics</li><li fr-original-style="" style="box-sizing: border-box;">Section 28: Word 2021: Word Formatting</li><li fr-original-style="" style="box-sizing: border-box;">Section 29: Word 2021: Tables</li><li fr-original-style="" style="box-sizing: border-box;">Section 30: Word 2021: Styles</li><li fr-original-style="" style="box-sizing: border-box;">Section 31: Word 2021: Page Layout</li><li fr-original-style="" style="box-sizing: border-box;">Section 32: Word 2021: Envelops And Lables</li><li fr-original-style="" style="box-sizing: border-box;">Section 33: Word 2021: Mail Merges</li><li fr-original-style="" style="box-sizing: border-box;">Section 34: Word 2021: Review And Printing</li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who is this course for:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;">Professionals seeking to enhance their productivity with Microsoft Office tools.</li><li fr-original-style="" style="box-sizing: border-box;">Students aiming to improve their technical skills for academic purposes.</li><li fr-original-style="" style="box-sizing: border-box;">Administrative staff needing comprehensive knowledge of Office applications.</li><li fr-original-style="" style="box-sizing: border-box;">Individuals looking to advance their careers with proficiency in Word, Excel, and PowerPoint.</li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Certification of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course:<br fr-original-style="" style="box-sizing: border-box;"></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="https://cpdqs.co.uk/" target="_blank" rel="noopener noreferrer" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">CPD QS</strong></a> certificates are available at an additional cost of &pound;9.99 for a PDF, &pound;16.99 for a printed hard copy, and &pound;24.99 for both PDF and printed versions.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Requirements:</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This course has no academic entry requirements and is accessible to students from all backgrounds.</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Career Path:</strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Administrative Assistant:</strong> &pound;18,000 - &pound;25,000 per annum</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Data Analyst:</strong> &pound;25,000 - &pound;40,000 per annum</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Office Manager:</strong> &pound;22,000 - &pound;35,000 per annum</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Project Coordinator:</strong> &pound;23,000 - &pound;37,000 per annum</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Executive Assistant:</strong> &pound;25,000 - &pound;45,000 per annum</li><li fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">IT Support Specialist:</strong> &pound;22,000 - &pound;38,000 per annum</li></ul><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Enrol now and advance your Microsoft Office skills to a professional level.</strong></em></p>

Our Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course provides an in-depth exploration of Excel 2021, starting with the basics of creating spreadsheets, entering data, and understanding relative references. Progress to more advanced topics like data handling, page setup, sorting, filtering, and writing sophisticated formulas, including VLOOKUP, HLOOKUP, and the 2021 exclusive XLOOKUP. Learn to create compelling charts and pivot tables that bring your data to life.
In PowerPoint 2021, start with presentation basics and advance to incorporating graphic assets, multimedia, and SmartArt graphics. Master text formatting, bullet options, and table and chart integration to create professional and engaging presentations. Explore the full suite of PowerPoint features, including transitions, animations, and slideshow effects, to captivate your audience.
The Word 2021 modules guide you through document creation, formatting, and layout management. Learn to work with tables, styles, and mail merges. Additionally, discover the collaboration and productivity features of Office 365, which enable seamless sharing and editing across platforms.
Learning Outcomes of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course:
Master the fundamentals of Excel 2021, including entering data and working with ranges.
Create and modify Excel charts and pivot tables for data analysis.
Develop PowerPoint presentations with advanced animations and multimedia elements.
Format documents in Word 2021, including creating tables and managing styles.
Execute mail merges and manage page layouts effectively in Word 2021.
Utilise Office 365 features for enhanced productivity and collaboration.
Understand and apply advanced Excel formulas like VLOOKUP, HLOOKUP, and XLOOKUP.
The Course Curriculum of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365:
Section 01: Getting Started
Section 02: Excel 2021: Basics
Section 03: Excel 2021: Rows, Columns, And Cells
Section 04: Excel 2021: Data Handling
Section 05: Excel 2021: Page Setting Up And Print
Section 06: Excel 2021: Sorting And Filtering
Section 07: Excel 2021: Writing Formulas
Section 08: Excel 2021: Advanced Formulas
Section 09: Excel 2021: XLOOKUP Only For 2021 And Office 365
Section 10: Excel 2021: Data And Tools
Section 11: Excel 2021: Formatting Data And Tables
Section 12: Excel 2021: Pivot Tables
Section 13: Excel 2021: Charts
Section 14: PowerPoint 2021: Course Introduction
Section 15: PowerPoint 2021: Basics
Section 16: PowerPoint 2021: Text And Bullet Options
Section 17: PowerPoint 2021: Adding Graphic Assets
Section 18: PowerPoint 2021: Picture Formatting
Section 19: PowerPoint 2021: SmartArt Graphics
Section 20: PowerPoint 2021: Working With Tables
Section 21: PowerPoint 2021: Working With Charts
Section 22: PowerPoint 2021: Adding Multimedia
Section 23: PowerPoint 2021: Working With Transition
Section 24: PowerPoint 2021: Animation
Section 25: PowerPoint 2021: Slideshow Effects
Section 26: Word 2021: Introduction
Section 27: Word 2021: Basics
Section 28: Word 2021: Word Formatting
Section 29: Word 2021: Tables
Section 30: Word 2021: Styles
Section 31: Word 2021: Page Layout
Section 32: Word 2021: Envelops And Lables
Section 33: Word 2021: Mail Merges
Section 34: Word 2021: Review And Printing
Who is this course for:
Professionals seeking to enhance their productivity with Microsoft Office tools.
Students aiming to improve their technical skills for academic purposes.
Administrative staff needing comprehensive knowledge of Office applications.
Individuals looking to advance their careers with proficiency in Word, Excel, and PowerPoint.
Certification of Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Course:
CPD QS Accredited PDF Certificate - Included
CPD QS Accredited Hard Copy Certificate - Not Included
Requirements:
This course has no academic entry requirements and is accessible to students from all backgrounds.
Career Path:
Administrative Assistant: £18,000 - £25,000 per annum
Data Analyst: £25,000 - £40,000 per annum
Office Manager: £22,000 - £35,000 per annum
Project Coordinator: £23,000 - £37,000 per annum
Executive Assistant: £25,000 - £45,000 per annum
IT Support Specialist: £22,000 - £38,000 per annum
Enrol now and advance your Microsoft Office skills to a professional level.

St. Paul's College

Start your productivity potential! Master Microsoft Office with our comprehensive Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 course. Conquer Excel formulas (VLOOKUP, HLOOKUP, XLOOKUP!), design impactful presentations in PowerPoint, and craft professional documents in Word. Take your skills to the next level and unlock a world of opportunity. Enrol now and become a Microsoft Office pro!

Mastering Microsoft Office: Word, Excel, PowerPoint, and 365

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience.</p>Overview<p>Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data.</p><p>This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data.</p></div><div id="course-pills-2"><h4>Working with Multiple Worksheets and Workbooks </h4><ul><li>Working with Named Ranges</li><li>Link Cells Across Worksheets and Workbooks </li><li>Use 3D References to Calculate Across Worksheets</li><li>Consolidate Data</li></ul><h4>Use Formula Auditing and Error Checking</h4><ul><li>Reveal Formulas</li><li>Trace Cell Precedents and Dependents </li><li>Locate Errors in Formulas </li><li>Watch and Evaluate Formulas </li></ul><h4>Reviewing and Protecting Workbooks </h4><ul><li>Control Data Entry via Data Validation</li><li>Protect Workbook Access</li><li>Protect Worksheets and Cell Content </li><li>Add and Edit Comments</li><li>Prepare a Workbook for Distribution </li><li>Modify Excel's Default Settings</li></ul><h4>Using Macros to Automate Workbook Functionality</h4><ul><li>Create Macros via Recording </li><li>Run Macros via Buttons and Shortcuts</li><li>Assign Macros to the Quick Access Toolbar and Ribbon </li><li>Assign Macros to Objects </li><li>View Macro Code</li></ul><h4>Forecasting and Analysis Data</h4><ul><li>Use Conditional Formatting to Highlight, Sort and Filter Key Data</li><li>Advanced Conditional Formatting using Formulas</li><li>Create Sparklines to Visualise Data</li><li>Add Trendlines to Charts to Visualise and Forecast Trends</li><li>Use Data Tables and Scenarios to Project Potential Outcomes </li><li>Use Goal Seek to Calculate Outcomes</li><li>Forecast Data Trends Using Solver</li></ul></div>

Nexus Human

Visual Basic Analysis

Microsoft Power Automate

Excel - Automating Excel with Macros and Analysis Tools

<h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This advanced financial modelling course will benefit Real Estate Professionals looking to develop their financial modelling skills to the next level. This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course you will...</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Understand how the application and use of Structured Finance products in Real Estate</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Learn how to introduce several tranches of debt in a development project</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Understand how to model different parties to a project</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Create Joint Venture structures between Developers, Lenders and Equity Partners</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Learn advanced modelling techniques to analyse underlying asset risk</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Understand how underlying asset risk impacts return to all parties to a project</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course?</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Real Estate professionals from a mid to senior level with exposure to Real Estate financial models</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, portfolio analysis, and risk analysis</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Real Estate Investors who would like to expand their knowledge and understanding of Real Estate cash flow models to an advanced level</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong></strong>:</p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Mezzanine debt modelling</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Joint Venture structures between developers and lender/equity partners</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Promote and profit share structure calculations</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Advanced project cash flows with mezzanine debts</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Key Real Estate and investment risks, risk adjustment of exit yields</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Sensitivity and Scenario Analysis</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Monte Carlo Analysis</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate &amp; LinkedIn Proficiency Badge</li><li value="2" id="isPasted" fr-original-style="" style="box-sizing: border-box;">Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Course Files</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Real Estate Modelling Masterclass such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>



This advanced financial modelling course will benefit Real Estate Professionals looking to develop their financial modelling skills to the next level. This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.


On this course you will...
Understand how the application and use of Structured Finance products in Real Estate
Learn how to introduce several tranches of debt in a development project
Understand how to model different parties to a project
Create Joint Venture structures between Developers, Lenders and Equity Partners
Learn advanced modelling techniques to analyse underlying asset risk
Understand how underlying asset risk impacts return to all parties to a project


Who will benefit from this course?
Real Estate professionals from a mid to senior level with exposure to Real Estate financial models
Mid-level to senior Real Estate Analysts who would like to advance their financial modelling skills in areas such as development, portfolio analysis, and risk analysis
Real Estate Investors who would like to expand their knowledge and understanding of Real Estate cash flow models to an advanced level


Course Outline:
Mezzanine debt modelling
Joint Venture structures between developers and lender/equity partners
Promote and profit share structure calculations
Advanced project cash flows with mezzanine debts
Key Real Estate and investment risks, risk adjustment of exit yields
Sensitivity and Scenario Analysis
Monte Carlo Analysis


Included in the Course
CPD Accredited Certificate & LinkedIn Proficiency Badge
Course Manual - In-Person Course attendees will receive a Physical Copy, Virtual Course attendees will receive a Virtual Copy and have the option to purchase a Hard Copy at an additional fee
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Real Estate Modelling Masterclass such as course delivery methods, pricing and dates, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Real Estate Finance

Investment Management

This course is intended to the most ambitious modellers in the property industry who would like to be fully proficient in building complex real estate models.

Real Estate Modelling Masterclass (Advanced Cash Flow Modelling)

<p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Follow your dreams by enrolling on the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel course today and develop the experience, skills and knowledge you need to enhance your professional development. Microsoft Office Specialist (MOS) &ndash; Microsoft Excel will help you arm yourself with the qualities you need to work towards your dream job.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Study the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Microsoft Office Specialist (MOS) &ndash; Microsoft Excel course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">This Microsoft Office Specialist (MOS) &ndash; Microsoft Excel course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel course through a mixture of instructional video lessons and online study materials.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Receive online tutor support as you study the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Microsoft Office Specialist (MOS) &ndash; Microsoft Excel course completion.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel course. The Microsoft Office Specialist (MOS) &ndash; Microsoft Excel course is designed by industry experts and is tailored to help you learn new skills with ease.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The Microsoft Office Specialist (MOS) &ndash; Microsoft Excel is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel when it suits you. Access the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel course modules from any internet-enabled device, including computers, tablets, and smartphones.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The Microsoft Office Specialist (MOS) &ndash; Microsoft Excel course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel now and start learning instantly!</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What You Get Out Of Studying Microsoft Office Specialist (MOS) &ndash; Microsoft Excel With Janets</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Free PDF certificate upon successful completion of the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Full one-year access to Microsoft Office Specialist (MOS) &ndash; Microsoft Excel Course materials</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Instant assessment results with the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">No hidden fees with the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Full tutor support available from Monday to Friday with the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Study the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel at your own pace</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Benefit from instant feedback through mock exams and multiple-choice assessments</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Gain a complete understanding of Microsoft Office Specialist (MOS) &ndash; Microsoft Excel</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Accessible, informative modules taught by expert instructors</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Get 24/7 help or advice from our email and live chat teams with the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Study the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel in your own time through your computer, tablet or mobile device</li><li style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Improve your chance of gaining professional skills and better earning potential by completing the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Description&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The Microsoft Office Specialist (MOS) &ndash; Microsoft Excel training course is delivered through Janets&rsquo; online learning platform. Access the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel content from any internet-enabled device whenever or wherever you want to. The Microsoft Office Specialist (MOS) &ndash; Microsoft Excel course has no formal teaching deadlines, meaning you are free to complete the course at your own pace.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Method of Assessment&nbsp;</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">To successfully complete the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel course. After successfully passing the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel course exam, you will be able to apply for a CPD-accredited certificate as proof of your Microsoft Office Specialist (MOS) &ndash; Microsoft Excel qualification.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Certification</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">All students who successfully complete the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel course can instantly download their digital certificate. You can also purchase a hard copy of the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel course certificate, which will be delivered by post for &pound;9.99.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who is this course for</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The Microsoft Office Specialist (MOS) &ndash; Microsoft Excel is ideal for those who already work in this sector or are an aspiring professional. This Microsoft Office Specialist (MOS) &ndash; Microsoft Excel course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Requirements</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The Microsoft Office Specialist (MOS) &ndash; Microsoft Excel is open to all students and has no formal entry requirements. To study the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Career Path</strong></span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">The Microsoft Office Specialist (MOS) &ndash; Microsoft Excel is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Microsoft Office Specialist (MOS) &ndash; Microsoft Excel and gain an industry-recognised qualification that will help you excel in finding your ideal job.</span></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;"></span><span style="font-size: 18px; box-sizing: border-box;" fr-original-style="font-size: 18px;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Contents</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Microsoft Excel Beginners</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Getting Started with Microsoft Office Excel 2016</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Performing Calculations</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Modifying a Worksheet</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Formatting a Worksheet</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Printing Workbooks</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Managing Workbooks</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Workbooks - Microsoft Excel Beginners</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Microsoft Excel Intermediate</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Working with Functions</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Working with Lists</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Analyzing Data</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Visualizing Data with Charts</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Using PivotTables and PivotCharts</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Workbooks - Microsoft Excel Intermediate</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Microsoft Excel Advanced</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Working with Multiple Worksheets and Workbooks</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Using Lookup Functions and Formula Auditing</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Sharing and Protecting Workbooks</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Automating Workbook Functionality</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Creating Sparklines and Mapping Data</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Forecasting Data</span></li><li fr-original-style="" style="box-sizing: border-box;"><span style="font-size: 16px; box-sizing: border-box;" fr-original-style="font-size: 16px;">Workbooks - Microsoft Excel Advanced</span></li></ul>

Janets

Microsoft Project

Master Microsoft Excel with the Microsoft Office Specialist (MOS) certification. Excel at data analysis, visualization, and productivity with expert-level skills. Excel your career with MOS - Microsoft Excel certification today.

Microsoft Office Specialist (MOS) - Microsoft Excel

Overview
★★ 24 Hour Limited Time Flash Sale ★★
Level 7 Advanced Diploma in Microsoft Office - QLS Endorsed
***Key Features of Advanced Diploma in Microsoft Office at QLS Level 7***
Free QLS Certificate
Free CPD PDF Certificate + Transcript
Microsoft Office is an essential tool in the modern workplace, offering a wide range of applications to boost productivity and efficiency. The Level 7 Advanced Diploma in Microsoft Office 2019 is designed to equip learners with expert-level proficiency in Microsoft Office. This course provides comprehensive training on the latest features and functionalities of Microsoft Office applications, ensuring that learners are well-prepared to leverage these tools effectively in various professional contexts.
Mastering Microsoft Office is critical for anyone looking to enhance their career prospects. The Level 7 Advanced Diploma in Microsoft Office 2019 covers in-depth aspects of popular applications such as Word, Excel, PowerPoint, and Outlook. With the increasing reliance on digital communication and documentation, proficiency in Microsoft Office can significantly improve job performance and open doors to new opportunities. This course not only focuses on technical skills but also teaches strategic application to maximise productivity.
The Level 7 Advanced Diploma in Microsoft Office 2019 is suitable for individuals aiming to achieve advanced expertise in Microsoft Office. Whether you are looking to upgrade your skills for career advancement or seeking to gain a competitive edge in the job market, this diploma offers valuable knowledge and certification. By completing this course, learners will be well-equipped to tackle complex tasks and projects using Microsoft Office, making them indispensable assets to any organisation.
Learning Outcomes
Develop advanced proficiency in Microsoft Office applications.
Understand the latest features of Microsoft Office 2019.
Improve efficiency and productivity using Microsoft Office.
Create professional documents with Microsoft Office Word.
Analyse data effectively using Microsoft Office Excel.
Design impactful presentations with Microsoft Office PowerPoint.
Manage emails and schedules proficiently with Microsoft Office Outlook.
Implement advanced techniques in Microsoft Office applications.
Customise Microsoft Office tools to suit specific tasks.
Certificates
Digital Certificate
This course comes with a free CPD Accredited PDF Copy certificate+ Transcript (according to the Learner's Choice). For additional courses, it costs £14.99 per copy.
Level 7 QLS Endorsed Hardcopy Certificate
Hard copy certificate - Included
Certificate delivery is Free for UK residents, whereas it costs £10 for international students as a delivery charge.
Note: Skill-up is a Janets-approved resale partner for Quality Licence Scheme Endorsed courses.
Hard Copy Certificate
Get CPD Accredited Hard Copy certificate for £19.99 per copy. The delivery fee for the Hard Copy certificate, however, is free for UK residents, whereas it costs £10 for international students as delivery charge.
Course Description
The Level 7 Advanced Diploma in Microsoft Office provides an in-depth exploration of Microsoft Office tools and features. This course covers advanced techniques for document creation, data analysis, and presentation design. Gain expert knowledge in Microsoft Office and learn how to apply these skills to enhance your professional capabilities. Ideal for those seeking to elevate their proficiency, this diploma prepares you to handle complex tasks and improve your efficiency in the workplace.
Who is this course for?
Professionals seeking to advance their skills in Microsoft Office.
Individuals aiming to enhance their career prospects with advanced Office knowledge.
Managers and team leaders needing to streamline workflows using Microsoft Office.
Business analysts requiring expert-level data analysis and presentation skills.
Those looking to improve their efficiency and productivity in Microsoft Office.
Requirements
Basic knowledge of Microsoft Office applications.
Familiarity with standard office software operations.
Access to Microsoft Office software.
Career path
Microsoft Office Specialist: £30,000 - £40,000
Data Analyst: £35,000 - £50,000
Office Manager: £32,000 - £45,000
Administrative Executive: £28,000 - £40,000
Project Coordinator: £33,000 - £47,000


Skill Up

Level 7 QLS Endorsed Diploma | 180 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support


47 Courses in Birmingham

HTML5 development fundamentals

By Systems & Network Training

Using Excel

By Pochat Training

Word - intermediate (In-House)

By The In House Training Company

Word - introduction (In-House)

By The In House Training Company

Outlook - introduction (In-House)

By The In House Training Company

Outlook - advanced (In-House)

By The In House Training Company

Microsoft Excel 365

By Enliten IT

Access - intermediate (In-House)

By The In House Training Company

Access - introduction (In-House)

By The In House Training Company

PowerPoint - intermediate (In-House)

By The In House Training Company

Search By Location