Excel Learning Point 365

07/03/2021

07/03/2021

07/03/2021

25/11/2020

$Learn how to work with the most popular microsoft Excel functions
$Build Basic Excel apps from scratch with different functions
$Be able to work with different Excel function types such as date and time, finance and many others

Free Enroll (One day left)

Learn more than 80+ Excel function/Excel formulas/Excel tips for Excel 2007 to Excel 2019 with Excel examples

25/11/2020

$Create plenty of small projects to learn the basics of VBA
$Understand VBA programming structure and concepts
$Learn the best way to write a VBA code on Excel
$Understand how to use the macro recorder
$Be able to autome different tasks with VBA on Excel
$Enhance your current Excel projects with VBA programming

Free Enroll (Ten hours left)

Learn automation of tasks with Excel Macros and Excel VBA With different Excel Projects

25/11/2020

$Accounting functions in Microsoft Excel
$Finance functions in Microsoft Excel

Free Enroll (One day left)

Excel tips & tricks for Accounting, Finance and Financial Analysis. Learn from the Bestselling Accounting Instructor

22/06/2020

Select any cell within the range.

Select Data > Filter.

Filter button

Select the column header arrow Filter arrow .

Select Text Filters or Number Filters, and then select a comparison, like Between.

Number Filters Between

Enter the filter criteria and select OK.

Custom AutoFilter dialog box

Filter data in a table

When you Create and format tables, filter controls are automatically added to the table headers.

An Excel table showing built-in filters

Select the column header arrow Filter drop-down arrow for the column you want to filter.

Uncheck (Select All) and select the boxes you want to show.

Filter Gallery

Click OK.

The column header arrow Filter drop-down arrow changes to a Applied filter icon Filter icon. Select this icon to change or clear the filter.

11/06/2020

05/06/2020

05/04/2020

31/03/2020