<h1>boost your excel Skills 
 <b>Become essential at work</b></h1>		
			<a href="#courses" role="button">
						Discover Courses
					</a>
			<h2>Course Information</h2>		
		<p><strong>All Sessions for this subject can be booked individually</strong>, Any 5 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 Excel 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. </p>		
			<h2>Introductory Level</h2>		
			<h2>Excel Bootcamp</h2>		
													<h3>
								Your own spreadsheet from scratch							</h3>
								In this session you will create your own worksheet, including editing cells, using formatting tools, and create and use basic formulas. DURATION: 							
											<h3>
							Includes						</h3>
							Navigate the Excel User Interface /
Use Excel Commands /
Create and Save a Workbook /
Enter & Editing Data /
Cut, Copy & Move Data /
Formatting Techniques & Formula Basics						
			<h2>Excel Lists and Rosters</h2>		
													<h3>
								Manage Lists and Rosters in Excel							</h3>
								This Session working with Lists & Rosters in Excel, including, Freeze Panes, Sort and Filter Data. Working with Rows, Columns and Ranges as well as navigating through large lists.							
											<h3>
							Includes						</h3>
							Sorting & Filtering Data /
Navigation & Selection Techniques /
Freeze Panes / Split Window /
Working with Ranges, Rows & Columns /
Using Find + Replace +  GOTO Tools & 
Using Subtotals						
			<h2>Formula Essentials</h2>		
													<h3>
								Understanding and Using Excel Formulas							</h3>
								This Session will help the learner gain essential skills in formula construction. Including Using, Cell Refs, Operators, and Percentages. Also how assemble more complex calculations.							
											<h3>
							Includes						</h3>
							Understanding Formulas in Excel /
Using Cell References /
Using Operators / 
the BODMAS Principle / 
Using Formulas Across Sheets &
Using Absolute & Relative References
			<h2>function essentials</h2>		
													<h3>
								understanding and using excel functions							</h3>
								This Session will focus on basic functions, essential to everyday use in Excel. These functions are the most commonly used in every day work usage.							
											<h3>
							Includes						</h3>
							Purpose of Functions / Using AutoSum & Other Auto Functions. / Using SUM / AVERAGE / MAX / MIN & Other Basic Functions / Filling & Copying Totals. / Using Non-Contiguous Ranges. Using Names in Functions.						
			<h2>Working with worksheets</h2>		
													<h3>
								Managing & printing worksheets							</h3>
								This session covers, Inserting and Deleting Worksheets, Range Sheets. Grouping and Updating Worksheets. And Print & Page Setup requirements for printing worksheet data.							
											<h3>
							Includes						</h3>
							Insert & Delete Worksheets / Renaming Sheets / Group & Update Sheets / Export & Copy Sheets / Page Setup and Printing Worksheets / Using Workbook Views & Using Header & Footers						
			<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>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						
										<img width="1007" height="816" src="https://flexicoach.com.au/wp-content/uploads/2020/07/FlexiCoachDavid.png" alt="David FlexiCoach" loading="lazy" srcset="https://flexicoach.com.au/wp-content/uploads/2020/07/FlexiCoachDavid.png 1007w, https://flexicoach.com.au/wp-content/uploads/2020/07/FlexiCoachDavid-300x243.png 300w, https://flexicoach.com.au/wp-content/uploads/2020/07/FlexiCoachDavid-768x622.png 768w" sizes="(max-width: 1007px) 100vw, 1007px" />											
			<h3>Hey!</h3>		
			<h2>Hi I'm David</h2>		
		<p>With 20 years of training experience in helping others gain the skills in Software they need to succeed at work or for their business. <strong> it is my mission to provide learners and businesses</strong> <strong>a like with the skills</strong> they need to manage critical tasks and solve work related challenges.</p>		
			<a role="button">
						More About Me 
					</a>
			<h3>Why <b>FlexiCoach </b></h3>		
			<h2>Grow your knowledge and <b> stay ahead of the curve </b></h2>		
				<h4>
					100% free of charge
				</h4>
								<p>Lorem ipsum dolor sit amet conetur adipiing elit. aulla sit amet magna is fodal otes alora.</p>
				<h4>
					Trusted Knowledge
				</h4>
								<p>Lorem ipsum dolor sit amet conetur adipiing elit. aulla sit amet magna is fodal otes alora.</p>
				<h4>
					Anytime, Anywhere
				</h4>
								<p>Lorem ipsum dolor sit amet conetur adipiing elit. aulla sit amet magna is fodal otes alora.</p>
			<h3>Some <b>Feedbacks</b></h3>		
			<h2>What people <b> are saying </b></h2>		
						"Steve makes some of the best educational digital marketing content on the internet! His teaching style is approachable and thorough and I've learned a lot from him over the years.”					
								<cite>Tim HamptonRome</cite>			
						“Working with Steve has been a fantastic experience. He was committed to helping us accomplish our goals. We saw an immediate 10-15% increase in leads.”					
								<cite>Jake RomeroSao Paulo</cite>			
						“Steve is smart, charismatic and insightful! He has a lot of experience and shares his knowledge freely.”					
								<cite>Carla WadeNew York</cite>			
						“Steve provided valuable information that our attendees could apply to their own social media practices, to help them grow their businesses and increase effectiveness.”					
								<cite>Erin AysonSan Francisco</cite>