|
0. Create and run a presentation from the comfort of Excel
|
|
Summary:
Genie's Excel Presentation add-on can display presentation slides over an Excel worksheet. This article explains how to use the add-on to create and run a presentation all from within Excel.
|
Keywords:
Genie, GenieNews, Genie News, Presentation in Excel, Genie add-on, Display slides in Excel, Design Excel presentation
|
|
|
1. See two windows of a workbook at once
|
|
Summary:
It's often useful to be able to see two different sections of a worksheet simultaneously, such as totals and source data. This article explains how Genie can make this easy to achieve.
|
Keywords:
Genie, GenieNews, Genie News, Windows of workbook, two windows, same workbook
|
|
|
2. The Genie Menu shortcuts dialog box
|
|
Summary:
This article explains the functioning of the Genie Menu shortcuts dialog box.
|
Keywords:
Genie, GenieNews, Genie News, Genie menu shortcuts, Menu shortcuts
|
|
|
3. Drill down to source data with Genie
|
|
Summary:
This article explains how to use Genie's Formula drill-down feature to select, or filter to, the source data behind a SUMIF formula. The Formula drill-down can also show the source data behind many other Excel functions.
|
Keywords:
Genie, GenieNews, Genie News, Formula drill-down, SUMIF, Genie Formula drill-down
|
|
|
4. The Genie Formula drill-down dialog box
|
|
Summary:
This article explains the features of the Genie Formula drill-down dialog box.
|
Keywords:
Genie, GenieNews, Genie News, Formula drill-down, Genie Formula drill-down, drill-down dialog box
|
|
|
5. Use fill colour to sum
|
|
Summary:
A Genie user-defined function, SumByColorFill, totals those cells of a specified fill colour.
|
Keywords:
Genie, GenieNews, Genie News, fill colour, fill color, background colour, background color, SumByColorFill, sum by colour, sum by color
|
|
|
6. The Genie Menu sheet modify dialog box
|
|
Summary:
Learn how to use the Menu sheet modify dialog box to create custom Menu sheets by rearranging your menu items.
|
Keywords:
Genie, GenieNews, Genie News, Menu, Menu sheet, Menu sheet modify dialog box, Sheets Manager, Menu shortcuts dialog box
|
|
|
7. Customise your Menu sheet
|
|
Summary:
Learn how to customise an ESP-standard Menu worksheet for quick and convenient access to important components of your workbook.
|
Keywords:
Genie, GenieNews, Genie News, Navigate, Navigation, Menu, Menu sheet, Menu sheet modify dialog box, Contents, Index, ESP standard sheets
|
|
|
8. Copy to the same pattern
|
|
Summary:
Learn how to use Genie to copy cells to the same pattern.
|
Keywords:
Genie, GenieNews, Genie News, copy and paste to same pattern, copy, paste
|
|
|
9. Edit Genie shortcuts to avoid conflicts
|
|
Summary:
Learn how to edit Genie keyboard shortcuts if they conflict with other keyboard shortcuts on your computer
|
Keywords:
Genie, GenieNews, Genie News, keyboard shortcuts, Style box, Style apply dialog box, conflict
|
|