Excel in Office

Buy now from Udemy for only $10

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

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

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

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”.

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”.

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.

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”.

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.

Buy now from Udemy for only $10

Buy now from Udemy for only $10

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!

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 and modify a query,
• Create calculated fields and grouping within queries

• 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!

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.

Buy now from Udemy for only $10