Sign In Sign Up
×

Courses

Text Functions

Text Functions

4 Videos
Language - English, Arabic
01:40 Min
USD 3.99
Add to cart

Text Functions

Text Functions (28)

  1. BAHTTEXT
  2. CHAR, CLEAN, CODE, CONCAT
  3. DOLLAR
  4. EXACT
  5. FIND, FIXED
  6. LEFT, LEN, LOWER,
  7. MID
  8. NUMBERVALUE
  9. PROPER
  10. REPLACE, REPT, RIGHT

and more ...

Mastering Financial Formulas

Mastering Financial Formulas

0 Videos
Language - English, Arabic
00:00 Min
USD 9.99
Add to cart

Mastering Financial Formulas

Mastering Financial Formulas (55)

  1. ACCRINT, ACCRINTM, AMORDEGRC, AMORLINC
  2. COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPCD, CUMIPMT, CLUMRINC
  3. DB. DDB, DISC, DOLLARDE, DOLLARFR, DURATION
  4. EFFECT
  5. FV, FVSCHEDULE

and more ...

The 19 Rules Of Pivot Tables

The 19 Rules Of Pivot Tables

6 Videos
Language - English, Arabic
09:07 Min
USD 9.99
Add to cart

The 19 Rules Of Pivot Tables

The 19 Rules of Pivot Tables

  1. Creating Pivot Tables
  2. Number Formatting
  3. Designing Report Layout
  4. Sorting
  5. Filtering
  6. Drill-down: Expand/Collapse
  7. Summarize Data By
  8. Show Values as …
  9. Inserting Formulas

and more ...

Next Generation Excel: Advanced Business & Financial Reporting

Next Generation Excel: Advance...

1 Videos
Language - English, Arabic
06:06 Min
USD 399
Add to cart

Next Generation Excel: Advanced Business & Financial Reporting

There is no doubt that Excel is the accountant's, finance and business professional's best friend! You and I know how overwhelmed we are with the abundance of unstructured data. Monthly, quarterly and annual closing are immensely data driven and require moving and exporting data from 'ERPs' and databases to Excel. This hands-on course will advance your data massaging, modeling, integration and automation skills to new levels. You will also master normalization and be massaging of noisy data, preparation of reports, analysis and reconciliation.

This course is Excel-based allowing you to develop an exclusive level of expertise and adding immediate value to your job.

Dashboards & Business Reports Using Excel

Dashboards & Business Reports ...

1 Videos
Language - English, Arabic
01:25 Min
USD 199
Add to cart

Dashboards & Business Reports Using Excel

The goal of this Course is to show you how to leverage Excel functionality to build and manage better reporting mechanisms. Each Module in this Course provides a comprehensive review of the technical and analytical concepts that help you create better reporting components - components that can be used for both dashboards and reports.

Financial Statement Analysis Workshop

Financial Statement Analysis W...

1 Videos
Language - English, Arabic
03:41 Min
USD 499
Add to cart

Financial Statement Analysis Workshop

The ability to analyze companies is predicated on a set-of-skills that can only be taught by practitioners and experienced professionals. This course will provide you with the eight-building blocks of financial analysis. Tools and techniques, you can directly apply to any company and different industries. The course focuses on delegates performing actual analysis of publicly traded companies, compiling and analyzing data, then presenting their findings and recommendation. Don’t miss this course!
Financial Modeling Workshop

Financial Modeling Workshop

1 Videos
Language - English, Arabic
01:47 Min
USD 599
Add to cart

Financial Modeling Workshop

Making future investment decisions requires concert understanding of the financial modeling process. Starting from input variable to model design and presentation, delegates work on building several financial models from scratch. This course will equip delegates with real-life tools and techniques allowing them to build customized financial models. Excel is the name of the game!

Excel Reporting & Analysis For Hr Professionals

Excel Reporting & Analysis For...

1 Videos
Language - English, Arabic
07:41 Min
USD 299
Add to cart

Excel Reporting & Analysis For Hr Professionals

HR Professionals will learn the tips that save hours to resolve the difficulties they face on a daily basis in doing employee compensations, salary, leave, benefits etc. In this practical training, participants will learn formatting techniques to convert data from different sources, how to make the best use of most important formulas for HR. You will able to manipulate charts and diagrams, use logical functions, and link their spreadsheet to other worksheets and applications. Also learn how to automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.

Software tools enable us to be more productive and efficient. Learn how to leverage the powerful features of Excel for HR, auditing, and other HR tasks.  Explore the use of Excel as an audit and analysis tool, as well as, selected features that help prepare accurate reports.
Excel Vba Programming For Business Professionals

Excel Vba Programming For Busi...

1 Videos
Language - English, Arabic
01:20 Min
USD 299
Add to cart

Excel Vba Programming For Business Professionals

Microsoft Excel macro is a useful tool in the hands of Excel users. Macros are of a great help to reduce time and efforts of users to a great extent. If you need to perform repetitive tasks very often as a part of your job, then, make use of macro, as it will facilitate you to do so conveniently. A macro is a stored series of commands and functions that enable you to carry out your routine chores faster.

This class is designed to help students describe the concepts in and uses of Visual Basic for Applications, record and edit procedures, debug visual basic code, assign procedures to menus, objects, and keyboard shortcuts, use function procedures, and objects properties, and methods. In addition, students will learn to use interactive procedures, control procedures, automate procedures, customize Ribbon & Groups, and create user forms.
Analyzing And Visualizing Data With Power Bi

Analyzing And Visualizing Data...

1 Videos
Language - English, Arabic
02:39 Min
USD 299
Add to cart

Analyzing And Visualizing Data With Power Bi

Power Bi is a suite of business analytics tools that deliver insights throughout your organization. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis. Produce beautiful reports, then publish them for your organization to consume on the web and across mobile devices. Everyone can create personalized dashboards with a unique, 360-degree view of their business. And create scale across the enterprise, with governance and security built-in.