December 21, 2018
With 16 chart types in MS Excel, there are many choices to present information in a clear, engaging and professional manner. Each chart type has up to 7 sub-chart variations plus a large range of formatting options and variations. Maximize your use of this powerful Excel capability and take data […]
December 21, 2018
This intermediate course builds on the Level 1 course, demonstrating a range of effective and time-saving formulas and techniques. Learn how to confidently use functions that deal with text, data cleanse, lookups, dates, matching and tracing precedents and dependents. Understand and work effectively with fundamental and versatile calculation and analysis […]
December 21, 2018
Date and time functions can be used in Excel to display current updated time and date information. Dates can also be used to display, for example, a sequence of week days, and numerical value of days between 2 dates.
December 21, 2018
MATCH can be used instead of a LOOKUP function when you need to determine the position of a value in a list instead of the value itself. As an example, you may use the MATCH function to provide a value to be used in the row_num argument of the INDEX […]
December 21, 2018
Good table design is essential for the proper operation of Excel’s data management capabilities including sort, filter, consolidation, grouping, validation, PivotTable and Power Pivot. Planning table design is crucial to avoid future problems and challenges in managing data. Table design must comply with key standards and consideration of how data […]
December 20, 2018
Where you choose to display diverse data in a chart, you can add and format a secondary vertical Y axis for clarity in presentation. This may be best represented using a line chart.
December 20, 2018
Stacking appropriately scaled pictures or graphics in a column chart can enhance the user engagement and appeal of a chart.
December 20, 2018
To enhance chart readability and effectiveness, gridlines and axes can be managed by changing chart axis scale and display of major and minor, (or light) gridlines.
December 20, 2018
You can quickly change chart layout, display and style options to efficiently enhance chart effectiveness and user engagement.
December 20, 2018
Switching the column (X axis) and row (Y axis) orientation and display in a column chart can be useful to improve the representation and clarity of data.
December 20, 2018
You can add and remove individual chart elements such as axis titles, data labels, legends and gridlines to enhance chart effectiveness.
December 20, 2018
To present charts most effectively and professionally, it is essential to understand the techniques in moving and resizing charts, plot areas and chart elements efficiently.
December 20, 2018
Create a chart on a new sheet when you require a chart that is full screen and separate from your worksheet data.
December 20, 2018
Understanding chart types and elements is important before creating and formatting charts.
December 19, 2018
Use the ampersand (&) to join two or more data strings into one string. Cells with text, numbers and formulas can be joined into a single string Text added manually into a concatenation must be enclosed in “” and joined at each end with an ampersand (&)
November 9, 2018
Learn shortcuts and special techniques to build a dynamic professional presentation with expert configuration, formatting and conversion to a movie with sound track. Create your presentation using advanced and new features in PowerPoint to engage your audience more effectively. Format and configure presentations faster with confidence, understanding the expanded capabilities […]
November 4, 2018
The Picture with Caption layout provides 3 place-holders for a title, text content and picture.
November 4, 2018
Create, name and save your PowerPoint presentation file to your preferred location to establish good file management practice and minimise the risk of losing your work.
November 4, 2018
Backstage view and options display key information, provide preferences for working with presentations and manage the performance of PowerPoint.
November 2, 2018
Careful planning is essential in designing and presenting a successful professional PowerPoint presentation. Understanding the templates, themes and design idea features in PowerPoint will boost efficiency and can save significant time.