Excel in Office

Welcome to the Excel in Office podcast.

This podcast is an audio version of the video courses that I created for Microsoft Word, Excel, PowerPoint and Access. They aim to get you from beginner level to that needed for a certified Microsoft Master. Learn the skills that you need to get you to the Expert level and beyond.

The Microsoft Office Specialist (MOS) Master certification Demonstrate that you have the deepest level of skills needed to use Office programs proficiently by earning a Microsoft Office Specialist Master certification. It is an official Microsoft certificate that you can put onto your CV or resume, and to earn it, you need to take and pass 4 official Microsoft exams – generally, Word Expert, Excel Expert, PowerPoint, and one other program.

In my courses, I teach the content which is examined in those certifications. In other words, I show you what Microsoft wants you to learn. I should say, however, that my courses and this audio podcast is completely unofficial, and has no connection to the Microsoft corporation, or any of its subsidiaries.

Video courses

My video courses contain several hours of training each. The cost is only about US$10, and there is a 30-day money-back guarantee.

Buy now from Udemy for only $10

By the end of this course, you will have the skills needed for the official Microsoft Excel Specialist exam. How would that look on your resume?

Reviews:

The teacher explains very well and at a good pace. Has real in-depth knowledge. The exercises are precise and well put together for the course. And the language sheets are invaluable to those that use other language than English version. I highly recommend this course. It goes thru most of the basic knowledge needed for Excel. Once again The teacher is excellent” — Daniel Sandberg

This is super helpful to me. I’m learning things I didn’t know existed in Excel.” – Jimmy Thrower

I had to take an Excel proficiency test as a job interview requirement , and scored top 10% percentile (they called me immediately to schedule a face-to-face) , thanks to your great course for which I studied for two days straight to re-enforce my knowledge in Excel, and more importantly fill those gaps of knowledge on all its functionality capabilities . You really get the MOST out of Phillip’s courses.” – Rick Romero

——————–

Most people who use Excel are up to Level 3 in some aspects, and Level 2 in others. Why not go all the way to Level 5?

In this 11.5 hour course, learn how to:

Create and manage worksheets and workbooks

  • Create and navigate in Excel worksheets and workbooks,
  • Format worksheets and workbooks,
  • Customize options and views, and
  • Configure Excel worksheets and workbooks for distribution.

Manage data cells and ranges

  • Insert data into and format cells and ranges, and
  • Summarise and organize data in Excel .

Create tables

  • Create and manage tables,
  • Manage table styles and options, and
  • Filter and sort a table.

Perform operations with Excel formulas and functions

  • Summarize data,
  • Perform conditional operations, and
  • Format and modify text.
  • Excel Formulas such as COUNTIF, SUMIF, MIN etc. are translated into 15 different languages.

Create charts and objects

  • Create charts,
  • Format graphic elements, and
  • Insert and format objects in Excel .

This course teaches all the skills that Microsoft want you to know. Specifically, they are the skills required to undertake the Microsoft Certificate 77-602 (for Excel 2007), 77-882 (for Excel 2010), 77-420 (for Excel 2013) and 77-727 (for Excel 2016 Core) and will be useful if you wish to take the exam, or which to learn more about Microsoft Excel

The core skills which are taught are those tested by Microsoft in the exam. There are topics that it wants you to learn about Microsoft Excel, and this course teaches you all of them.

Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.

The course will take about 11 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.

You should take this course if:

  • you want to learn more about Microsoft Excel, or
  • you want to learn the skills you need to become a certified Microsoft Office Specialist.

Regardless whether you have Excel 2007, Excel 2010, Excel 2013, Excel 2016 or Excel 365, this course will help you get to a good level, and maybe even want you to get more!

As a bonus, there are also additional videos on:

  • Pivot Tables and Pivot Charts,
  • Sparklines,
  • VLOOKUP, OFFSET and INDIRECT functions.

What are the requirements?

  • Before beginning, you will need to know how to use a Windows computer, including a mouse.
  • It would be good if you have used Microsoft Excel before, but this is not essential.
  • You should have MS Excel (or Office) 2007, 2010, 2013, 2016 or 365 installed on your computer.

What am I going to get from this course?

  • Create, configure and save Excel worksheets and workbooks.
  • Navigate through and format worksheets and workbooks.
  • Customise options and views for worksheets and workbooks.
  • Configure Excel worksheets and workbooks to print (e.g. page setup).
  • Insert data into and format cells and ranges, and create and modify tables.
  • Highlight, filter, sort and group cells, ranges and tables.
  • Create and format Excel charts.
  • Insert and format objects, including modifying images.
  • Create formulas in Excel, including using conditional logic and modifying text.

What is the target audience?

  • This course is for you if you want to develop your Microsoft Excel skills.
  • This course will use the latest version of Excel, but is ideal for you if you use any modern version – Excel 2007, 2010, 2013, 2016 or 365.
  • This course is also for you if you use an older version of Microsoft Excel, but want to learn the newer versions.
  • This course is for you if you want to become certified in Microsoft Excel, as by the end you should the knowledge to because certified as a Microsoft specialist, if you wish to do so.
  • You will cover the content tested in Microsoft Office Specialist Exams 77-602 (for Excel 2007), 77-882 (for Excel 2010), 77-420 (for Excel 2013) and 77-727 (for Excel 2016 Core)
  • This course may not be for you if you want to learn Microsoft Excel for Macintosh computers.

Buy now from Udemy for only $10

Buy now from Udemy for only $10

By the end of this course, you will have the skills needed for the official Microsoft Excel Specialist exam. How would that look on your resume?

Reviews:

The teacher explains very well and at a good pace. Has real in-depth knowledge. The exercises are precise and well put together for the course. And the language sheets are invaluable to those that use other language than English version. I highly recommend this course. It goes thru most of the basic knowledge needed for Excel. Once again The teacher is excellent” — Daniel Sandberg

This is super helpful to me. I’m learning things I didn’t know existed in Excel.” – Jimmy Thrower

I had to take an Excel proficiency test as a job interview requirement , and scored top 10% percentile (they called me immediately to schedule a face-to-face) , thanks to your great course for which I studied for two days straight to re-enforce my knowledge in Excel, and more importantly fill those gaps of knowledge on all its functionality capabilities . You really get the MOST out of Phillip’s courses.” – Rick Romero

——————–

Most people who use Excel are up to Level 3 in some aspects, and Level 2 in others. Why not go all the way to Level 5?

In this 11.5 hour course, learn how to:

Create and manage worksheets and workbooks

  • Create and navigate in Excel worksheets and workbooks,
  • Format worksheets and workbooks,
  • Customize options and views, and
  • Configure Excel worksheets and workbooks for distribution.

Manage data cells and ranges

  • Insert data into and format cells and ranges, and
  • Summarise and organize data in Excel .

Create tables

  • Create and manage tables,
  • Manage table styles and options, and
  • Filter and sort a table.

Perform operations with Excel formulas and functions

  • Summarize data,
  • Perform conditional operations, and
  • Format and modify text.
  • Excel Formulas such as COUNTIF, SUMIF, MIN etc. are translated into 15 different languages.

Create charts and objects

  • Create charts,
  • Format graphic elements, and
  • Insert and format objects in Excel .

This course teaches all the skills that Microsoft want you to know. Specifically, they are the skills required to undertake the Microsoft Certificate 77-727 (for Excel 2016 Core) and will be useful if you wish to take the exam, or which to learn more about Microsoft Excel

The core skills which are taught are those tested by Microsoft in the exam. There are topics that it wants you to learn about Microsoft Excel, and this course teaches you all of them.

Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.

The course will take about 11 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.

You should take this course if:

  • you want to learn more about Microsoft Excel, or
  • you want to learn the skills you need to become a certified Microsoft Office Specialist.

Regardless whether you have Excel 2011, Excel 2016 or Excel 365, this course will help you get to a good level, and maybe even want you to get more!

What are the requirements?

  • Before beginning, you will need to know how to use a Mac computer, including a mouse.
  • It would be good if you have used Microsoft Excel before, but this is not essential.
  • You should have MS Excel (or Office) 2016 or 365 installed on your computer. This course will also be good for you if you have Office 2011 installed instead.

What am I going to get from this course?

  • Create, configure and save Excel worksheets and workbooks.
  • Navigate through and format worksheets and workbooks.
  • Customise options and views for worksheets and workbooks.
  • Configure Excel worksheets and workbooks to print (e.g. page setup).
  • Insert data into and format cells and ranges, and create and modify tables.
  • Highlight, filter, sort and group cells, ranges and tables.
  • Create and format Excel charts.
  • Insert and format objects, including modifying images.
  • Create formulas in Excel, including using conditional logic and modifying text.

What is the target audience?

  • This course is for you if you want to develop your Microsoft Excel skills.
  • This course will use the latest version of Excel, but is ideal for you if you use Excel 2011, 2016 or 365.
  • This course is also for you if you use an older version of Microsoft Excel, but want to learn the newer versions.
  • This course is for you if you want to become certified in Microsoft Excel, as by the end you should the knowledge to because certified as a Microsoft specialist, if you wish to do so.
  • You will cover the content tested in Microsoft Office Specialist Exam 77-727 (among others).
  • This course may not be for you if you want to learn Microsoft Excel for PC computers. Please see my other courses for this.

Buy now from Udemy for only $10

Buy now from Udemy for only $10

Building on the skills learnt in “Excel in Microsoft Excel 1″, here’s levels 6-10. By the end of this course, you will have the skills needed for the official Microsoft Excel Expert exam. How would that look on your resume?

Reviews

Well thought out and explained in a way which makes it easy to learn & understand.” – Arnold Schwartz

This course is very well structured and the teachers knowledge is very good. His teaching style is capturing and he is very structured. The small tests after each section is great, and even greater is that he takes time to show his thoughts on how is should have been done, not just leaving one to wonder if it was right or not. The resources used in this course is also very suitable. Highly recommend this one” – Daniel Sandberg

————

Most people who use Excel are up to Level 3 in some aspects, and Level 2 in others. Why not go all the way to Level 10?

In this course, learn how to:

Manage workbook options and settings

  • Manage Excel workbooks,
  • Manage workbook review,
  • Apply workbook settings, properties and data options, and
  • Apply logical and statistical functions

Create advanced charts and Excel tables

  • Create and manage PivotTables,
  • Advanced formatting,
  • Create and manage PivotCharts,
  • Create advanced charts,
  • Apply advanced date and time functions

Preparing for advanced formulas

  • Troubleshoot Excel formulas,
  • Manage and reference defined names,
  • Prepare a workbook for internationalisation and accessibility,
  • Array fornulas.

Automation and advanced formulas

  • Perform data analysis and business intelligence in Excel.
  • Visual Basic for Applications (VBA) macros and form controls.
  • Create and modify custom workbook elements
  • Look up data by using functions (VLOOKUP, HLOOKUP, MATCH, INDEX, TRANSPOSE and INDIRECT). translated into 15 different languages.

This course teaches all the skills that Microsoft want you to know for the Expert exams. Specifically, they are the skills required to undertake the Microsoft Certificate 77-851 (for Excel 2007 Expert), 77-888 (for Excel 2010 Expert), 77-427 and 77-428 (for Excel 2013 Expert) and 77-728 (for Excel 2016 Expert) and will be useful if you wish to take the exam, or which to learn more about Microsoft Excel

The core skills which are taught are those tested by Microsoft in the exam. There are topics that it wants you to learn about Microsoft Excel, and this course teaches you all of them.

Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.

The course will take about 8 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.

You should take this course if:

  • you want to learn more about Microsoft Excel, or
  • you want to learn the Excel skills you need to become a certified Microsoft Office Specialist Expert.

Regardless whether you have Excel 2007, Excel 2010, Excel 2013, Excel 2016 or Excel 365, this course will help you get to an advanced level, and maybe even want you to get more!

What are the requirements?

  • Before beginning, you need to use Microsoft Excel to an intermediate standard.
  • This includes Conditional Formatting, Tables, filtering, sorting and creating charts
  • If you have taken the course “Excel in Microsoft Excel – Beginner to Specialist certificate”, or taken a Microsoft Office Specialist exam in Excel, then you will have the relevant prerequisites.

What am I going to get from this course?

  • Manage workbooks and workbook review
  • Create and manage PivotTables
  • Present data visually, using PivotCharts and advanced charts
  • Perform data analysis and business intelligence
  • Troubleshoot formulas
  • Manage and reference defined names and custom workbook elements
  • And learn lots of formulas, including VLOOKUP, MATCH, INDEX, TRANSPOSE and INDIRECT

What is the target audience?

  • This is for you if you want to develop your Excel skills to an Expert level.
  • This is also for you if you want to take the Microsoft Office Specialist Expert Exams.
  • This may not be for you if you are not already at least at an Intermediate level (already done levels 1-5 or equivalent).

Buy now from Udemy for only $10

Buy now from Udemy for only $10

Building on the skills learnt in “Microsoft Excel for Mac 1″, here’s levels 6-9. By the end of this course, you will have the skills needed for the official Microsoft Excel Expert exam. How would that look on your resume?

Reviews

Well thought out and explained in a way which makes it easy to learn & understand.” – Arnold Schwartz

This course is very well structured and the teachers knowledge is very good. His teaching style is capturing and he is very structured. The small tests after each section is great, and even greater is that he takes time to show his thoughts on how is should have been done, not just leaving one to wonder if it was right or not. The resources used in this course is also very suitable. Highly recommend this one” – Daniel Sandberg

————

Most people who use Excel are up to Level 3 in some aspects, and Level 2 in others. Why not go all the way to Level 9?

In this course, learn how to:

Manage workbook options and settings

  • Manage Excel workbooks,
  • Manage workbook review,
  • Apply workbook settings, properties and data options, and
  • Apply logical and statistical functions

Create advanced charts and Excel tables

  • Create and manage PivotTables,
  • Advanced formatting,
  • Create and manage PivotCharts,
  • Create advanced charts,
  • Apply advanced date and time functions

Preparing for advanced formulas

  • Troubleshoot Excel formulas,
  • Manage and reference defined names,
  • Prepare a workbook for internationalisation and accessibility,
  • Array fornulas.

Automation and advanced formulas

  • Create and modify custom workbook elements
  • Look up data by using functions (VLOOKUP, HLOOKUP, MATCH, INDEX, TRANSPOSE and INDIRECT). translated into 15 different languages.

This course teaches all the skills that Microsoft want you to know for the Expert exams 77-728 (for Excel 2016 Expert), including those aspects which are PC only (sadly), and will be useful if you wish to take the exam, or which to learn more about Microsoft Excel

The core skills which are taught are those tested by Microsoft in the exam. There are topics that it wants you to learn about Microsoft Excel, and this course teaches you all of them.

Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.

The course will take about 8 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.

You should take this course if:

  • you want to learn more about Microsoft Excel, or
  • you want to learn the Excel skills you need to become a certified Microsoft Office Specialist Expert.

Regardless whether you have Excel 2016 or Excel 365 (or even Excel 2011), this course will help you get to an advanced level, and maybe even want you to get more!

What are the requirements?

  • Before beginning, you need to use Microsoft Excel to an intermediate standard.
  • This includes Conditional Formatting, Tables, filtering, sorting and creating charts
  • If you have taken the course “Excel in Microsoft Excel – Beginner to Specialist certificate”, or taken a Microsoft Office Specialist exam in Excel, then you will have the relevant prerequisites.

What am I going to get from this course?

  • Manage workbooks and workbook review
  • Create and manage PivotTables

What is the target audience?

  • This is for you if you want to develop your Excel skills to an Expert level.
  • This is also for you if you want to take the Microsoft Office Specialist Expert Exams.
  • This may not be for you if you are not already at least at an Intermediate level (already done levels 1-5 or equivalent).

Buy now from Udemy for only $10

Buy now from Udemy for only $10

Review:

The knowledge of the teacher is impressive, and he knows how to teach. The speed of the course is just right. And going thru the exercises after each one is great. I only have one word for the teacher and the way he’s presenting the course WOW!!!” — Daniel Sandberg

This course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES.

It sounds difficult, but in fact can be done in just a few clicks. We’ll do our first one in a couple of minutes – that’s all it takes. We’ll also add a chart as well in that time.

After only these first few minutes, you will be streets ahead of anyone who doesn’t know anything about Pivot Tables – it is really that important.

After this introduction, we’ll go into some detail into how to set up your Pivot Table – the initial data, and the various options that are available to you. We will go into advanced options that most people don’t even know about, but which are very useful.

By the end, you will be an Expert user of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly, and you’ll be able to help others with their data analysis.

It will assist with the Visualize Data section of the Microsoft exam 70-779 “Analysing and Visualizing Data with Microsoft Excel”.

Who is the target audience?
  • This is for you if you have ever heard of the “Pivot Table”, but didn’t know what it is or how to use it.
  • This is also for you if you use PivotTables, and want to go deeper. Much deeper. :-)
  • We’ll also go into the more advanced functions, and create charts as well, quickly and easily.

Buy now from Udemy for only $10

Buy now from Udemy for only $10

This course covers one of the most useful, but scariest-sounding, functions in Microsoft Excel; PIVOT TABLES.

It sounds difficult, but in fact can be done in just a few clicks. We’ll do our first one in a couple of minutes – that’s all it takes. We’ll also add a chart as well in that time.

After only these first few minutes, you will be streets ahead of anyone who doesn’t know anything about Pivot Tables – it is really that important.

After this introduction, we’ll go into some detail into how to set up your Pivot Table – the initial data, and the various options that are available to you. We will go into advanced options that most people don’t even know about, but which are very useful.

By the end, you will be an Expert user of Pivot Tables, able to create reliable analyses which are able to be drilled-down quickly, and you’ll be able to help others with their data analysis.

It will assist with the Visualize Data section of the Microsoft exam 70-779 “Analysing and Visualizing Data with Microsoft Excel”.

Who is the target audience?
  • This is for you if you have ever heard of the “Pivot Table”, but didn’t know what it is or how to use it.
  • This is also for you if you use PivotTables, and want to go deeper. Much deeper. :-)
  • We’ll also go into the more advanced functions, and create charts as well, quickly and easily.

Buy now from Udemy for only $10

Buy now from Udemy for only $10

Reviews:

This is a very good starting point in VBA. But doing this course one realize how extensive and huge VBA is. As always the teacher is great and one feels his in depth knowledge” — Daniel Sandberg

Welcome to Excel VBA – An Introduction. This course delves into the Visual Basic which allows you to automate Microsoft Excel (and other MS Office products).

Microsoft Excel is an extremely powerful tool – and yet most people only scratch the surface of what it can do. In addition to PivotTables, VLookup formulas and the like, you can also automate it. You can add buttons and forms to add interactive features – yet most people don’t even know it’s there. Maybe you have someone in your organization who is an absolute wizard, getting the computer to do things and walking away while it does it. Do you want to be able to do that? Welcome to wizard school – or in other words, Visual Basic for Applications (VBA).

In this course, I’ll assume that you have some fair knowledge of Excel – able to do basic formulas and colour cells and the like – but you don’t need any prior knowledge of VBA or any programming language for that matter. Of course, the more you already have, the better. I’ll take things nice and slowly. Each video will center around one new aspect, or we’ll consolidate what you already know with coding exercises.

Once you have finished the course, then you will be well on your way to developing your own macros to solve your own problems. And you’ll be able to take your new-found knowledge for use in Word and PowerPoint as well.

Who is the target audience?
  • This Excel VBA course is for you if you want to learn how to automate Excel and provide a better user interaction.
  • No prior programming language is required – although, it would always help!
  • This course is not for you if you are confident using VBA, and are looking for more advanced techniques.

Buy now from Udemy for only $10

Buy now from Udemy for only $10

Reviews:

In just the first few lessons, I have already been able to apply what I have learned at my job. Thank you for this course!” — Cynthia Smith

The Instructor is easy to understand and he gives exercises to test your understanding which is what I prefer rather than just listening to lectures. I will definitely take more of Mr Burton’s classes as I like his teaching style.” — Tamuka Mazana

——————

This course covers one of the most useful add-ins in Microsoft Excel, PowerPivot, and the Tabular model in SQL Server Analytical Services.

We’ll activate PowerPivot if you have the right version of Excel, and if not, then we’ll install SQL Server on your computer, which can do the same job. We’ll install the Developer edition, which used to cost $100, for free.

After PowerPivot is activated, or SQL Server is installed, we’ll create our first analysis in Excel in just a matter of minutes.

After only these first few minutes, you will be streets ahead of anyone who doesn’t know anything about Power Pivot.

After this introduction, we’ll go into some detail into PowerPivot or SSAS – the initial data, and the various options that are available to you. We will go into advanced options that most people don’t even know about, but which are very useful.

Then we’ll develop DAX formulas, to further extend the model. A lot of the formulas are based on Excel formulas, but there are several additional things too.

By the end, you will be an Expert user of both PowerPivot and SSAS, able to create reliable analyses which are able to be drilled-down quickly, and you’ll be able to help others with their data analysis.

It will assist with the Model Data section of Microsoft exam 70-779 “Analysing and Visualizing Data with Microsoft Excel”.

It will also assist with the “Design a tabular BI semantic model” and “Develop queries using Data Analysis Expressions (DAX)” section of Microsoft exam 70-768 “Developing SQL Data Models”.

Who is the target audience?
  • This course is for people who want to create analyses.
  • You either want to do this in Excel, or you want to learn about SQL Server Analytical Services (Tabular edition).
  • This course isn’t for you if you want to learn SSAS (MDX version) – there are other courses for this.

Buy now from Udemy for only $10

Buy now from Udemy for only $10

Very complete looking forward to sitting exam – Donald Eric Warner

Great instruction. This guy knows all the tricks! Learning things I have never used before. – Caesaree Tompkins Harper

Really thorough. Definitely making sure that all components are covered for the exam. – David Smith Jr.

————

In this 9 hour course, learn how to create, navigate through and format documents, customise your options and views (including recording macros), configuring documents to print/save, and inserting and formatting text and paragraphs. For more details, see the full curriculum.

This course teaches all the skills that Microsoft want you to know. Specifically, they are the skills required to undertake the Microsoft Certificate 77-418 for Microsoft Word 2013 and 77-725 for Microsoft Word 2016 and will be useful if you wish to take the exam, or which to learn more about Microsoft Word.

The core skills which are taught are those tested by Microsoft in the exam. There are 16 topics that Microsoft that it wants you to learn, and this course teaches you all of them.

Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.

The course will take about 9 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.

You should take this course if:

  • you want to learn more about Microsoft Word, or
  • you want to become a certified Microsoft Office Specialist.
Who is the target audience?
  • This course is for you if you want to develop your Microsoft Word skills.
  • This course will use the latest version of Word, but is ideal for you if you use any modern version – Word 2007, 2010, 2013, 2016 or 365.
  • This course is also for you if you use an older version of Microsoft Word, but want to learn the newer versions.
  • This course is for you if you want to become certified in Microsoft Word, as we will be using the skills requirements of the Official Microsoft Exam 77-418.
  • This course will also help towards the Word 2010 exam (77-881) or Word 2007 exam (77-601).
  • This course is not for you if you want to learn Microsoft Word for Macintosh computers.

Buy now from Udemy for only $10

Buy now from Udemy for only $10

Most people who use Word are up to Level 3 in some aspects, and Level 2 in others. Why not go all the way to Level 9?

In this course, learn how to:

Level 5 – Manage document options and settings

  • Manage documents and templates,
  • Prepare documents for review, and
  • Manage document changes

Level 6 – Design advanced documents

  • Perform advanced editing and formatting,
  • Create tables and charts,
  • Apply advanced ordering and grouping, and
  • Create styles

Level 7 – Create advanced references

  • Create and manage indexes and references,
  • Manage custom fields and Mail Merge

Level 8 – Create custom Word elements

  • Create and modify building blocks, macros and controls,
  • Create custom style sets and templates, and
  • Prepare a document for internationalisation and accessibility

Level 9 – Manage macros and forms

  • Apply and manipulate macro options, and
  • Create and manipulate forms.

This course teaches all the skills that Microsoft want you to know for the Expert exams. Specifically, they are the skills required to undertake the Microsoft Certificate 77-850 (for Word 2007 Expert), 77-887 (for Word 2010 Expert), 77-425 and 77-426 (for Word 2013 Expert) and 77-726 (for Word 2016 Expert) and will be useful if you wish to take the exam, or which to learn more about Microsoft Word

The core skills which are taught are those tested by Microsoft in the exam. There are topics that it wants you to learn about Microsoft Word, and this course teaches you all of them.

Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.

The course will take about 8 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.

You should take this course if:

  • you want to learn more about Microsoft Word, or
  • you want to learn the Word skills you need to become a certified Microsoft Office Specialist Expert.

Regardless whether you have Word 2007, Word 2010, Word 2013, Word 2016 or Word 365, this course will help you get to an advanced level, and maybe even want you to get more!

What are the requirements?

  • Before beginning, you need to use Microsoft Word to an intermediate standard
  • This includes formatting text, page breaks, creating tables, endnotes, citations and images
  • If you have taken the course “Microsoft Excel – Beginner to Specialist certificate”, or taken a Microsoft Office Specialist exam in Word, then you will have the relevant prerequisites.

What am I going to get from this course?

  • We’ll look at managing multiple documents and templates, including being restrict editing of your documents and track the changes that other do make.
  • We’ll see how to make it easier for your international and disabled colleagues to use.
  • We’ll perform advanced editing and formatting, create tables and charts, and use the outline view and master documents and sub-documents.
  • We’ll create and manage indices and references, add and manage Quick Parts, including custom fields, and create Mail Merges.
  • We’ll look at Visual Basic for Applications, and we’ll create forms for others to fill in.

What is the target audience?

  • This is for you if you want to develop your Word skills.
  • This is also for you if you want to take the Microsoft Office Specialist Expert Exams.

Buy now from Udemy for only $10

Buy now from Udemy for only $10

All the training you need to take (and hopefully) pass your Microsoft Office Specialist exam – and one step towards the Master certification.

Most people who use PowerPoint are up to Level 4 in some aspects, and Level 3 in others. Why not go all the way to Level 6?

In this course, learn how to:

Create and manage presentations, including:

  • Create a new presentation,
  • Insert and format slides,
  • Modify slides, handouts and notes,
  • Order and group slides,
  • Change presentation options and views,
  • Configure a presentation for print
  • Configure and present a slide show

Insert and format text, shapes and images

Insert tables, charts, SmartArt and media

Apply transition and animations

Manage multiple presentations

This course teaches all the skills that Microsoft want you to know. Specifically, they are the skills required to undertake the Microsoft Certificate 77-603 (for PowerPoint 2007), 77-883 (for PowerPoint 2010), 77-422 (for PowerPoint 2013) and 77-729 (for PowerPoint 2016 Core) and will be useful if you wish to take the exam, or which to learn more about Microsoft PowerPoint

The core skills which are taught are those tested by Microsoft in the exam. There are topics that it wants you to learn about Microsoft PowerPoint, and this course teaches you all of them.

Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.

The course will take about 6 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.

You should take this course if:

  • you want to learn more about Microsoft PowerPoint, or
  • you want to learn the skills you need to become a certified Microsoft Office Specialist.

Regardless whether you have PowerPoint 2007, PowerPoint2010, PowerPoint2013, PowerPoint 2016 or Office 365, this course will help you get to a good level, and maybe even want you to get more!

Who is the target audience?
  • This course is for you if you want to develop your Microsoft PowerPoint skills.
  • This course will use the latest version of PowerPoint, but is ideal for you if you use any modern version – PowerPoint 2007, 2010, 2013, 2016 or 365.
  • This course is also for you if you use an older version of Microsoft PowerPoint, but want to learn the newer versions.
  • This course is for you if you want to become certified in Microsoft PowerPoint, as by the end you should the knowledge to because certified as a Microsoft specialist, if you wish to do so.
  • You will cover the content tested in Microsoft Office Specialist Exams 77-603 (for PowerPoint 2007), 77-883 (for PowerPoint 2010), 77-422 (for PowerPoint 2013) and 77-729 (for PowerPoint 2016 Core)
  • This course may not be for you if you want to learn Microsoft PowerPoint for Macintosh computers.

Buy now from Udemy for only $10

Buy now from Udemy for only $10

All the training you need to take (and hopefully) pass your Microsoft Office Specialist exam – and one step towards the Master certification.

Most people who use PowerPoint are working at Level 1. Why not go all the way to Level 5?

In this course, learn how to:

Create and manage a database, including:

  • Create and modify databases
  • Manage relationships and keys
  • Navigate through a database
  • Protect and maintain databases
  • Print and export data

Build tables, including:

  • Create and manage tables,
  • Manage records in tables, and
  • Create and modify fields.
Create queries, including:
  • Create and modify a query,
  • Create calculated fields and grouping within queries
Create forms and reports, including:
  • Create forms and reports,
  • Configure form and report controls, and
  • Format forms and reports.

This course teaches all the skills that Microsoft want you to know. Specifically, they are the skills required to undertake the Microsoft Certificate 77-605 (for Access 2007), 77-885 (for Access 2010), 77-424 (for Access 2013) and 77-730 (for Access 2016 Core) and will be useful if you wish to take the exam, or which to learn more about Microsoft Access

The core skills which are taught are those tested by Microsoft in the exam. There are topics that it wants you to learn about Microsoft Access, and this course teaches you all of them.

Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.

The course will take about 8 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.

You should take this course if:

  • you want to learn more about Microsoft Access , or
  • you want to learn the skills you need to become a certified Microsoft Office Specialist.

Regardless whether you have Access 2007, Access 2010, Access 2013, Access 2016 or Office 365, this course will help you get to a good level, and maybe even want you to get more!

Who is the target audience?
  • This course is for you if you want to develop your Microsoft Access skills.
  • This course will use the latest version of Access, but is ideal for you if you use any modern version – Access 2007, 2010, 2013, 2016 or 365.
  • This course is also for you if you use an older version of Microsoft Access, but want to learn the newer versions.
  • This course is for you if you want to become certified in Microsoft Access, as by the end you should the knowledge to because certified as a Microsoft specialist, if you wish to do so.
  • You will cover the content tested in Microsoft Office Specialist Exams 77-605 (for Access 2007), 77-885 (for Access 2010), 77-424 (for Access 2013) and 77-730 (for Access 2016 Core)
  • This course may not be for you if you want to learn Microsoft Access for Macintosh computers, or if you already have advanced knowledge of Access.

Buy now from Udemy for only $10

Buy now from Udemy for only $10

Do you want to learn how to write more advanced queries in Access. And do you want your queries to be portable into SQL Server and Access?

In this course learn how to:

  • Write SQL code, using the six SELECT clauses.
  • Use functions and formulas in your SELECT statements.
  • Create joins between tables, including more complex joins which cannot be evaluated using the graphical interface.
  • Write action queries and cross-queries.
Who is the target audience?
  • This course is for you if you want to develop your Microsoft Access skills by learning how to code SQL queries.
  • This course is for you if you want to create more advanced queries in Access.
  • This course will use the latest version of Access, but is ideal for you if you use any modern version – Access 2007, 2010, 2013, 2016 or 365.
  • This course is also for you if you use an older version of Microsoft Access, but want to learn the newer versions.

Buy now from Udemy for only $10

One comment

Leave a Reply

Your email address will not be published. Required fields are marked *