<h1>boost your software Skills 
 <b>microsoft project</b></h1>		
			<a href="#courses" role="button">
				<svg xmlns="http://www.w3.org/2000/svg" id="bb64cb4a-5cee-426f-944d-5ba66396baf0" data-name="Layer 1" width="8" height="13" viewBox="0 0 8 13"><title>arrow-icon-down</title><path d="M7.894,8.8227a.386.386,0,0,0-.5415-.0012L4.3763,11.7386V.3735A.3678.3678,0,0,0,4.189.05.3837.3837,0,0,0,3.81.05a.3678.3678,0,0,0-.1873.3233V11.7386L.6469,8.8227a.3829.3829,0,0,0-.5332-.0092A.3613.3613,0,0,0,0,9.0766a.3825.3825,0,0,0,.1125.2679l3.62,3.5476a.3835.3835,0,0,0,.5332,0L7.8848,9.3453A.3631.3631,0,0,0,8,9.086L8,9.08A.3638.3638,0,0,0,7.894,8.8227Z"></path></svg>			
						Discover Courses
					</a>
			<h2>Course Information</h2>		
		<p><strong>All Sessions for this subject can be booked individually</strong>, Any 5 coaching sessions for each level make up an Equivalent One Day Training Course, Pricing for the whole course will be more cost effective than individual Sessions. Note: <strong>Sessions can be selected from various levels, to make up a course,</strong> with the proviso that students meet the basic requirements to complete more complex sessions. All Sessions will be booked over a period of time, and not run on the same day, unless mutually agreed upon. Each Sessions is Approximately 90 Min, this will includes a brief course intro / conclusion. Is is recommended with Project to have all session in succession to the learning outcomes related to MS Project.</p>		
										<img width="1024" height="256" src="https://flexicoach.com.au/wp-content/uploads/2020/05/Excel-1600x400-px-1024x256.jpeg" alt="Excel Coaching Courses" loading="lazy" srcset="https://flexicoach.com.au/wp-content/uploads/2020/05/Excel-1600x400-px-1024x256.jpeg 1024w, https://flexicoach.com.au/wp-content/uploads/2020/05/Excel-1600x400-px-300x75.jpeg 300w, https://flexicoach.com.au/wp-content/uploads/2020/05/Excel-1600x400-px-768x192.jpeg 768w, https://flexicoach.com.au/wp-content/uploads/2020/05/Excel-1600x400-px-1536x384.jpeg 1536w, https://flexicoach.com.au/wp-content/uploads/2020/05/Excel-1600x400-px.jpeg 1600w" sizes="(max-width: 1024px) 100vw, 1024px" />											
			<h2>Introductory Level</h2>		
			<h2>Project Overview</h2>		
													<h3>
								introduction Project principles and overview							</h3>
								In this session the learner will go through the fundamentals of project management, then an overview of the Microsoft Project Platform. 							
											<h3>
							Includes						</h3>
							Project Management Fundamentals / Overview of MS Project / Views and Tables / Navigating Project / Ribbon and Toolbars / Project Options / Gantt Chart Overview						
			<h2>Getting started</h2>		
													<h3>
								Setting up a project							</h3>
								In this session the learner will understand the need of proper setup prior to tasks being added to the project plan. This will also  include Project Information, Start Date and Setting up of the Project Base Calendar							
											<h3>
							Includes						</h3>
							Project Properties / Creating Project Summary Task / Project Base Calendar Setup / Working & Non Working Days / Project Options / Assigning the Calendar to the Project / Working with the Timescale / Viewing the Project Summary Task						
			<h2>Working With Tasks</h2>		
													<h3>
								Entering and Editing Tasks							</h3>
								In this session the learner will understand the types of tasks that can be used in Project from Standard Tasks, to Milestones and Recurring Tasks. We deep dive task durations as well as task start and finish. The session concludes with a look at high and low level task assignments.							
											<h3>
							Includes						</h3>
							Entry Table Overview / Adding & Editing Tasks / Adding Task Durations / Task View Options / Inserting Milestones / Using Recurring Tasks / Using Task Outlining to Create High and Low level Tasks. Linking Up Tasks. Introduction to Predecessors and Successors.
			<h2>Task Relationships</h2>		
													<h3>
								Improving Task Efficiency							</h3>
								This session focuses on linking tasks, change task relationships to improve project efficiency. This session also focuses on working with Various Task Constraints. Keeping the Project Flexible, When to Use Fixed Constraints.							
											<h3>
							Includes						</h3>
							Linking Tasks in Various Ways/ Task Information Dialog Box / Changing Task Dependencies/ Using Lag and Lead Times / Understanding ASAP and ALAP Constraints / Using Fixed Constraints / Setting a Deadline / Critical Path and Project Slack						
			<h2>Adding and assigning resources</h2>		
													<h3>
								getting the work done							</h3>
								This session covers using the Resources Sheet, Adding Work and Material Based Resources / Adding Standard, Overtime & Cost Per Use , Rates and also Understanding and Using Resources Calendars. Then Assigning Resources to your project and viewing project costs							
											<h3>
							Includes						</h3>
							Resource Sheet / Adding Material Resources / Adding Work Resources / When to Use Cost Resources / Adding Rates for Each Resource / Grouping Resources / Creating and Using Resource Calendars / Assigning Resources / When to Use Effort Driven Scheduling / Viewing Project and Task Level Costs						
			<h2>Appendix A</h2>		
													<h3>
								Additional Learning subjects							</h3>
								Depending on the pace of the student for each session or course, the Appendix Session will cover additional subjects for the student.							
											<h3>
							Includes						</h3>
							Introduction to Charts / Graphics Objects & Images / Using SmartArt Graphics / Additional Basic Functions / Q&A						
			<h2>Intermediate Level</h2>		
			<h2>Data Management Tools</h2>		
													<h3>
								Advanced tools for Controlling and Highlighting Data							</h3>
								This Sessions will focus on the use of Conditional Formats, Advanced Filters, Use of Excel Tables to manage lists in Excel. Also included are Data Validation & Data Protection.							
											<h3>
							Includes						</h3>
							Conditional Formatting / Sparklines / Excel Tables / Filter & Advanced Filtering Techniques / Importing & Exporting Data / Grouping & Outlining Data / Protect Sheets & Workbooks.						
			<h2>Intro to complex functions</h2>		
													<h3>
								If you need to look it up 							</h3>
								This session will introduce the learner to complex functions. The session focuses on Logical and Lookup functions, and includes nesting functions to achieve a desired outcome. Perfect introduction to complex functions in Excel. 							
											<h3>
							Includes						</h3>
							Lookup Functions & Logical Functions / Functions with Absolute & Mixed Refs / Use of Name Ranges in functions / Combining Functions through Nesting.						
			<h2>ALL ABOUT Charts</h2>		
													<h3>
								How to Build a Chart that works							</h3>
								This session will help the learner to create and adjust charts in Excel using various data options. We will deep dive chart techniques, and look at additional items such as trendlines etc..							
											<h3>
							Includes						</h3>
							Create a Chart/ Different Chart Types / Adjusting Chart Data / Chart Formatting & Layout / Advanced Chart Features / Trendlines and Error Bars. Displaying Complex Data in a Chart. 						
			<h2>summarise &amp; Link data</h2>		
													<h3>
								Calculations across sheets and books							</h3>
								In this session the learner will learn the use of the Data Consolidation tool, and how to edit links in a consolidated workbook. We also discuss the alternative in linking directly through sheets and workbooks.							
											<h3>
							Includes						</h3>
							Data Consolidation Techniques, Linking Cells as an Alternative. Calculations Across Worksheets, Calculations Across Workbooks, Editing Links. Introduction to Pivot Tables and Pivot Charts & Using Scenarios in Excel.						
			<h2>Data techniques</h2>		
													<h3>
								Date and Text Tools to save you time							</h3>
								In this session we learn useful techniques and functions that save heaps of time. This session includes keyboard shortcuts you should know, and also useful custom formats to display data the way you need it to.							
											<h3>
							Includes						</h3>
							Splitting up Text into Columns, Combining Text into one cell. Auto updating the date and time, adding static dates and times quickly into Excel. Updating Multiple Worksheets Simultaneously Using Paste Special, GOTO and Remove Duplicates to save time on tedious tasks.						
			<h2>Appendix A</h2>		
													<h3>
								Additional Learning Subjects							</h3>
								Depending on the pace of the student for each session or course, the Appendix Session will cover additional subjects for the student.							
											<h3>
							Includes						</h3>
							VLOOKUP, HLOOKUP or XLOOKUP(365) Examples IF, AND, OR Examples
/ Using IFERROR & IFNA / Student Q&A						
			<h2>Advanced Level</h2>		
			<h2>Function workshop</h2>		
													<h3>
								problem solving functions							</h3>
								In this session we focus on additional functions for Text Manipulation including LEFT, RIGHT, MID, & SEARCH. Also Math functions such as SUMIF/SUMIFs, COUNTIF etc.. As well as the Lookup alternatives of INDEX & MATCH functions.							
											<h3>
							Includes						</h3>
							Text Functions : LEFT, RIGHT, MID,FIND,SEARCH, SUBSTITUTE & CONCATENATE /
Aggregation Functions : SUMIF, SUMIFs & COUNTIF /
Lookup Functions : INDEX & MATCH Functions						
			<h2>pivot Tables &amp; Pivot Charts</h2>		
													<h3>
								Harness the power of Pivot Tables to analyse data							</h3>
								This session focusing specifically on Pivot Tables as a tool. We deep dive how Pivot Tables work, how to append and Update Data, and how to adjust Pivot Table settings to gain required summary data from a raw data source.							
											<h3>
							Includes						</h3>
							Create a Pivot Table Report / Customizing the Pivot Table / Pivot Table Options / Grouping / Aggregation & Percentages / Using Formulas / Updating the Source Data / Pivot Table Themes and Formats/ Print a Pivot Table / Using Slicers / Pivot Charts						
			<h2>Tables and Subtotals</h2>		
													<h3>
								Analyze Data using tables and subtotals							</h3>
								In this Session we will deep dive the use of tables in Excel as well as the features involving filters and totaling. This session will also go into depth with Subtotaling, Grouping and Outlining in Excel.							
											<h3>
							Includes						</h3>
							Tables vs Ranges / Table Styles / Filtering with Tables / Aggregation tools / Exporting Options / Summarize with Pivot Table / Removing Duplicates / Using Slicers / Using Subtotaling in Tables & Ranges 						
			<h2>Get & Transform Data</h2>		
													<h3>
								Manipulate Data Using Power query							</h3>
								In this session the learner will use enhanced data manipulation and filter tools using Power Query. This Query Tool is also used with Power BI and will serve as a foundation for those attending that course.							
											<h3>
							Includes						</h3>
							Import into Power Query / Working with Rows, Columns & Data / Using the Transform tool / Adding Custom Columns / Extracting Data / Using Date and Time Options / Working with Query Settings.						
			<h2>Whats a macro?</h2>		
													<h3>
								Automate tasks in Excel Using Macros							</h3>
								In this session we will understand the purpose and use of Macros. The Macro Recorder, Relative and Absolute Reference / Running and Editing the Macro. This Sessions serves as an introduction to Visual Basic for Excel.							
											<h3>
							Includes						</h3>
							Accessing the Macro Recorder / Recording a Macro in Absolute Mode & Relative Mode / Editing and Running a Macro / Keyboard Shortcuts / Quick Access Toolbar / The Ribbon / Access the VBE. Saving as a macro enabled file. Whats Next.						
			<h2>Appendix A</h2>		
													<h3>
								Additional Learning Subjects							</h3>
								Depending on the pace of the student for each session or course, the Appendix Session will cover additional subjects for the student.							
											<h3>
							Includes						</h3>
							Advanced Data Validation / Workbook Sharing / INDIRECT Function / UPPER, LOWER & PROPER Functions.						
			<h3>Why <b>FlexiCoach </b></h3>		
			<h2>Grow your knowledge and <b> stay ahead of the curve </b></h2>		
				<h4>
					Personalized Coaching / training
				</h4>
								<p>Gain much needed skills, by a qualified instructor suitable to your needs.</p>
				<h4>
					Awesome Helpdesk
				</h4>
								<p>Pre &amp; Post Learning Support Essential, to grow your skills. We also offer standalone Helpdesk so you have an expert onhand.</p>
				<h4>
					replay anytime learning
				</h4>
								<p>Once you attend a session, you can revisit the subject as many times as you need.</p>
			<h5>Contact</h5>